Script to Kill MySQL Sleeping Processes

Create Script /bin/mysql_kill_sleepProc.sh

#!/bin/bash
echo ” ”

echo ‘###########################################’

date

mysqladmin -u root –password=<mysqlPassword> processlist|grep Sleep

for i in `mysqladmin -u root –password=<MysqlPASSWORD> processlist|grep Sleep|awk ‘{print $2}’`; do mysqladmin -u root –password=<MysqlPASSWORD> kill $i; done > /dev/null 2>&1

wc=`echo $?`

if test $wc == 0
then
echo “Mysql sleeping queries killed succesfully”
else
echo “Command Failed”
fi
================================
Set cronjob for every 10 minutes on Server

*/10 * * * * /bin/mysql_kill_sleepProc.sh > /var/log/mysql_query_kill.log

Neelesh Gurjar has written 122 articles