MySQL

Executes a SQL query on a database and returns a String value. Changes state if the first column of the query matches or doesn't match the searched string. If a second column is part of the result of the query then its content is displayed in the plugin output.Configuration: an account and a password of a user having the rights to execute the query, name of the database, SQL query, searched string (possible regex), presence status, absence status.
Prerequisite: The query must return only one row. The first column is compared with the string. The second column is used to display additional text in the plugin output.

Collects the rate of temporary tables created on disk rather than in memory on the MySQL database. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USAGE access to the MySQL database, alert threshold, critical threshold.

Collects the rate of failed table locks on the MySQL database. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USAGE access to the MySQL database, alert threshold, critical threshold.

Collects the rate of queries classified as slow on the MySQL server. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USAGE access to the MySQL database, alert threshold, critical threshold.

Collects the replication delay, in seconds, from the master MySQL server to the slave MySQL server. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USAGE access to the MySQL database, alert threshold, critical threshold.

Collects the number of current connections to the MySQL database. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USAGE access to the MySQL database, alert threshold, critical threshold.

Verifies that the MySQL server configuration has not been modified. Alerts if any changes have been made and specifies the directives that have been changed. Configuration: MySQL monitoring account, MySQL server connection port, configuration checksum. The configuration is done in two steps. The checksum parameter is set to 0 to initialize the check. This one returns the initial checksum corresponding to the current MySQL configuration. Then we set the checksum parameter with the one returned previously.

Collects the number of MySQL processes whose execution time exceeds one minute. This control notifies when the threshold is exceeded. Configuration: account and password of a user with USAGE access to the MySQL database, alert threshold, critical threshold.

Collects the index usage rate of MySQL database queries. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USAGE access to the MySQL database, alert threshold, critical threshold. The alert threshold is higher than the critical threshold.

Duration since the last server restart (takes into account restarts and crashes). Alert when a threshold is exceeded. Configuration: MySQL supervision account, TCP port of connection to the MySQL server, thresholds expressed in seconds and respecting the nagios format:
XX: alert if above XX
XX: : alert if below XX
XX:YY : alert if not between XX and YY

Controls the use of the thread cache. Measures the cache usage rate and alerts when the rate falls below a threshold. Configuration: MySQL monitoring account, MySQL server connection port, thresholds expressed as a percentage.

Controls table cache usage. Measures the table cache hit rate. Alerts if it is below a certain threshold. Configuration: MySQL supervision account, TCP port of connection to the server, thresholds in percentage.

Checks if the SQL replication process is running. Alerts if it is not. Configuration: MySQL monitoring account, TCP connection port.

Checks if the IO replication process is running. Alerts if it is not. Configuration: MySQL monitoring account, TCP connection port.

Executes an SQL query returning a number. Alerts if this number exceeds a threshold. Configuration: MySQL monitoring account, TCP connection port, thresholds, SQL query.

Measures the number of queries/sec out of the query cache that occur due to a memory shortage. Alerts if this number exceeds a threshold. A high value may indicate a too small query cache size. Configuration: MySQL monitoring account, TCP connection port, alert thresholds.

Controls the cache usage of SQL queries. Measures the hit rate and alerts if it is below a threshold. Configuration: MySQL monitoring account, TCP port to connect to the server, percentage thresholds.

Checks the number of open files against the maximum limit for the MySQL server. Alerts if this rate exceeds a threshold. Configuration: MySQL monitoring account, connection port, thresholds as a percentage of the maximum limit.

Controls the number of times per second that the database waits for the InnoDB log to be written to disk. A value too high indicates that this log is too small. Alert when this value exceeds a threshold. Configuration: MySQL monitoring account, TCP connection port, alert thresholds.

Controls the key cache usage of MyISAM tables. Measures the hit rate and alerts if it is below a certain threshold. Configuration: MySQL supervision account, TCP port of connection to the server, percentage thresholds.

Controls the establishment of the connection to the MySQL server. Measures the time to establish the connection. Alerts if this delay is higher than a threshold. Configuration: MySQL monitoring account, MySQL server connection port.

Number of occurrences / second that the Buffer Pool is expected to be available. Alert if it reaches an alert threshold. Configuration: MySQL monitoring account, TCP connection port, thresholds.

Controls the Buffer Pool usage of InnoDB tables. Measures the success rate and alerts if it is below a threshold. Configuration: MySQL monitoring account, TCP server connection port, percentage thresholds.

Retrieves the size of the databases and notifies if the server is not accessible. Configuration : Account on MySQL server