MySQL Performance Graphs with pnp4nagios

If you are managing MySQL servers, you’ve probably encountered Percona’s suite of enhanced database servers and management tools. Percona released a set of cacti templates (now part of the monitoring plugins toolkit) for measuring MySQL performance trends. I don’t use cacti but have a pretty extensive pnp4nagios setup, so I ported those templates to pnp4nagios. The results are below.

These graphs are very useful for visualizing trends in your database workload and identifying future problems before they occur. MySQL 5.1, MySQL 5.5, MySQL 5.6, and Percona 5.5 and 5.6 are supported. The amount of performance data is too large to be returned via NRPE, you will need a direct connection from Nagios to the database to use the plugin or else use check_by_ssh. A future version may address this problem by breaking up the plugin into multiple checks.

Downloads

Version 1.5 adds support for Percona 5.6 and fixes the Oracle 5.5 template.

check_mysql_counters – version 1.5

There is now a github repository for check_mysql_counters!

The following graphs are only available with Percona Server 5.5. Some are also available with Oracle 5.5 or later.

check_mysql_counters_013

check_mysql_counters_014

check_mysql_counters_015

check_mysql_counters_024

check_mysql_counters_016

check_mysql_counters_017

check_mysql_counters_018

check_mysql_counters_019

check_mysql_counters_020

check_mysql_counters_021

check_mysql_counters_022

check_mysql_counters_023