MySQL

check_tablespace_mysql

Write a Review

Description:

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

Compatible With

  • Nagios 3.x
  • Nagios 4.x

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

Copy Page Link Recommend Login to Add to Favorites
Project Photos
Project Notes
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
Reviews (4) Add a Review
does exactly what it is suposed to do
by francoisd, July 31, 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 ?


Issue with the pnp4nagios graphs
by shashi_sid, December 31, 2014

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?


Nice plugin - small fix
by Tontonitch, October 31, 2012

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


Thanks for sharing!
by jpcozar, August 31, 2011

Exactly, it was what I was looking for. It works really as expected. Thank you so much!


Add a Review

You must be logged in to submit a review.

Thank you for your review!

Your review has been submitted and is pending approval.

Recommend

To:


From:


Thank you for your recommendation!

Your recommendation has been sent.

Page Sections
Project Overview Project Photos Project Notes Reviews
Project Stats
Rating
4.4 (5)
Favorites
1
Views
109,197