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. "

./mysqlreport --user myusername --password --outfile report.out --host myhost --port 3306

For the full guide see http://hackmysql.com/mysqlreportguide