From 0a547add2f4cc264380d2dab2c472efe5a1d7094 Mon Sep 17 00:00:00 2001
From: Pim van den Berg
Date: Sat, 3 May 2014 19:17:16 +0200
Subject: graph.php: use JSON plugins instead of including PHP plugin files

A couple of big changes here. A lot of logic moved to graph.php.

The PHP plugin files have been rewritten to JSON. In these JSON files
*everything* is optional. Also *NOT* having a JSON plugin file won't
block you from having a graph. The JSON will just make the graphs
prettier (by having a title, y-axis title, legend, colors, etc..).

The Collectd types.db file is parsed and used to determine RRD content.
When things are not defined in the JSON it will fallback to a default.
---
 plugin/mysql.php | 140 -------------------------------------------------------
 1 file changed, 140 deletions(-)
 delete mode 100644 plugin/mysql.php

(limited to 'plugin/mysql.php')

diff --git a/plugin/mysql.php b/plugin/mysql.php
deleted file mode 100644
index 880b8c0..0000000
--- a/plugin/mysql.php
+++ /dev/null
@@ -1,140 +0,0 @@
-<?php
-
-# Collectd MySQL plugin
-
-require_once 'conf/common.inc.php';
-require_once 'type/GenericStacked.class.php';
-
-$obj = new Type_GenericStacked($CONFIG, $_GET);
-$obj->rrd_format = '%5.1lf%s';
-
-switch($obj->args['type'])
-{
-	case 'cache_result':
-		$obj->legend = array(
-			'qcache-not_cached' => 'Not Cached',
-			'qcache-inserts' => 'Inserts',
-			'qcache-hits' => 'Hits',
-			'qcache-prunes' => 'Lowmem Prunes',
-		);
-		$obj->colors = array(
-			'qcache-not_cached' => 'f0a000',
-			'qcache-inserts' => '0000ff',
-			'qcache-hits' => '00e000',
-			'qcache-prunes' => 'ff0000',
-		);
-		$obj->rrd_title = sprintf('MySQL query cache (%s)', $obj->args['pinstance']);
-		$obj->rrd_vertical = 'Queries/s';
-	break;
-	case 'cache_size':
-		$obj->legend = array(
-			'qcache' => 'Queries',
-		);
-		$obj->rrd_title = sprintf('MySQL query cache size (%s)', $obj->args['pinstance']);
-		$obj->rrd_vertical = 'Queries in cache';
-	break;
-	case 'mysql_commands':
-		$obj->rrd_title = sprintf('MySQL commands (%s)', $obj->args['pinstance']);
-		$obj->rrd_vertical = 'Issues/s';
-	break;
-	case 'mysql_handler':
-		$obj->order = array('commit', 'delete',  'read_first', 'read_key', 'read_next', 'read_prev', 'read_rnd', 'read_rnd_next', 'update',  'write', 'rollback');
-		$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';
-	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';
-	break;
-	case 'mysql_octets':
-		$obj->data_sources = array('rx', 'tx');
-		$obj->legend = 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';
-	break;
-	case 'threads':
-		$obj->legend = array(
-			'cached' => 'Cached',
-			'connected' => 'Connected',
-			'running' => 'Running',
-		);
-		$obj->colors = array(
-			'cached' => '00e000',
-			'connected' => '0000ff',
-			'running' => 'ff0000',
-		);
-		$obj->rrd_title = sprintf('MySQL threads (%s)', $obj->args['pinstance']);
-		$obj->rrd_vertical = 'Threads';
-	break;
-	case 'total_threads':
-		$obj->legend = array(
-			'created' => 'Created',
-		);
-		$obj->rrd_title = sprintf('MySQL created threads (%s)', $obj->args['pinstance']);
-		$obj->rrd_vertical = 'Created Threads';
-	break;
-	# mysql_qcache is removed since commit collectd-4.10.0-104-g9ae3541
-	case 'mysql_qcache':
-		$obj->data_sources = array('not_cached', 'inserts', 'hits', 'lowmem_prunes', 'queries_in_cache');
-		$obj->legend = 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';
-	break;
-	# mysql_threads is removed since commit collectd-4.10.0-105-g6c48fca
-	case 'mysql_threads':
-		$obj->data_sources = array('cached', 'connected', 'running', 'created');
-		$obj->legend = 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';
-	break;
-}
-
-$obj->rrd_graph();
-- 
cgit v1.1