SELECT * FROM `threads`
THREAD_ID
A unique thread identifier. |
NAME
Name associated with the server's thread instrumen… |
TYPE
FOREGROUND or BACKGROUND, depending on the thread … |
PROCESSLIST_ID
The PROCESSLIST.ID value for threads displayed in … |
PROCESSLIST_USER
Foreground thread user, or NULL for a background t… |
PROCESSLIST_HOST
Foreground thread host, or NULL for a background t… |
PROCESSLIST_DB
Thread's default database, or NULL if none exists. |
PROCESSLIST_COMMAND
Type of command executed by the thread. These corr… |
PROCESSLIST_TIME
Time in seconds the thread has been in its current… |
PROCESSLIST_STATE
Action, event or state indicating what the thread … |
PROCESSLIST_INFO
Statement being executed by the thread, or NULL if… |
PARENT_THREAD_ID
THREAD_ID of the parent thread, if any. Subthreads… |
ROLE
Unused. |
INSTRUMENTED
YES or NO for Whether the thread is instrumented o… |
---|