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