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