Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
Directory Tree
check_mysql_stats
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!
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
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.
Even with localhost database...
The results are good and relevant, but the plugin performance is poor.