Skip to content

Instantly share code, notes, and snippets.

@infotek

infotek/includes services check_mysql.inc.php

Created November 7, 2016 02:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save infotek/a756d5481b74530f76d7e3092b1f5bdd to your computer and use it in GitHub Desktop.
Save infotek/a756d5481b74530f76d7e3092b1f5bdd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
includes services check_mysql.inc.php
<?php
//Jason Ellison <infotek@gmail.com>
//This is a test includes/services/check_mysql.inc.php
// provide some sane default
if ($service['service_param']) {
$dbname = $service['service_param'];
} else {
$dbname = "mysql";
}
$check_cmd = $config['nagios_plugins'] . "/check_mysql -H ".$service['hostname']." ".$dbname;
// Check DS is a json array of the graphs that are available
$check_ds = '{"mysql":"c","mysqluptime":"c","Qcache":"c"}';
// Build the graph data
$check_graph = array();
$check_graph['mysql'] = " DEF:DS0=" . $rrd_filename . ":Connections:AVERAGE ";
$check_graph['mysql'] .= " LINE1.25:DS0#" . $config['graph_colours']['mixed'][0] . ":'" . str_pad(substr("Connections", 0, 19), 19) . "' ";
$check_graph['mysql'] .= " GPRINT:DS0:LAST:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS0:AVERAGE:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS0:MAX:%0.0lf\l ";
$check_graph['mysql'] .= " DEF:DS1=" . $rrd_filename . ":Queries:AVERAGE ";
$check_graph['mysql'] .= " LINE1.25:DS1#" . $config['graph_colours']['mixed'][0] . ":'" . str_pad(substr("Queries", 0, 19), 19) . "' ";
$check_graph['mysql'] .= " GPRINT:DS1:LAST:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS1:AVERAGE:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS1:MAX:%0.0lf\l ";
$check_graph['mysql'] .= " DEF:DS1=" . $rrd_filename . ":Questions:AVERAGE ";
$check_graph['mysql'] .= " LINE1.25:DS1#" . $config['graph_colours']['mixed'][0] . ":'" . str_pad(substr("Questions", 0, 19), 19) . "' ";
$check_graph['mysql'] .= " GPRINT:DS1:LAST:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS1:AVERAGE:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS1:MAX:%0.0lf\l ";
$check_graph['mysql'] .= " DEF:DS2=" . $rrd_filename . ":Open_files:AVERAGE ";
$check_graph['mysql'] .= " LINE1.25:DS2#" . $config['graph_colours']['mixed'][0] . ":'" . str_pad(substr("Open_files", 0, 19), 19) . "' ";
$check_graph['mysql'] .= " GPRINT:DS2:LAST:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS2:AVERAGE:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS2:MAX:%0.0lf\l ";
$check_graph['mysql'] .= " DEF:DS3=" . $rrd_filename . ":Open_tables:AVERAGE ";
$check_graph['mysql'] .= " LINE1.25:DS3#" . $config['graph_colours']['mixed'][0] . ":'" . str_pad(substr("Open_tables", 0, 19), 19) . "' ";
$check_graph['mysql'] .= " GPRINT:DS3:LAST:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS3:AVERAGE:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS3:MAX:%0.0lf\l ";
$check_graph['mysql'] .= " DEF:DS4=" . $rrd_filename . ":Table_locks_waited:AVERAGE ";
$check_graph['mysql'] .= " LINE1.25:DS4#" . $config['graph_colours']['mixed'][0] . ":'" . str_pad(substr("Table_locks_waited", 0, 19), 19) . "' ";
$check_graph['mysql'] .= " GPRINT:DS4:LAST:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS4:AVERAGE:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS4:MAX:%0.0lf\l ";
$check_graph['mysql'] .= " DEF:DS5=" . $rrd_filename . ":Threads_connected:AVERAGE ";
$check_graph['mysql'] .= " LINE1.25:DS5#" . $config['graph_colours']['mixed'][0] . ":'" . str_pad(substr("Threads_connected", 0, 19), 19) . "' ";
$check_graph['mysql'] .= " GPRINT:DS5:LAST:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS5:AVERAGE:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS5:MAX:%0.0lf\l ";
$check_graph['mysql'] .= " DEF:DS6=" . $rrd_filename . ":Threads_running:AVERAGE ";
$check_graph['mysql'] .= " LINE1.25:DS6#" . $config['graph_colours']['mixed'][0] . ":'" . str_pad(substr("Threads_running", 0, 19), 19) . "' ";
$check_graph['mysql'] .= " GPRINT:DS6:LAST:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS6:AVERAGE:%0.0lf ";
$check_graph['mysql'] .= " GPRINT:DS6:MAX:%0.0lf\l ";
$check_graph['mysqluptime'] = " DEF:DS0=" . $rrd_filename . ":Uptime:LAST ";
$check_graph['mysqluptime'] .= " CDEF:cuptime=DS0";
$check_graph['mysqluptime'] .= " AREA:cuptime#EEEEEE:Uptime";
$check_graph['mysqluptime'] .= " LINE1.25:cuptime#36393D:";
$check_graph['mysqluptime'] .= " GPRINT:cuptime:LAST:%6.2lf GPRINT:cuptime:AVERAGE:%6.2lf";
$check_graph['mysqluptime'] .= " GPRINT:cuptime:MAX:%6.2lf GPRINT:cuptime:AVERAGE:%6.2lf\\l";
$check_graph['Qcache'] = " DEF:DS0=" . $rrd_filename . ":Qcache_free_memory:AVERAGE ";
$check_graph['Qcache'] .= " LINE1.25:DS0#" . $config['graph_colours']['mixed'][0] . ":'" . str_pad(substr("Qcache_free_memory", 0, 19), 19) . "' ";
$check_graph['Qcache'] .= " GPRINT:DS0:LAST:%9.2lf%s ";
$check_graph['Qcache'] .= " GPRINT:DS0:AVERAGE:%9.2lf%s ";
$check_graph['Qcache'] .= " GPRINT:DS0:MAX:%9.2lf%s\l ";
$check_graph['Qcache'] .= " DEF:DS1=" . $rrd_filename . ":Qcache_hits:AVERAGE ";
$check_graph['Qcache'] .= " LINE1.25:DS1#" . $config['graph_colours']['mixed'][0] . ":'" . str_pad(substr("Qcache_hits", 0, 19), 19) . "' ";
$check_graph['Qcache'] .= " GPRINT:DS1:LAST:%9.2lf ";
$check_graph['Qcache'] .= " GPRINT:DS1:AVERAGE:%9.2lf ";
$check_graph['Qcache'] .= " GPRINT:DS1:MAX:%9.2lf\l ";
$check_graph['Qcache'] .= " DEF:DS2=" . $rrd_filename . ":Qcache_inserts:AVERAGE ";
$check_graph['Qcache'] .= " LINE1.25:DS2#" . $config['graph_colours']['mixed'][0] . ":'" . str_pad(substr("Qcache_inserts", 0, 19), 19) . "' ";
$check_graph['Qcache'] .= " GPRINT:DS2:LAST:%9.2lf ";
$check_graph['Qcache'] .= " GPRINT:DS2:AVERAGE:%9.2lf ";
$check_graph['Qcache'] .= " GPRINT:DS2:MAX:%9.2lf\l ";
$check_graph['Qcache'] .= " DEF:DS3=" . $rrd_filename . ":Qcache_lowmem_prune:AVERAGE ";
$check_graph['Qcache'] .= " LINE1.25:DS3#" . $config['graph_colours']['mixed'][0] . ":'" . str_pad(substr("Qcache_lowmem_prune", 0, 19), 19) . "' ";
$check_graph['Qcache'] .= " GPRINT:DS3:LAST:%9.2lf ";
$check_graph['Qcache'] .= " GPRINT:DS3:AVERAGE:%9.2lf ";
$check_graph['Qcache'] .= " GPRINT:DS3:MAX:%9.2lf\l ";
$check_graph['Qcache'] .= " DEF:DS4=" . $rrd_filename . ":Qcache_not_cached:AVERAGE ";
$check_graph['Qcache'] .= " LINE1.25:DS4#" . $config['graph_colours']['mixed'][0] . ":'" . str_pad(substr("Qcache_not_cached", 0, 19), 19) . "' ";
$check_graph['Qcache'] .= " GPRINT:DS4:LAST:%9.2lf ";
$check_graph['Qcache'] .= " GPRINT:DS4:AVERAGE:%9.2lf ";
$check_graph['Qcache'] .= " GPRINT:DS4:MAX:%9.2lf\l ";
$check_graph['Qcache'] .= " DEF:DS5=" . $rrd_filename . ":Qcache_queries_in_c:AVERAGE ";
$check_graph['Qcache'] .= " LINE1.25:DS5#" . $config['graph_colours']['mixed'][0] . ":'" . str_pad(substr("Qcache_queries_in_c", 0, 19), 19) . "' ";
$check_graph['Qcache'] .= " GPRINT:DS5:LAST:%9.2lf ";
$check_graph['Qcache'] .= " GPRINT:DS5:AVERAGE:%9.2lf ";
$check_graph['Qcache'] .= " GPRINT:DS5:MAX:%9.2lf\l ";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment