[thelist] tuning MySQL

Ken Moore psm2713 at hotmail.com
Tue Nov 28 15:33:00 CST 2006


Hi all,

Matt,

You need to determine that you know something absolutely for certain. 
Otherwise, you are shooting in the dark. And, assuming that you experiement 
and get "good" results, you will know neither why it works or how much short 
of optimal you really are.

Start with:
SELECT Rec_ID
>From Table_One;

If this takes too long, then you have it down to DB set up or HW 
configuration or SW/HW incompatibility - or transmission if on a network. If 
you still have a record of the previous DB and system configurations, that 
would tend to (not for certain) eliminate those.

If that goes well, select a non ID field. Then both. Then do the same with 
Table_Two. Eventually, you will come upon the slowdown and that will narrow 
your search.

Ken


Matt McKeon asked:

>Hershel Robinson wrote:
> >> The two tables I'm working with are both less then 1MB, the DB size is
> >> only about 5MB. This PHP script/MySQL DB was working seemingly fine in
> >> our previous setup..
> >>
> >
> > Hmm, sounds odd. That's a tiny DB.
> >
> >
> >> Hope that makes it a little easier, o and its in a RHE 4 environment.
> >>
> >
> > And what was the previous environment, and MySQL version details?
> >
> > FWIW, in my experience MySQL paid support is generally good.
> >
> > Hershel
> >
> >
>
>Yeah, its not large that's why I was thinking a hardware/server config
>issue.
>
>The previous environment had the same versions of MySQL and PHP.
>Just different hardware.
>
>Does anyone have a sample MySQL conf file I could take a look at? Or
>some common config variables that I could tweak?
>
>--
>
>* * Please support the community that supports you.  * *
>http://evolt.org/help_support_evolt/
>
>For unsubscribe and other options, including the Tip Harvester
>and archives of thelist go to: http://lists.evolt.org
>Workers of the Web, evolt !

_________________________________________________________________
Get free, personalized commercial-free online radio with MSN Radio powered 
by Pandora http://radio.msn.com/?icid=T002MSN03A07001




More information about the thelist mailing list