Build precise queries to find exactly what you need
Press ESC to close
Your review has been submitted and is pending approval.
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
Owner
John E. Vincent
Website
http://dev.lusis.org/nagios
Download URL
http://dev.lusis.org/nagios/check_mysql_stats
Compatible With
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
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.
It does not work.
You must be logged in to submit a review.
To:
From: