Name
SHOW PROCESSLIST
Synopsis
SHOW [FULL] PROCESSLIST
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. Here is an
example:
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, 2nd Edition 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.