Administration MySQL

Mysql Report

Another tool of a similar nature is the MySQLReport tool which can be found at

Information can be found here about how to read and analyse the report that is produces from this link

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–
Connecting to||: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

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