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

Question

Options

• ASHOW FULL PROCESSLIST WHEER Time > 180;
• BSELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB (NOW ( ),
• CSELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE STATE < (DATE_SUB (NOW ( ),
• DSELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 180;

• A
  13% (7)
• B
  7% (4)
• C
  4% (2)
• D
  76% (42)

No community discussion yet for this question.