Which query would you use to find connections that are in the same state for longer than 180 seconds?

Which query would you use to find connections that are in the same state for longer than
180 seconds?

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;



Leave a Reply 4

Your email address will not be published. Required fields are marked *


wajatmaka

wajatmaka

A cannot work , but if try D its work.

Stan

Stan

The correct answer is D.