Which command shows the currently running queries on a MySQL server?
- A SHOW TABLES
- B SHOW FULL PROCESSLIST
- C SHOW DATABASES
- D SHOW INDEX
Answer
SHOW FULL PROCESSLIST
SHOW FULL PROCESSLIST lists active connections and the statement each is executing, which is the first step when diagnosing a slowdown.





