Which query would you use to find connections that are in the same state for longer than
180 seconds?
A.
SHOW FULL PROCESSLIST WHEER Time > 180;
B.
SELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB
(NOW ( ), INTERVAL 180 SECOND) );
C.
SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE STATE <
(DATE_SUB (NOW ( ), INTERVAL 180 SECOND) );
D.
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 180;
D
A cannot work , but if try D its work.
The correct answer is D.
D