December 17, 2009

Performance Tuning Using Tuning Primer and ATOP

The load was coming from MySQL and Apache. I tweaked httpd.conf and my.cnf files and the load has dropped considerably. If you need to tweak it further, I would recommend to install ATOP: http://www.atcomputing.nl/Tools/atop/download-atop.html and use that instead of top as that will show you a great deal more information as to what is causing the load. It is also very simple to use.

Lastly, I would recommend using Tuning Primer: https://launchpad.net/mysql-tuning-primer. It is also very easy to install and run. It will show you what you may want to further tweak within your my.cnf file.

No comments:

Post a Comment