Posted by htdev on October 9, 2012 at 10:10pm
We are wanting to tweak our MySQL server settings to get a bit more performance. Below are what the hosting company is recommending. Anyone have any comments or suggestions?
max_connections 85 from 64
wait_timeout 45 from 60
interactive_timeout 450 from 600
query_cache_size 128M from 96M
tmp_table_size 128M from 96M
max_heap_table_size 128M from 96M
innodb_buffer_pool_size 250M from the base default which was 132M
max_allowed_packet = 16M from 64M
Comments
You might as well increase
You might as well increase the followings:
- table_cache
- threat_cache_size
And for per-connection configuration, you can increase:
- sort_buffer_size
- threat_stack
be careful with the last two settings, as they are "per-connection" so if you increase one of them by 1M for instance, you are doing that for all the connections simultaneously.
Also enable the following on your DEV server:
- log_slow_queries
You can then flag the slow queries and work on optimizing them. You may also use MySQL tuner tools in order to achieve the same goal.
Please note that there are few other ways to achieve better performance on your website, and optimizing MySQL is one of them only. Consider reading this article which would help you a lot in this matter.
Thank you
Thank you