what-is-locking-up-mysql.sh

#!/bin/bash
SLEEP=1
THRESHOLD=500

while [ 1 ]
do
        threads=`mysqladmin stat | awk '{ print $4 }'`
        echo "Active threads: $threads"
        if [ $threads -gt $THRESHOLD ]; then
                log="/root/mysql-monitor/logs/sqls-$threads-`date +%s`.log"
                echo "SHOW FULL PROCESSLIST" | mysql > $log
                echo "Dumped the full processlist: $log"
        fi
        sleep $SLEEP
done