The Information Schema PROCESSLIST
table contains information about running threads.
Similar information can also be returned with the SHOW [FULL] PROCESSLIST
statement, or the mysqladmin processlist
command.
It contains the following columns:
Column | Description | Added |
---|---|---|
ID |
Connection identifier. | |
USER |
MariaDB User. | |
HOST |
Connecting host. | |
DB |
Default database, or NULL if none. |
|
COMMAND |
Type of command running, corresponding to the Com_ status variables. See Thread Command Values. |
|
TIME |
Seconds that the thread has been in its current state. | |
STATE |
Current state of the thread. See Thread States. | |
INFO |
Statement the thread is executing, or NULL if none. |
|
TIME_MS |
Time in milliseconds with microsecond precision that the thread has been in its current state (see more). | MariaDB 5.1 |
STAGE |
The stage the process is currently in. | MariaDB 5.3 |
MAX_STAGE |
The maximum number of stages. | MariaDB 5.3 |
PROGRESS |
The progress of the process within the current stage (0-100%). | MariaDB 5.3 |
MEMORY_USED |
Memory in bytes used by the thread. | MariaDB 10.0.1 |
EXAMINED_ROWS |
Rows examined by the thread. Only updated by UPDATE, DELETE, and similar statements. For SELECT and other statements, the value remains zero. | MariaDB 10.0.1 |
QUERY_ID |
Query ID. | MariaDB 10.0.5 |
INFO_BINARY |
Binary data information | MariaDB 10.1.5 |
Note that as a difference to MySQL, in MariaDB the TIME
column (and also the TIME_MS
column) are not affected by any setting of @TIMESTAMP
. This means that it can be reliably used also for threads that change @TIMESTAMP
(such as the replication SQL thread). See also MySQL Bug #22047.
As a consequence of this, the TIME
column of SHOW FULL PROCESSLIST
and INFORMATION_SCHEMA.PROCESSLIST
can not be used to determine if a slave is lagging behind. For this, use instead the Seconds_Behind_Master
column in the output of SHOW SLAVE STATUS.
Note that the PROGRESS
field from the information schema, and the PROGRESS
field from SHOW PROCESSLIST
display different results. SHOW PROCESSLIST
shows the total progress, while the information schema shows the progress for the current stage only.. To retrieve a similar "total" Progress value from information_schema.PROCESSLIST
as the one from SHOW PROCESSLIST
, use
SELECT CASE WHEN Max_Stage < 2 THEN Progress ELSE (Stage-1)/Max_Stage*100+Progress/Max_Stage END AS Progress FROM INFORMATION_SCHEMA.PROCESSLIST;
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST\G *************************** 1. row *************************** ID: 9 USER: msandbox HOST: localhost DB: NULL COMMAND: Query TIME: 0 STATE: Filling schema table INFO: SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST TIME_MS: 0.351 STAGE: 0 MAX_STAGE: 0 PROGRESS: 0.000 MEMORY_USED: 85392 EXAMINED_ROWS: 0 QUERY_ID: 15 INFO_BINARY: SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST TID: 11838 *************************** 2. row *************************** ID: 5 USER: system user HOST: DB: NULL COMMAND: Daemon TIME: 0 STATE: InnoDB shutdown handler INFO: NULL TIME_MS: 0.000 STAGE: 0 MAX_STAGE: 0 PROGRESS: 0.000 MEMORY_USED: 24160 EXAMINED_ROWS: 0 QUERY_ID: 0 INFO_BINARY: NULL TID: 3856 ...
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-processlist-table/