Which statement will accomplish this?

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?

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’;

Explanation:



Leave a Reply 7

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


bobek

bobek

The answer should be A

Bruno

Bruno

The only table with “host” column are INFORMATION_SCHEMA.PROCESSLIST

Then A.

andre

andre

A is correct

C incorrect because will show this error :
Error 1054 (42S222): unknown column ‘host’ in ‘where clause’

Rajareddy VN

Rajareddy VN

Answer should be ‘A’