kill slow processes

mysql-kill.sh

#!/bin/bash 
linecount=0
processes=$(echo "show processlist" | mysql -uroot -proot)
oldIfs=$IFS
IFS='
'
echo "Checking for slow MySQL queries..."
for line in $processes
do
    if [ "$linecount" -gt 0 ]
        then
            pid=$(echo "$line" | cut -f1)
            length=$(echo "$line" | cut -f6)
            query=$(echo "$line" | cut -f8)
            if [ "$length" -gt 60 ]
                then
                    #echo "$pid = $length"
                    echo "pid=$pid  -  time:$length secs. - query=$query \n"
                    killoutput=$(echo "kill query $pid" | mysql -uroot -proot)
                    echo "Result of killing $pid:  $killoutput\n\n"
            fi
    fi
    linecount=`expr $linecount + 1`
done
IFS=$oldIfs