SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO
FROM information_schema.PROCESSLIST
WHERE TIME > 1000
AND state<>‘SLEEP’
ORDER BY TIME DESC;
直接找时间长的就行,时间段的也好耗费不了多少CPU
SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO
FROM information_schema.PROCESSLIST
WHERE TIME > 1000
AND state<>‘SLEEP’
ORDER BY TIME DESC;
直接找时间长的就行,时间段的也好耗费不了多少CPU