mysql_bytes

#!/usr/bin/bash
# -*- sh -*-

# =head1 NAME
#
# mysql_bytes - Plugin to monitor the number of bytes sent from and
# received by mysql.
#
# =head1 CONFIGURATION
#
# The following environment variables are used:
#
#  mysqlopts - Options to pass to mysql
#  mysqladmin - Path to mysqladmin (default: "mysqladmin")
#
# If mysqladmin is not set, this plugin uses the system PATH to find
# mysqladmin
#
# =head1 AUTHOR
#
# Unknown author
#
# =head1 LICENSE
#
# GPLv2
#
# =head1 MAGIC MARKERS
#
#   #%# family=manual
#   #%# capabilities=autoconf

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

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

if [ "$1" = "config" ]; then
	echo 'graph_title MySQL throughput'
	echo 'graph_args --base 1024'
	# shellcheck disable=SC2016
	echo 'graph_vlabel bytes received (-) / sent (+) per ${graph_period}'
	echo 'graph_info Note that this is a old plugin which is no longer installed by default.  It is retained for compatability with old installations.'
	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

# shellcheck disable=SC2086
("$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}'