MySQL 通过 PROCESSLIST 表查看正在执行的 SQL,并手动 kill

发布时间 2023-06-01 01:06:52作者: Nihaorz
-- 查询非 sleep 进程
SELECT * FROM information_schema.PROCESSLIST WHERE COMMAND != "Sleep" ORDER BY TIME DESC;

-- 查询来自于 192.168.21.34 主机的进程
SELECT * FROM information_schema.PROCESSLIST WHERE HOST like "192.168.21.34:%" ORDER BY TIME DESC;

-- 查询来自于 192.168.21.34 主机的非 sleep 进程
SELECT * FROM information_schema.PROCESSLIST WHERE HOST like "192.168.21.34:%" AND COMMAND != "Sleep" ORDER BY TIME DESC;

通过 kill ID 列就可以强制杀掉对应进程