-- 查询非 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 列就可以强制杀掉对应进程