查询当前正在执行
SELECT * FROM information_schema.PROCESSLIST WHERE info IS NOT NULL ORDER BY TIME DESC;
拼接kill sql
SELECT CONCAT( 'kill ',ID ,';') FROM information_schema.PROCESSLIST WHERE info IS NOT NULL AND TIME > 10
mysql查看正在执行的sql语句并将其kill掉
最新推荐文章于 2024-07-29 03:47:56 发布