Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
New ListingsDirectory Tree
check_tablespace_mysql
Current Version
1.0
Last Release Date
2010-02-09
Compatible With
- Nagios 3.x
- Nagios 4.x
Owner
License
GPL
Hits
109423
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!
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:
http://nagios.fm4dd.com/plugins/manual/check_tablespace_mysql.htm
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
http://nagios.fm4dd.com/plugins/manual/check_tablespace_mysql.htm
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
Reviews (4)
byfrancoisd, July 20, 2015
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 ?
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 ?
byshashi_sid, December 9, 2014
0 of 1 people found this review helpful
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?
/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
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!
