mysqlreport

mysqlreport makes a friendly report of important MySQL status values. mysqlreport transforms the values from SHOW STATUS into an easy-to-read report that provides an in-depth understanding of how well MySQL is running. mysqlreport is a better alternative (and practically the only alternative) to manually interpreting SHOW STATUS.

Download mysqlreport

Latest version April 16 2008 v3.5 (changelog)

View and save mysqlreport from your web browser
— or —
Download mysqlreport with documentation and guide tar/gz or zip
— or —
wget hackmysql.com/scripts/mysqlreport from your terminal

Example Reports

Live demonstration
SELECT heavy before and after optimization
UPDATE heavy before and after optimization
Very Effective Query Cache
Bad read ratio (0.08)
Bad read ratio (0.04)
Bad table locks waited

The Guide To Understanding mysqlreport

The Guide To Understanding mysqlreport discusses the all sections of a mysqlreport report, what the values mean, and what is generally indicative of good and bad performance.

mysqlreport Documentation

The mysqlreport documentation provides basic information on usage and outlines all the available options.