check_mysql_wrapper

Description

hack for nagios check_mysql binary – This wraps the information sent back into a format that then produces graphs from the output

When executing check_mysql normally the result is:

./check_mysql -H SERVER -P PORT -d DB -u DB_USER -p DB_PASS -w 5 -c 5
Uptime: 1553477 Threads: 17 Questions: 60192385 Slow queries: 1 Opens: 1395 Flush tables: 1 Open tables: 64 Queries per second avg: 38.746

With this wrapper:

./check_mysql_wrapper SERVER 3306 DB_NAME DB_USER PASS 5 5
MYSQL SERVER DB_NAME OK|Uptime=12626323 Threads=21 Questions=26632634 Slow_Queries=243 Opens=45 Flush_tables=1 Open_tables=39 Queries_ps_avg=2.109s;;;0

The results then produces graphs in pnp4nagios using the wrapper

Project Details