解决锁表（大量查询语句把表锁）

    #!/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