IT博客汇 | MySQL 5.6 Database Administrator-008-Which query would you use to find connections that are in the same state for longer than 180 seconds?

MySQL 5.6 Database Administrator-008-Which query would you use to find connections that are in the same state for longer than 180 seconds?

royalwzy发表于 2015-09-01 23:18:29

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;