Devco1 Shell

Filename : mysql_bytes
back
#!/usr/bin/sh
# -*- sh -*-

: << =cut

=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

=cut

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}'