#!/bin/sh
while :
do
n=`/usr/local/webserver/mysql/bin/mysql -uroot -p"kdeceeedkd8>/ee" -e 'show processlist;' | grep -i locked |grep -i search_keyword | wc -l`
date=`date +%Y%m%d[%H:%M:%S]`
echo $n
if [ "$n" -gt 50 ]
then
for i in `/usr/local/webserver/mysql/bin/mysql -uroot -p"kdeceeedkd8>/ee" processlist | grep -i locked |grep -i search_keyword | awk '{print $2}'`
do
/usr/local/webserver/mysql/bin/mysql -uroot -p"kdeceeedkd8>/ee" kill $i
done
echo "killed it" >> /tmp/sleep.log
echo "$date : $n" >> /tmp/sleep.log
fi
sleep 10
done
解决锁表(大量查询语句把表锁)
最新推荐文章于 2024-08-17 08:57:25 发布