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.