PalominoDB Nagios Plugin for MySQL

This post has sample configurations, and an update, to the Nagios plugin called mysql_health_check.pl that PalominoDB has developed. Presentation slides, the presentation video, the whitepaper and the download link to the actual Nagios check are always up-to-date at http://palominodb.com/about-us/projects.

There has been exciting news for the Nagios plugin PalominoDB developed for MySQL — we now have –critical and –warning options for all modes (for –varcomp mode we only had a critical option before).

Here are some sample configurations (which are also seen in the slides):

To check rate of temporary tables:

define command {

command_name check_mysql_tmp_tables

command_line $USER1$/mysql_health_check.pl

–hostname $HOSTADDRESS$ –user myuser –password mypass

–cache-dir=/var/lib/nagios/mysql_cache

–max-cache-age=300 –mode=varcomp

–expression=”Created_tmp_tables/Uptime_since_flush_status”

–warning=”>(8/60)” –critical=”>(10/60)”

}

define service {

use generic-service

host_name __HOSTNAME__

service_description MySQL Temp Tables

check_command check_mysql_tmp_tables

}

To check long-running queries (and an example of using a parameter, setting 2 different values one for master servers and one for slave servers):