MySQL

check_mysql_count

Write a Review

Description:

Check row count in table. Possible to specify WHERE conditionals.

Current Version

0.02

Last Release Date

2011-11-21

Compatible With

  • Nagios 2.x
  • Nagios 3.x

Owner

Michal Sviba

Website

http://michal.myserver.cz/NagiosPlugin/

Download URL

http://michal.myserver.cz/NagiosPlugin/check_mysql_count.pl

License

GPL

Copy Page Link Recommend Login to Add to Favorites
Project Notes
Check row count in table. Possible to specify WHERE conditionals and CRIT and WARN count.
Reviews (1) Add a Review
Good idea, needs more work
by kristan, May 31, 2010

This script has fulfilled a check we need so I thought I'd share a slight addition: after the line $status = "Rows $state - $count rowsn"; add if ($count =~ m/D/) { $state = "CRITICAL"; $status = "$count n"; } This returns the MySql error (if there is one) rather than just returning OK when unable to connect to the server or the check is not correct... Also the condition needs to be an escaped string - ie. host="localhost" or if using NagiosQL to configure Nagios: host=\"localhost\"


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 Notes Reviews
Project Stats
Rating
4.3 (3)
Favorites
0
Views
104,284