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

Login

Remember Me

check_mysql_stats

Last Release Date
2008-03-31
Compatible With
  • Nagios 1.x
  • Nagios 2.x
Owner
Hits
97633

Help Support Ethan Galstad's New Project:

Help Support Ethan

A Message From The Founder...

As the founder of Nagios, I'm asking for your help in a cause that's dear to my heart.

I'm launching a new project to help better the world by providing the information, ideas, and inspiration that I believe can improve the lives of people everywhere.

I know you're busy managing networks, but I would appreciate it if you would consider liking my Facebook page and showing your support for the content and messages I produce by sharing them with your friends and family.

You can learn more about my project by visiting ethangalstad.me/nagios. Thank you for your time. I wish you all the best in your endeavors, whatever they may be.

- Ethan

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.