This is a module for monitoring the MySQL SQL database server status (versions 3.22 and above).

It requires the tcl-sql package to be installed (can be found at http://jfontain.free.fr/).

Note that although this module is for Linux, the MySQL server to be monitored could be running on any remote machine, even an NT one (which is unlikely, since you need a reliable database system).

Data is drawn from the SHOW STATUS query results and initially displayed in 1 table with 2 data columns (with absolute and per second values):

view of the mystatus module tables

with the following rows (for the stable server version 3.22, the 3.23 development series featuring several more rows: see the SHOW STATUS documentation in the MySQL reference manual for further and up-to-date information):

Module options:

Examples:

$ moodss mystatus --host 1.2.3.4
$ moodss mystatus --host dbserver.company.com --port 3307
$ moodss mystatus --host dbserver.company.com --user status --password xxx