Skip to content

kirenotneb/check_mysql_counters

This branch is 6 commits behind jasonholtzapple/check_mysql_counters:master.

Folders and files

NameName
Last commit message
Last commit date
Apr 13, 2016
Apr 13, 2016
Dec 19, 2013
Apr 13, 2016
Dec 9, 2015
Dec 9, 2015
Dec 9, 2015
Dec 9, 2015
Dec 9, 2015

Repository files navigation

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:

  • CentOS6 MySQL 5.1 (mysql-server package): check_mysql_counters -H host -P port -u mysqluser -p mysqlpassword
  • 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

Then copy the correct check_mysql_counters.php template from the directory

  • centos_5_1_mysql_5_1
  • 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 the server executing the plugin.

MySQL database user - no special privileges required.

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
  • Kevin Pankonen - CentOS6 MySQL 5.1 (mysql-server) support

About

MySQL Performance Graphs with pnp4nagios

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • PHP 100.0%