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

Below is the syntax for this command. Text within square brackets (i.e, [ and ] ) are optional. Choices are separated by bars (i.e, | ). Ellipses preceded by a comma indicates a repeating pattern. Ellipses before or after syntax are used to highlight a relevant except from the larger syntax. Text displayed in italic letters represent text that should be replaced with the specific names related to the database (e.g., column with the name of the column).

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.