The SHOW [FULL] PROCESSLIST statement: Section 12.4.5.30, “SHOW PROCESSLIST Syntax”

The SHOW PROFILE statement: Section 12.4.5.32, “SHOW PROFILES Syntax”

The INFORMATION_SCHEMA PROCESSLIST table: Section 20.23, “The INFORMATION_SCHEMA PROCESSLIST Table”

The mysqladmin processlist command: Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

Id is the connection identifier for the client associated with the thread.

User and Host indicate the account associated with the thread.

db is the default database for the thread, or NULL if none is selected.

Command and State indicate what the thread is doing.

Most states correspond to very quick operations. If a thread stays in a given state for many seconds, there might be a problem that needs to be investigated.

Time indicates how long the thread has been in its current state. The thread's notion of the current time may be altered in some cases: The thread can change the time with SET TIMESTAMP = value. For a thread running on a slave that is processing events from the master, the thread time is set to the time found in the events and thus reflects current time on the master and not the slave.

Info contains the text of the statement being executed by the thread, or NULL if it is not executing one. By default, this value contains only the first 100 characters of the statement. To see the complete statements, use SHOW FULL PROCESSLIST.