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
Owner
Website
Download URL
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
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.
Page Sections
Project Stats
Rating
2.5 (2)
Favorites
0
Views
101,757