SHOW [FULL] PROCESSLIST
SHOW PROCESSLIST
shows you which threads are running. You can also get this information from the information_schema.PROCESSLIST
table or the mysqladmin 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 | Introduced |
---|---|---|
ID |
The client's process 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. For a slave SQL thread before MariaDB 10.1, this is the time in seconds between the last replicated event's timestamp and the slave machine's real time. | |
STATE |
See Thread States. | |
INFO |
The statement being executed. | |
PROGRESS |
The total progress of the process (0-100%) (see Progress Reporting). | MariaDB5.3 |
See TIME_MS
column in information_schema.PROCESSLIST
for differences in the TIME
column between MariaDB and MySQL.
The information_schema.PROCESSLIST
table contains the following additional columns:
Name | Description | Introduced |
---|---|---|
TIME_MS |
The amount of time, in milliseconds, the process has been in its current state. | MariaDB5.1 |
STAGE |
The stage the process is currently in. | MariaDB5.3 |
MAX_STAGE |
The maximum number of stages. | MariaDB5.3 |
PROGRESS |
The progress of the process within the current stage (0-100%). | MariaDB5.3 |
MEMORY_USED |
The amount of memory used by the process. | MariaDB10.0.1 |
EXAMINED_ROWS |
The number of rows the process has examined. | MariaDB10.0.1 |
QUERY_ID |
Query ID. | MariaDB10.0.5 |
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, since MariaDB 10.0.5, 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.
SHOW FULL PROCESSLIST; +---------+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-------+-----------+------+---------+------+-------+-----------------------+ | 1988880 | dbart | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST | +---------+-------+-----------+------+---------+------+-------+-----------------------+ SELECT * FROM information_schema.processlist; +---------+-------+-----------+------+---------+------+-----------+----------------------------------------------+---------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | +---------+-------+-----------+------+---------+------+-----------+----------------------------------------------+---------+ | 1988880 | dbart | localhost | NULL | Query | 0 | executing | SELECT * FROM information_schema.processlist | 0.444 | +---------+-------+-----------+------+---------+------+-----------+----------------------------------------------+---------+
SHOW FULL PROCESSLIST; +-----+------+-----------+------+---------+------+-------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +-----+------+-----------+------+---------+------+-------+-----------------------+----------+ | 126 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST | 0.000 | +-----+------+-----------+------+---------+------+-------+-----------------------+----------+ SELECT * FROM information_schema.processlist; +-----+--------+-----------+------+---------+------+-----------+----------------------------------------------+---------+-------+-----------+----------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | STAGE | MAX_STAGE | PROGRESS | +-----+--------+-----------+------+---------+------+-----------+----------------------------------------------+---------+-------+-----------+----------+ | 126 | root | localhost | NULL | Query | 0 | executing | SELECT * FROM information_schema.processlist | 344.718 | 0 | 0 | 0.000 | +-----+--------+-----------+------+---------+------+-----------+----------------------------------------------+---------+-------+-----------+----------+
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 | +----+-----------------+-----------+------+---------+------+------------------------+------------------+----------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/show-processlist/