check_mysql_stats(PNP4Nagios)

Nagios Plugin with PNP4Nagios Template (no alerting) Producing (12 but it can be adjusted easily if one needs different values) MySQL Performance graphs.

Written in Perl but it does NOT Require DBI Modules to be installed as DB Query is handled via MySQL Client from Bash.

Template is Easy to understand and adjust (you do not need to know dataset numbers in RRD Tool) – Variables are addressed in associative array (in Perl and PHP Script) with the exact same names like MySQL Variables (fetched from ‘INFORMATION_SCHEMA.GLOBAL_STATUS’ and ‘INFORMATION_SCHEMA.GLOBAL_VARIABLES’).

Tested with MySQL 5.6 and MariaDB 10 (should work with other versions as well).

Remote or local execution possible (tested with ‘check_by_ssh’ but should work with NRPE also).

usage: ./check_mysql_stats.pl [-H] host [-P] port [-u] user [-p] password
example: ./check_mysql_stats.pl -H localhost -P 3306 -u nagios -p supergeheim

Enjoy 😉