#!/bin/sh
#
# Plugin to monitor the number of bytes sent from and received by mysql.
#
# Parameters:
#
# 	config
# 	autoconf
#
# Configuration variables
#
#   mysqlopts    - Options to pass to mysql
#
#%# family=auto
#%# capabilities=autoconf

MYSQLOPTS="$mysqlopts";
MYSQLADMIN=${mysqladmin:-mysqladmin}

if [ "$1" = "autoconf" ]; then
	$MYSQLADMIN --version 2>/dev/null >/dev/null
	if [ $? -eq 0 ]
	then
		$MYSQLADMIN $MYSQLOPTS extended-status 2>/dev/null >/dev/null
		if [ $? -eq 0 ]
		then
			echo yes
			exit 0
		else
			echo "no (could not connect to mysql)"
		fi
	else
		echo "no (mysqladmin not found)"
	fi
	exit 1
fi

if [ "$1" = "config" ]; then
	echo 'graph_title MySQL throughput'
	echo 'graph_args --base 1024'
	echo 'graph_vlabel bytes received (-) / sent (+) per ${graph_period}'
	echo 'graph_category mysql'
	echo 'recv.label transfer rate'
	echo 'recv.type DERIVE'
	echo 'recv.min 0'
	echo 'recv.draw LINE2'
	echo 'recv.max 80000000'
	echo 'recv.graph no'
	echo 'sent.label transfer rate'
	echo 'sent.type DERIVE'
	echo 'sent.min 0'
	echo 'sent.max 80000000'
	echo 'sent.draw LINE2'
	echo 'sent.negative recv'
	exit 0
fi

($MYSQLADMIN $MYSQLOPTS extended-status 2>/dev/null || ( echo Bytes_sent a a U; echo Bytes_received a a U)) | awk '/Bytes_sent/ { print "sent.value " $4} /Bytes_received/ { print "recv.value " $4}'
