check_mysql_health is a plugin for the Shinken (Nagios) software that allows you to monitor a MySQL database. Among the list of metrics are time to login, index usage, bufferpool hit rate, query cache hit rate, slow queries, temp tables on disk, table cache hit rate, connected threads, and many more. Requirements are either a DBD::mysql Perl module or a MySQL client package.
|Tags||Systems Administration Database MySQL Diagnostics Monitoring Nagios shinken|
Release Notes: innodb modes now detect problems with the InnoDB engine. A --labelformat option was added so that groundwork no longer complains (the maximum label length is 19 characters). The plugin can now be used with the OMD framework.
Release Notes: This release fixes a very nasty bug when using sql-mode and the parameter name2.
Release Notes: This release adds the modes threads-created, threads-running, threads-cached, connects-aborted, and clients-aborted. It fixes a severe bug when loading dynamic extensions. It adds the mode table-fragmentation. The mode SQL can now have non-numerical output that is compared to a string/regexp. There is a new –dbthresholds parameter. A new mode report can be used to output only the bad news.
Release Notes: An open-files mode was added. A bug in the pnp template was fixed. An extra-opts parameter was added.
Release Notes: Compatibility with MySQL 4.x was improved.