This is a module for monitoring the MySQL SQL database server (versions 3.22 and above) processes. The process privilege is required for this module to work (see the SHOW syntax documentation in the MySQL reference manual for further information).

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 PROCESSLIST query results and initially displayed in 1 table:

view of the myprocs module tables

with the following columns:

Module options:

Examples:

$ moodss myprocs --host 1.2.3.4
$ moodss myprocs --host dbserver.company.com --port 3307
$ moodss myprocs --host dbserver.company.com --user root --password xxx
$ moodss myprocs --dsn mydb --user status --password xxx