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. Which statement will accomplish this?
A.
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE
HOST=’192.168.1.15’;
B.
SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE HOST=’ 192.168.1.15’;
C.
SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE HOST=’
192.168.1.15’;
D.
SELECT * FROM INFORMATION_SCHEMA.INNODB_METEICS WHERE HOST=’
192.168.1.15’;
A
A