我一般都是脚本kill
for list in
/server/mysql5.7/bin/mysql -hXXX.XXX.XXX.XXX-p'PASSWORD' -vvv -e " select id from INFORMATION_SCHEMA.processlist a where a.info is not null and (mem >=11474836480 or time >600);" |grep -Ev 'id|ID|iD|Id' |awk -F "|" '{print $2}'
do
echo $list
/server/mysql5.7/bin/mysql -hXXX.XXX.XXX.XXX-p’PASSWORD’ -vvv -e “select id,time,info,mem from INFORMATION_SCHEMA.processlist a where id=$list and a.info is not null;;” >/sh/killtestlog/date +%s
.log
/server/mysql5.7/bin/mysql -hXXX.XXX.XXX.XXX-p’PASSWORD’ -vvv -e " kill tidb $list ;"
done;