As the web traffic starts growing, the CMS based websites take more time to load and therefore MySQLserver needs to be optimized or at least it should utilize availableserver resources judiciously in order to meet the future traffic demands. Database caching can significantly improve your CMS performance during peak hours. Although the main factor that affectsdatabase performance is how queries have been written but still significant performance boost can be achieved by tweaking MySQL settings. Lets learn how to tweak MySQL settings to optimize and improve its caching in order to get optimum performance and reduce serverload.
The MySQL database server has a configuration file that allows us to change some parameters and configuration settings. The default settings may not solve your purpose, so you need to edit them in order to gain the maximum benefit. The file is called my.ini ormy.cnf and is usually found in /etc/ or /etc/mysql/. You can use vi editor to open the file and edit it.
- query_cache_size
- key_buffer
- table_cache
- sort_buffer
- read_rnd_buffer_size
- thread_cache
- tmp_table_size
Read more http://blogmee.info/index.php/reduce-server-load-by-mysql-caching-and-optimization/
No comments:
Post a Comment