MySQL

check_mysql_stats

Description:

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.

Current Version

Last Release Date

2008-03-31

Compatible With

  • Nagios 1.x
  • Nagios 2.x

Nagios CSP

Meet The New Nagios Core Services Platform

Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.

Monitoring Made Magically Better

  • Nagios Core on Overdrive
  • Powerful Monitoring Dashboards
  • Time-Saving Configuration Wizards
  • Open Source Powered Monitoring On Steroids
  • And So Much More!
Project Notes
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) Add a Review
work good but..
by opalanque, October 31, 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.
Helpful? Yes  No 
Usage
by hasegeli, August 31, 2011
It does not work.
Helpful? Yes  No 
Add a Review

You must be logged in to submit a review.

Thank you for your review!

Your review has been submitted and is pending approval.

Recommend

To:


From:


Thank you for your recommendation!

Your recommendation has been sent.

Project Stats
Rating
2.5 (2)
Favorites
0
Views
101,734