MysqlReport – Makes a friendly report of important MySQL status values
The benefit of mysqlreport is that it allows you to very quickly see a wide array of performance indicators for your MySQL server which would otherwise need to be calculated by hand from all the various SHOW STATUS values. For example, the Index Read Ratio is an important value but it’s not present in SHOW STATUS; it’s an inferred value (the ratio of Key_reads to Key_read_requests).
Install Mysqlreport on ubuntu
First you need to download the file in the correct location
sudo chmod 755 mysqlreport
Mysqlreport Help options as follows
mysqlreport --user root --password
Enter the mysql server root password and you should see similar to the following output