MySQL Optimisation Tool – mysqlreport
If you’ve ever ran, as I do, a busy webserver, then you will appreciate any help you can get when it comes to optimising the server in order to deal with those difficult busy times.
One such tool that I’ve come across recently is mysqlreport. It summarises all the relevent mysql variables & statuses into related categories according to heirarchies of importance.
The report has 14 sections, not all generated – according to the server configuration. As expected keys, queries & questions, sorting, table usage, and connections are the most important and top the list.
The tool also has excellent documentation to help set up and interpret the generated report.
There are a numner of tools ou there to help run, configure and maintain MySQL. This is one of the most useful I’ve found… and it’s free!
Get it here
