Home Directory Plugins Databases MySQL check_mysql_stats

Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com


Remember Me

Directory Tree


Last Release Date
Compatible With
  • Nagios 1.x
  • Nagios 2.x
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
check_mysql_stats was designed to monitor various InnoDB and general mysql stats. At the time, I could not find a plugin that specifically did what I wanted.
It has one odd requirement that was designed to minimize the additional overhead of the frequent queries to the database server.

All of the output from 'SHOW GLOBAL VARIABLES' is stored in a shared memory cache with a lifetime of 10 minutes. Some of these values (such as max_connections) are slow changing so there's no need to continually ask for this information.

Here are a few examples:
**Thread Cache Hit Ratio**
``check_mysql_stats -H localhost -U nagios -P nagios -w 80 -c 75 -t``
OK: Thread cache hit ratio is 92.86% | hit_ratio=92.86;80;75;0;100
Reviews (2)
byopalanque, October 23, 2013
The plugin works fine but sometimes there is timeouts.
Even with localhost database...

The results are good and relevant, but the plugin performance is poor.
byhasegeli, August 15, 2011
It does not work.