From 2250a6eb776093178aa340c3b284c9363e51ac95 Mon Sep 17 00:00:00 2001
From: Pim van den Berg
Date: Tue, 12 Oct 2010 21:52:50 +0200
Subject: plugin: add mysql plugin

---
 plugin/mysql.php | 103 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 103 insertions(+)
 create mode 100644 plugin/mysql.php

(limited to 'plugin')

diff --git a/plugin/mysql.php b/plugin/mysql.php
new file mode 100644
index 0000000..607e223
--- /dev/null
+++ b/plugin/mysql.php
@@ -0,0 +1,103 @@
+<?php
+
+# Collectd MySQL plugin
+
+require_once 'conf/common.inc.php';
+require_once 'type/GenericStacked.class.php';
+require_once 'inc/collectd.inc.php';
+
+$obj = new Type_GenericStacked($CONFIG);
+$obj->width = $width;
+$obj->heigth = $heigth;
+
+switch($obj->args['type'])
+{
+	case 'mysql_commands':
+		$obj->generate_colors();
+		$obj->rrd_title = sprintf('MySQL commands (%s)', $obj->args['pinstance']);
+		$obj->rrd_vertical = 'Issues/s';
+		$obj->rrd_format = '%5.1lf%s';
+	break;
+	case 'mysql_handler':
+		$obj->colors = array(
+			'commit' => 'ff0000',
+			'delete' => 'ff00e7',
+			'read_first' => 'cc00ff',
+			'read_key' => '3200ff',
+			'read_next' => '0065ff',
+			'read_prev' => '00fff3',
+			'read_rnd' => '00ff65',
+			'read_rnd_next' => '33ff00',
+			'update' => 'cbff00',
+			'write' => 'ff9800',
+			'rollback' => '000000',
+		);
+		$obj->rrd_title = sprintf('MySQL handler (%s)', $obj->args['pinstance']);
+		$obj->rrd_vertical = 'Invocations';
+		$obj->rrd_format = '%5.1lf%s';
+	break;
+	case 'mysql_locks':
+		$obj->colors = array(
+			'immediate' => 'ff0000',
+			'waited' => '00ff00',
+		);
+		$obj->rrd_title = sprintf('MySQL locks (%s)', $obj->args['pinstance']);
+		$obj->rrd_vertical = 'locks';
+		$obj->rrd_format = '%5.1lf%s';
+	break;
+	case 'mysql_octets':
+		$obj->data_sources = array('rx', 'tx');
+		$obj->ds_names = array(
+			'rx' => 'Receive',
+			'tx' => 'Transmit',
+		);
+		$obj->colors = array(
+			'rx' => '0000ff',
+			'tx' => '00b000',
+		);
+		$obj->rrd_title = sprintf('MySQL traffic (%s)', $obj->args['pinstance']);
+		$obj->rrd_vertical = 'Bits per second';
+		$obj->rrd_format = '%5.1lf%s';
+	break;
+	case 'mysql_qcache':
+		$obj->data_sources = array('not_cached', 'inserts', 'hits', 'lowmem_prunes', 'queries_in_cache');
+		$obj->ds_names = array(
+			'not_cached' => 'Not Cached',
+			'inserts' => 'Inserts',
+			'hits' => 'Hits',
+			'lowmem_prunes' => 'Lowmem Prunes',
+			'queries_in_cache' => 'Queries in Cache',
+		);
+		$obj->colors = array(
+			'not_cached' => 'f0a000',
+			'inserts' => '0000ff',
+			'hits' => '00e000',
+			'lowmem_prunes' => 'ff0000',
+			'queries_in_cache' => 'cccccc',
+		);
+		$obj->rrd_title = sprintf('MySQL query cache (%s)', $obj->args['pinstance']);
+		$obj->rrd_vertical = 'Queries/s';
+		$obj->rrd_format = '%5.1lf%s';
+	break;
+	case 'mysql_threads':
+		$obj->data_sources = array('cached', 'connected', 'running', 'created');
+		$obj->ds_names = array(
+			'cached' => 'Cached',
+			'connected' => 'Connected',
+			'running' => 'Running',
+			'created' => 'Created',
+		);
+		$obj->colors = array(
+			'cached' => '00e000',
+			'connected' => '0000ff',
+			'running' => 'ff0000',
+			'created' => 'cccccc',
+		);
+		$obj->rrd_title = sprintf('MySQL threads (%s)', $obj->args['pinstance']);
+		$obj->rrd_vertical = 'Threads';
+		$obj->rrd_format = '%5.1lf%s';
+	break;
+}
+
+collectd_flush($obj->identifiers);
+$obj->rrd_graph();
-- 
cgit v1.1