Name

SHOW PROCESSLIST

Synopsis

SHOW [FULL] PROCESSLIST

This statement displays a list of connection threads running on the MySQL server. This 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.

SHOW PROCESSLIST\G
*************************** 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.

Get MySQL in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.