MySQL: SHOW PROCESS LIST reference

Command

Ensure your users has the PROCESS privilege and then run:

SHOW FULL PROCESSLIST

This will list all the operations being performed by threads within the MySQL server. Useful for debugging issues like too many connections or timeouts.

Example output

Kill a thread

Identify the Id of the thread that’s problematic and kill it with:

KILL <ID>

Links

• MySQl docs