mysql 删除异常进程脚本

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

#!/bin/bash   # mysql 5.6 version # Author :  thinklxr # Time : 2020.07.10   Host="$1" User="$2" Pass="$3" Port="$4"     # 管理员账户执行   if [ -z "$Host" ] then echo " Variable null HostName" break elif [ -z "$User" ] then echo " Variable null UserName" break elif [ -z "$Pass" ] then echo " Variable null PassWord" break elif [ -z "$Port" ] then echo " Variable null Port" break else read -p '输入要查询的用户: ' USERNAME   mysql -h $Host -u $User -p$Pass -e "show processlist;"|grep $USERNAME >> $Host-`date +%Y%m%d-%H%M%S`.log   for Kid in $(mysql -h $Host -u $User -p$Pass -e "show processlist;"|grep $USERNAME|grep -E "Sleep|Query|locked"|grep -vE "information_schema|performance_schema"|awk '{print $1}') do   echo -e "\033[33mkill $Kid\033[0m" mysqladmin $mysql -h $Host -u $User -p$Pass kill ${Kid}; done fi