- Repository
- Munin (2.0)
- Last change
- 2018-06-30
- Graph Categories
- Family
- manual
- Capabilities
- Language
- Shell
- License
- GPL-2.0-only
mysql_slowqueries
Name
mysql_slowqueries - Plugin to monitor the number of slow queries on a mysql-server
Configuration
The following environment variables are used by this plugin:
mysqlopts - Options to pass to mysql
Author
Unknown author
License
GPLv2
Magic Markers
#%# family=manual
#%# capabilities=autoconf
#!@@GOODSH@@
# -*- sh -*-
: << =cut
=head1 NAME
mysql_slowqueries - Plugin to monitor the number of slow queries on a
mysql-server
=head1 CONFIGURATION
The following environment variables are used by this plugin:
mysqlopts - Options to pass to mysql
=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 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 slow queries'
echo 'graph_args --base 1000 -l 0'
# shellcheck disable=SC2016
echo 'graph_vlabel slow queries / ${graph_period}'
echo 'graph_category mysql'
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 'queries.label slow queries'
echo 'queries.type DERIVE'
echo 'queries.min 0'
echo 'queries.max 500000'
exit 0
fi
/usr/bin/printf "queries.value "
# shellcheck disable=SC2086
("$MYSQLADMIN" $MYSQLOPTS status 2>/dev/null || echo a a a a a a a a U) | awk '{print $9}'