SHOW PROCESSLIST

This statement displays a list of connection threads running on the MySQL server. You'll need this if one of them is locked and slowing down the system.

Syntax

SHOW [FULL] PROCESSLIST

Explanation

This statement displays a list of connection threads running on the MySQL server. The statement requires SUPER privileges to be able to see all threads. Otherwise, only threads related to the current connection are shown. The FULL keyword shows the full text of the information field.

Examples

SHOW PROCESSLISTG
*************************** 1. row ***************************
     Id: 1
   User: root
   Host: localhost
     db: workrequests
Command: Query
   Time: 0
  State: NULL
   Info: SHOW PROCESSLIST

You can use this statement to determine a thread identification number to be used with the KILL statement.