Note: this module is obsolete. You are encouraged to use the myshow --variables module combination instead.
This is a module for monitoring the MySQL SQL database server variables (latest versions in the 4 series).
On UNIX type platforms, it requires the mysqltcl package (at http://www.xdobry.de/mysqltcl/) for connection via the native MySQL protocol, or the tclodbc package (at http://tclodbc.sourceforge.net/) for connection via ODBC (Open DataBase Connectivity).
On Windows platforms, please read the install.txt file.
Data is drawn from the SHOW VARIABLES query results and initially displayed in 1 table with the variables data column on the left (sorted in alphabetical order) and the values on the right.
In order to reduce the displayed table height, variables related to table types (bdb, innodb, myisam) are not displayed if they are not enabled or supported by the server.
The displayed variables depend on the database server version. Full help is provided for each variable through widget tips (also called balloons).
When an error occurs (communicating with the database server or any other type), all non numeric cells become empty, while the remaining cells are set to the numeric void value (displayed as ?). A descriptive error message is also generated in such a case.
$ moodss myvars --host 188.8.131.52 $ moodss myvars --host dbserver.company.com --port 3307 $ moodss myvars --host dbserver.company.com --user jdoe --password xxx $ moodss myvars --dsn mydb --user status --password xxx
If you use Tcl/Tk 8.4.1 or above with the Tcl Threads package 2.5 or above, then the module will use threads for the database connection. This means that the core (moodss user interface for example) cannot be hung (moodss menus not responding, window not being updated, ...) when the connection with the database is failing.
You can check that moodss actually is in threads mode by looking at the bottom line of the module help window, while moodss is running: a status line will indicate whether threads are in use.