Project Categories MySQL

Nagios plugin for MySQL. Checks the MySQL processlist for long running threads. Threads which have been running for a long time could signal that something…

MySQL

Check NDB Memory

"ndb_mgm" is required on the server (can be downloaded and extracted from the source of mysql-cluster). Node IDs are given as argument (--nodes) and should…

MySQL

check_mysql_wrapper

MySQL

check_mk_heartbeat

This plugin is checking timestamp of the last table update (on the slave side) and comparing it with the current system time. You must choose…

MySQL

check_mysql_slavestatus

This is MySQL Replication check. There are 3 checkpoints. 1. Seconds_Behind_Master 2. Slave_IO_Running 3. Slave_SQL_Running Check the difference between Master and Slave on MySQL. When…

MySQL

Check MySQL Slave

Pretty simple to use. ARG1 = username ARG2 = password $USER1$/check_mysqlslave.sh -u $ARG1$ -p $ARG2$ -H $HOSTADDRESS$ Make sure the user specified has either SUPER…

MySQL

check_mysql_counters

check_mysql_counters ==================== check_mysql_counters is a nagios plugin and pnp4nagios template designed to show you performance trends in your MySQL servers. To use, copy the appropriate…

MySQL

mysql

MySQL

check_mysql_replication

Description: Checks master and slave log positions as well as slave status. Usage: ./check_mysql_replication.sh -H Script assumes: * it is run from the master server…

MySQL

Check MySQL Table Status

MySQL

MySQL Replication Deadlock Recovery

The best practice to handle deadlocks (after eliminating them from the code) is recovering from them. Unfortunately, MySQL Replication does not recover automatically from these…