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):

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):
- number of connections that has been aborted because the client has died without closing the connection properly
- number of tries to connect to the server that has failed
- number of implicit temporary tables that have been created while executing statements
- number of delayed insert handler threads in use
- number of rows written with INSERT DELAYED
- number of rows written with INSERT DELAYED for which some error occurred
- number of executed FLUSH commands
- number of requests to delete a row from a table
- number of requests to read the first row in a table
- number of requests to read a row based on a key
- number of requests to read next row in key order
- number of requests to read a row based on a fixed position
- number of requests to update a row in a table
- number of requests to insert a row in a table
- number of used blocks in the key cache
- number of requests to read a key block from cache
- number of physical reads of a key block from disk
- number of requests to write a key block to cache
- number of physical writes of a key block to disk
- maximum number of connections that have been in use simultaneously
- keys blocks in the key cache that have changed but have not yet been flushed to disk
- number of rows waiting to be written in INSERT DELAY queues
- number of tables that are open
- number of files that are open
- number of streams that are open
- number of tables that have been opened
- number of queries sent to the server
- number of threads that are not sleeping
- number of queries that have taken more than long_query_time
- time the server has been up
Module options:
-
--host
host name or IP address where the database server is running (defaults to 127.0.0.1).
-
--p (--port)
port used by the database server. 3306 is used internally if not specified.
-
--user
database user name (defaults to current user).
-
--password
database password for user (no default).
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