Home Directory Plugins Databases MySQL check_mysql_stats(PNP4Nagios)

Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com

Login

Remember Me

check_mysql_stats(PNP4Nagios)

Rating
0 votes
Favoured:
0
Current Version
0.9
Last Release Date
2018-05-16
Compatible With
  • Nagios 3.x
  • Nagios 4.x
  • Nagios XI
License
GPL
Hits
504
Files:
FileDescription
check_mysql_stats.plNagios Plugin
mysql_stats.phpPNP4Nagios Template
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
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 ;-)