Another tool of a similar nature is the MySQLReport tool which can be found at http://hackmysql.com.
Information can be found here about how to read and analyse the report that is produces from this link http://hackmysql.com/mysqlreportguide.
You can load it up remotely and build it on your server in a similar way making use of an HTTP tool like CURL or WGET etc:
–2011-11-13 02:58:47– http://hackmysql.com/scripts/mysqlreport
Resolving hackmysql.com… 22.214.171.124
Connecting to hackmysql.com|126.96.36.199|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 38873 (38K) [application/x-perl]
Saving to: `mysqlreport’
100%[======================================>] 38,873 –.-K/s in 0.1s
2011-11-13 02:58:47 (254 KB/s) – `mysqlreport’ saved [38873/38873]
Once loaded give the newly installed file execute permission with the following command
chmod +x mysqlreport1.pl
You then call it by passing through the details of the system you want to analyse e.g:
mysqlreport --user root --host localhost --password mypsw100