plugin-mysql_size: mysql_size.5

#!/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}
MYSQL_VER="4.1"

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 'graph_args --base 1000'
        for DB in $($MYSQL $MYSQLOPTS -s -e 'show databases'); 
        do 
           DB=`echo $DB |  sed "s/^[^A-Za-z_]/_/" | sed "s/[^A-Za-z0-9_]/_/g"`
           echo "$DB.label $DB size (bytes)"
           echo "$DB.info $DB size"
           echo "$DB.type GAUGE"
           echo "$DB.draw LINE2"
        done
        exit 0
fi

MT=$($MYSQL --version | grep '4.0' 2>&1);
if echo $MT | grep "4.0" >/dev/null; then
  MYSQL_VER=4.0
elif echo $MT | grep "3.23" >/dev/null; then
  MYSQL_VER=3.23
fi

for DB in $($MYSQL $MYSQLOPTS -s -e 'show databases'); 
do 
        echo -n "$DB" | sed "s/^[^A-Za-z_]/_/" | sed "s/[^A-Za-z0-9_]/_/g"
        echo -n ".value "
        if [ $MYSQL_VER = "4.0" -o $MYSQL_VER = "3.23" ]; then
          $MYSQL $MYSQLOPTS -s -e "SHOW TABLE STATUS FROM \`$DB\`" \
            | awk 'BEGIN{s=0}{s+=$6;s+=$8}END{printf "%d\n", s}';
        else
          $MYSQL $MYSQLOPTS -s -e "SHOW TABLE STATUS FROM \`$DB\`" \
            | awk 'BEGIN{s=0}{s+=$7;s+=$9}END{printf "%d\n", s}';
        fi
done