Home Directory Plugins Databases MySQL check_mysql_counters

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_counters

Current Version
1.5
Last Release Date
2013-12-19
Compatible With
  • Nagios 3.x
License
BSD
Hits
72300
Files:
FileDescription
check_mysql_counters_1.5.tar.gznagios plugin and pnp4nagios template
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
Graphs a large selection of mysql counters for visualizing database performance. Not an alerting plugin - merely collects data. Requires pnp4nagios.
check_mysql_counters
====================

check_mysql_counters is a nagios plugin and pnp4nagios template designed to
show you performance trends in your MySQL servers.

To use, copy check_mysql_counters to your nagios libexec directory if you
are using MySQL 5.1, check_mysql_counters_55 if you are using MySQL 5.5,
check_mysql_counters_56 if you are using MySQL 5.6,
check_mysql_counters_p55 if you are using Percona 5.5, or
check_mysql_counterS_p56 if you are using Percona 5.6

Then create a MYSQL_COUNTERS nagios service that executes the plugin:

* Oracle 5.1: check_mysql_counters -H host -P port -u mysqluser -p mysqlpassword
* Oracle 5.5: check_mysql_counters_55 -H host -P port -u mysqluser -p mysqlpassword
* Oracle 5.6: check_mysql_counters_56 -H host -P port -u mysqluser -p mysqlpassword
* Percona 5.5: check_mysql_counters_p55 -H host -P port -u mysqluser -p mysqlpassword
* Percona 5.6: check_mysql_counters_p56 -H host -P port -u mysqluser -p mysqlpassword

As far as I know, the database user does not need any special privileges
to gather statistics.

Then copy the correct check_mysql_counters.php template from the directory

* oracle_5_1_with_innodb_plugin
* oracle_5_1_without_innodb_plugin
* oracle_5_5
* oracle_5_6
* percona_5_5
* percona_5_6

to your pnp4nagios template directory - the default location is
/usr/local/pnp4nagios/share/templates

The plugin currently does not support being called by NRPE (the data returned is too large), a future version might address this.

Requirements
============

* MySQL 5.1 - supported
* MySQL 5.5 - untested
* MySQL 5.6 - supported
* Percona Server 5.5 - supported
* Percona Server 5.6 - supported

php/mysqli on your Nagios server for the plugin

It has been tested with pnp4nagios 0.6

Authors
=======

* Jason Holtzapple - original plugin and templates
* Jesse Morgan - Oracle MySQL 5.6 support and various bug fixes