[thelist] tuning MySQL

Matt McKeon matt at camadro.com
Tue Nov 28 15:04:33 CST 2006


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?




More information about the thelist mailing list