You are having problems with connections from a specific host (192.168.1.15) not closing down correctly. You want to find the state of the threads from that host check for long-running queries…

Question

Options

• ASELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE HOST='192.168.1.15';
• BSELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE HOST=' 192.168.1.15';
• CSELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE HOST=' 192.168.1.15';
• DSELECT * FROM INFORMATION_SCHEMA.INNODB_METEICS WHERE HOST=' 192.168.1.15';

• A
  71% (24)
• B
  18% (6)
• C
  3% (1)
• D
  9% (3)

No community discussion yet for this question.