| 用途 | 会话与运行 SQL 排查 |
|---|---|
| 语法 | SHOW [FULL] PROCESSLIST |
| 字段 | Id / User / Host / db / Command / Time / State / Info |
常用查询
常用查询
SHOW FULL PROCESSLIST;
SELECT id, user, host, db, command, time, state, info
FROM information_schema.processlist
WHERE command <> 'Sleep'
ORDER BY time DESC
LIMIT 20;只看长耗时查询
只看长耗时查询
SELECT id, time, state, LEFT(info,100) AS sql_head
FROM information_schema.processlist
WHERE time > 5 AND command='Query'
ORDER BY time DESC;KILL 前先确认是 SELECT 还是 DML/DDL；大事务被终止会触发长时间回滚。