#!/bin/bash
/usr/local/mysql/bin/mysql -uroot -p'Hdkj@idc3' -se"show full processlist"|grep -v 'root'|grep -v 'system'|grep 'Query'|awk '{if($6>60){print "kill "$1";"}}' > /tmp/k.txt
/usr/local/mysql/bin/mysql -uroot -p'Hdkj@idc3' -se"source /tmp/k.txt"
2. sql语句
SELECT CONCAT('KILL ', id, ';') FROM information_schema.processlist WHERE state = 'Sleep' AND TIME > <阈值>;
本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
