There was a very handful tool for checking on mysql performance – mysqlreport.
The tool was available for download from here:
Currently the site and the development process of mysqlreport is suspended in flavor of Percona Toolkit. Despite this, the author has uploaded the latest versions of mysqlreport in his github account.
I have uploaded mysqlreport here as a handy place for me to download it, so you could use one of the following sources to download it: