Home Directory Plugins Databases MySQL check_mysql_stats

Search Exchange

Search All Sites

Nagios Log Server Now Available - Download Now

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

Login

Remember Me

check_mysql_stats

Bookmark and Share

Last Release Date
2008-03-31
Compatible With
  • Nagios 1.x
  • Nagios 2.x
Owner
E-mail
Hits
84995
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``
**OUTPUT**
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.