INFORMATION_SCHEMA PROCESSLIST
The PROCESSLIST table provides information about which threads are running.
PROCESSLIST
INFORMATION_SCHEMA
SHOW
ID
Id
USER
User
HOST
Host
DB
db
COMMAND
Command
TIME
Time
STATE
State
INFO
Info
Notes:
The PROCESSLIST table is a non-standard table. It was added in MySQL 5.1.7.
The following statements are equivalent:
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST SHOW PROCESSLIST
