This is a module for monitoring the MySQL SQL database server error log (latest versions in the 4 series).

On UNIX type platforms, it requires the mysqltcl package (at for connection via the native MySQL protocol, or the tclodbc package (at for connection via ODBC (Open DataBase Connectivity).
On Windows platforms, please read the install.txt file.

view of the myerrorlog module tables

Data is displayed in 1 table with the following columns:


When the module is launched, a few MySQL variables, such as the data directory, are retrieved from the server using a query. Then the server error log file is monitored for new messages, which when they appear are sorted according to their importance level and their time of occurrence. Note that all messages are regrouped according to their format and their number of occurrences displayed.

The latest messages are marked as new, with older messages from previous polls displayed with the type old, up to the maximum number of rows (see --rows option). Note that there always is a message of type top, which is the most important message among the new. This particular message row may be empty if there were no new messages during the last poll interval, which allows the administrator to set a threshold on the presence of text in the message column of the top row, in order for example to be warned by an email message containing the most important error message when it occurs.

Monitoring remote server requires remote shell functionality (using rsh or the recommended ssh), since the error log, by its nature, cannot be accessed using a SQL query.

Module options:


You may set a threshold on the importance level column of the top row, in order for example to be warned with an email message when a critical message arrives (level greater or equal to 5).