MySQL Monitoring and Tuning
I own / run a fairly large site (www.skylinesaustralia.com) which is on the cliche PHP/MySQL setup. The database is fairly large with the 'posts' table being 3.4 Million rows. As its also a non profit site, I try to keep the costs associated with hosting a site this large to a minimum.
The site is on a single box with 4 x 10k sas drives, 4 cores and 2gb of ram. I started seeing big load spikes due to MySQL lock contention in the logs and needed to tune a few different aspects of the db (We are slowly moving to innodb engines from MyISAM).
Where I am trying to go with this is that I found a script named Tuning Primer to be a fantastic tool in tuning MySQL for optimum performance. While it doesnt delve into the more complex, technical side of things, it certainly helps if you are not great with MySQL's running gear (like me).
The other tool that I think everybody with a MySQL server should have, is Innotop which is a monitoring app that will show you a running processlist as well as lots of other data.
Both scripts are simple to setup and use and do not take any (or much at all) of your resources.
No related posts.