plugin-mysql_size: mysql_size

#!/bin/sh
#
# Plugin to monitor the size of databases in a mysql-server. 
#
# Copyright: Rune Nordbøe Skillingstad <rune.skillingstad@ntnu.no>
#
# Parameters supported:
#
#       config
#       autoconf
#
# Configuration variables
#
#       mysqlopts    - Options to pass to mysql
#
#%# family=auto
#%# capabilities=autoconf

MYSQLOPTS="$mysqlopts"
MYSQL=${mysql:-mysql}

if [ "$1" = "autoconf" ]; then
        $MYSQL --version 2>/dev/null >/dev/null
        if [ $? -eq 0 ]
        then
                $MYSQL $MYSQLOPTS -s -e "SHOW TABLE 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 (mysql not found)"
        fi
        exit 1
fi

if [ "$1" = "config" ]; then
        echo 'graph_title MySQL database sizes'
        echo 'graph_vlabel bytes'
        echo 'graph_category mysql'
        echo 'threads.label mysql size'
        echo 'graph_args --base 1000'
        for DB in $($MYSQL $MYSQLOPTS -s -e 'show databases'); 
        do 
           echo "$DB.label $DB size (bytes)"
           echo "$DB.info $DB size"
           echo "$DB.type GAUGE"
           echo "$DB.draw LINE2"
        done
        exit 0
fi

for DB in $($MYSQL $MYSQLOPTS -s -e 'show databases'); 
do 
        echo -n "$DB.value "
        $MYSQL $MYSQLOPTS -s -e "SHOW TABLE STATUS FROM $DB" \
          | awk 'BEGIN{s=0}{s+=$6;s+=$8}END{printf "%d\n", s}'; 
done