SHOW PROCESSLIST

Complete SHOW PROCESSLIST reference: FULL keyword for complete queries, PROCESS privilege, columns (Id, User, Host, db, Command, Time, State, Info).

Syntax

SHOW [FULL] PROCESSLIST

Description

SHOW PROCESSLIST shows which threads are running. You can also get this information from the information_schema.PROCESSLIST table or the mariadb-admin processlist command. If you have the PROCESS privilege, you can see all threads. Otherwise, you can see only your own threads (that is, threads associated with the MariaDB account that you are using). If you do not use the FULL keyword, only the first 100 characters of each statement are shown in the Info field.

The columns shown in SHOW PROCESSLIST are:

Name	Description
Id	The client's thread ID.
User	The username associated with the process.
Host	The host the client is connected to.
db	The default database of the process (NULL if no default).
Command	The command type. See Thread Command Values.
Time	The amount of time, in seconds, the process has been in its current state.
State	See Thread States.
Info	The statement being executed.
Progress	The total progress of the process (0-100%) (see Progress Reporting).

The information_schema.PROCESSLIST table contains a number of additional columns. See TIME_MS column in information_schema.PROCESSLIST for differences in the TIME column between MariaDB and MySQL.

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.

Threads can be killed using their thread_id or their query_id, with the KILL statement.

Since queries on this table are locking, if the performance_schema is enabled, you may want to query the THREADS table instead.

Examples

SHOW PROCESSLIST;
+----+-----------------+-----------+------+---------+------+------------------------+------------------+----------+
| Id | User            | Host      | db   | Command | Time | State                  | Info             | Progress |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+----------+
|  2 | event_scheduler | localhost | NULL | Daemon  | 2693 | Waiting on empty queue | NULL             |    0.000 |
|  4 | root            | localhost | NULL | Query   |    0 | Table lock             | SHOW PROCESSLIST |    0.000 |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+----------+

See Also

CONNECTION_ID()

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}