sajad torkamani

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

MySQL: SHOW PROCESS LIST reference

Kill a thread

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

KILL <ID>

Links

Tagged: MySQL

Leave a comment

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