mysql perfomance_tunning

perfomance_tunning

Do check things on key_buffer_size query_check_size and query_cache_type.

For a 8GB RAM system we can set the following to get few improvements:

to check the current values (at) mysql prompt:
show variables like 'key_buffer_size';
show variables like 'query_cache_size';
show variables like 'query_cache_type';

to update the values:
set global key_buffer_size=3221225472;                         [ 3 GB ]
set global query_cache_size=268435456;                        [256 MB ]
set global query_cache_type=ON;                

Do monitor the memory information such as swap and physical memory after changes and you might like to check the slow query log file to find still the same query is taking long time or not.