Build precise queries to find exactly what you need
Press ESC to close
Your review has been submitted and is pending approval.
This plugin checks the tablespace size of a specific MySQL Server database against WARN and CRIT thresholds. It returns the current tablespace size and the number of data files belonging to this database. The plugin can be called in 'reporting' mode, returning the space values withouth checking against a threshold. This is helpful if the tablespace only needs to be graphed as a trend over time.
Current Version
1.0
Last Release Date
2010-02-09
Owner
Frank
Website
http://nagios.fm4dd.com/plugins/manual/check_tablespace_mysql.htm
Download URL
http://nagios.fm4dd.com/plugins/source/check_tablespace_mysql.htm
License
GPL
Compatible With
The plugin requires the database to be set up for accepting network connections and being reachable through that network port from the Nagios server. The plugin uses the MySQL JDBC driver, this driver must be installed and found through the Java classpath on the server executing this plugin. For more information, please see the manual page for this plugin at:
MySQL table space handling depends on the configured storage engine, default is MyISAM. For more information see http://www.fm4dd.com/howto/db-monitoring.htm
BUT i have a problem, our tablespace are big and i think i've hit the maximum. higher, i get a java error. this is warning, or the number maximum allowed for a check 2147483647 java -classpath /usr/lib64/nagios/plugins/ check_tablespace_mysql localhost 3306 databasename "user id" "password" 2147483647 270000000 is ok but if i change the warning and add1 byte, 2147483648 produce error message java -classpath /usr/lib64/nagios/plugins/ check_tablespace_mysql localhost 3306 databasename "user id" "password" 2147483648 270000000 Exception in thread "main" java.lang.NumberFormatException: For input string: "2147483648" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) at java.lang.Integer.parseInt(Integer.java:499) at java.lang.Integer.parseInt(Integer.java:527) at check_tablespace_mysql.main(check_tablespace_mysql.java:74) what can i change on the java code to make this working ?
First of all Thanks for this great tool. /usr/bin/java -classpath /usr/local/nagios/libexec/ check_tablespace_mysql 3306 "Nagios" "Nagios@123" -d Output - Tablespace OK: 18048 KBytes I got the below error. 2014-12-10 03:20:27 [1974] [2] No pattern match in function _parse(: 546 datafiles. 18048 KB ) 2014-12-10 03:20:27 [1974] [1] Invalid Perfdata detected Is there some pnp4nagios template for this plugin as well?
Hi, Nice plugin, useful for db size tracking A small fix for monitoring mysql 5.0 and 5.1: change 'round (' to 'round(' (without the space) to avoid the "round function does not exist" message. (generally avoid the space when using functions) An enhancement could also be to follow the plugin development guidelines for the performance data output. Regards, Yannick
Exactly, it was what I was looking for. It works really as expected. Thank you so much!
You must be logged in to submit a review.
To:
From: