Build precise queries to find exactly what you need
Press ESC to close
Your review has been submitted and is pending approval.
Replacement for check_mysql that allows to set thresholds for any variables in SHOW STATUS or for similar SQL queries. Data is also made available for graphing or other use (graphing templates enclosed). The plugin will determine appropriate "SHOW STATUS" code depending on version of mysql and you can specify custom SELECT in place of "SHOW STATUS" as well.
Current Version
0.94
Last Release Date
2012-03-31
Owner
William Leibzon
Website
http://william.leibzon.org/nagios/
Download URL
License
GPL
Compatible With
This MYSQL check plugin does “SHOW STATUS” command on mysql server and can issue alerts if selected variables are above/below given number(s). It also returns all variables as performance data for further nagios 2.0 post-processing.
The variables you can use include but are not limited to: * Threads_running * Threads_connected * Threads_cached * Open_tables * Open_files * Innodb_row_lock_current_waits * Qcache_free_memory * Qcache_total_blocks * Delayed_errors * Delayed_writes * Key_blocks_not_flushed * Slave_running * Slow_launch_threads * Slow_queries You can check more then one (as many as needed) variables at same time. Full list of variables you can use is at: http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.htm
Version 0.8 has been posted in December 2007 that fixes previous limitations and allows to fully specify both upper and lower thresholds in nagios plugin specification compatible way. Additional enhancements are: 1. When you have Mysql 5.0.2 or above the plugin will issue ‘SHOW GLOBAL STATUS’ instead of ‘SHOW STATUS’ 2. Instead of plugin doing ‘SHOW STATUS’ you can now specify custom SQL query (some other SHOW command or SELECT with two columns of data in the output) and set conditions and attribute checks using data. 3.Version 09 now supports nagios plugin specification for specifying threshold (start:end and @start:end) in addition to my custom format (>,25″ -H nagios -v
The alerting seems rock solid, but I can not get the graphing working with the check_mysqld.php file as provided. I keep getting Undefined offset errors instead of graphs. What am I doing wrong?
Another great plugins thanks. Just a hint, for ubuntu make sure you have done: sudo apt-get install libdbi-perl lidbd-mysql-perl
You must be logged in to submit a review.
To:
From: