check_mysql_stats(PNP4Nagios)

Submit review Recommend Print Contact Owner

Rating

0 votes

Favoured:

Current Version

0.9

Last Release Date

2018-05-16

Compatible With

Nagios 3.x
Nagios 4.x
Nagios XI

Owner

juraj.havrila

Download URL

github.com/juraj-havrila/check_mysql_stats

License

GPL

Hits

5959

Files:

File	Description
check_mysql_stats.pl	Nagios Plugin
mysql_stats.php	PNP4Nagios Template

Meet The New Nagios Core Services Platform

Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.

Download Now

Monitoring Made Magically Better

Nagios Core on Overdrive
Powerful Monitoring Dashboards
Time-Saving Configuration Wizards
Open Source Powered Monitoring On Steroids
And So Much More!

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 ;-)

Reviews (0)

Be the first to review this listing!

Nagios, the Nagios logo, and Nagios graphics are the servicemarks, trademarks, or registered trademarks owned by Nagios Enterprises. All other servicemarks and trademarks are the property of their respective owner. The files and information on this site are the property of their respective owner(s). Nagios Enterprises makes no claims or warranties as to the fitness of any file or information on this website, for any purpose whatsoever. In fact, we officially disclaim all liability. We do, however, think these community contributions are pretty damn cool. Website Copyright © 2009-2024 Nagios Enterprises, LLC. All rights reserved.