[OSM-dev] MySQL tuning tips

Nick Hill nick at nickhill.co.uk
Mon Oct 2 10:00:57 BST 2006


Hello Andreas

Thank you for that. I checked the config, and found the key_buffer_size 
set very low. I have just set it to 1/4 of the available memory. I have 
also set the query cache from 16M to 64M.

We'll see what difference this makes.

Andreas Brauchli wrote:
> stumbled upon this today..
> http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
> 
> andreas
> 




More information about the dev mailing list