This is a module for monitoring the MySQL SQL database server status (latest versions in the 3.23 or 4 series).

It requires the mysqltcl package (at http://www.xdobry.de/mysqltcl/) for connection via the native MySQL protocol, or the tclodbc package (at http://sourceforge.net/projects/tclodbc) for connection via ODBC (Open DataBase Connectivity).

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 2 tables (the second being specific to queries counters) with 2 data columns (with absolute and per second values):

view of the mystatus module tables

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
$ moodss mystatus --dsn mydb --user status --password xxx