plugin-mysql_thread_extended: mysql_threads_extended

#!/bin/sh
#
# Plugin to monitor the number of threads on a mysql-server. Faster than
# ps_mysql.
# Added Threads_connected by Michael Mende <debian@menole.net>
#
# Parameters:
#       
#       config
#       autoconf
#
# Configuration variables
#
#       mysqlopts    - Options to pass to mysql
#
# $Log$
# Revision 1.2  2004/05/20 13:57:12  jimmyo
# Set categories to some of the plugins.
#
# Revision 1.1  2004/01/02 18:50:00  jimmyo
# Renamed occurrances of lrrd -> munin
#
# Revision 1.1.1.1  2004/01/02 15:18:07  jimmyo
# Import of LRRD CVS tree after renaming to Munin
#
# Revision 1.6  2003/11/07 17:43:16  jimmyo
# Cleanups and log entries
#
#
#
#%# family=auto
#%# capabilities=autoconf

MYSQLOPTS="$mysqlopts"
MYSQLADMIN=${mysqladmin:-mysqladmin}

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

if [ "$1" = "config" ]; then
        echo 'graph_title MySQL threads extended'
        echo 'graph_order threads_connected threads_running'
        echo 'graph_vlabel connected / running'
        echo 'graph_category mysql'
        echo 'graph_args --base 1000'

        echo 'threads_connected.label threads connected'
        echo 'threads_connected.type GAUGE'

        echo 'threads_running.label threads running'
        echo 'threads_running.type GAUGE'

        exit 0
fi

$MYSQLADMIN $MYSQLOPTS extended-status | grep Threads_ | awk '/Threads_(connected|running)/ { res[tolower($2)]=$4 } END {for (var in res)print substr(var,0,length(var)+1)".value "res[var] }'