- Repository
- Munin (2.0)
- Last change
- 2018-06-30
- Graph Categories
- Family
- manual
- Capabilities
- Language
- Shell
- License
- GPL-2.0-only
mysql_bytes
Name
mysql_bytes - Plugin to monitor the number of bytes sent from and received by mysql.
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
Author
Unknown author
License
GPLv2
Magic Markers
#%# family=manual
#%# capabilities=autoconf
#!@@GOODSH@@
# -*- 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}'