Pages

11 Dec 2014

My Most Useful MySQL Performance Tools

Here is a list of my most useful tools that I use when doing performance audits.

Please note, I am writing this mainly for myself, because I sometimes end up trying to find them in my other blog post about mastering indexing and this may save me time as well as a few changes that have happened over the years.

I have been using MONyog - MySQL Monitoring Tool and pretty amazed by it. It is an agent-less monitoring tool and still able to access and manipulate the slow-query log of the MySQL server. Earlier I use to write cron jobs for similar tasks.

Not just the slow query log, it also manipulates data from general query log and mysql error log to be presented to the user in a very intuitive way. It use queries like show global variables, show global status, show slave status, show full processlist etc to get data about the MySQL server status at different intervals specified by the user.

Post MySQL version 5.5 it makes use of the Performance schema database to fetch and manipulate data with almost negligible overhead. I am surprised a the amount of data it provides to the DBA. Should definitely give it a try.