Syntax
------ 
SHOW [FULL] PROCESSLIST
 
Description
----------- 
 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). | MariaDB 5.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. | 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 | The amount of memory used by the process. |
MariaDB 10.0.1 | 
 
EXAMINED_ROWS | The number of rows the process has examined.
| MariaDB 10.0.1 | 
 
QUERY_ID | Query ID. | MariaDB 10.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.
 
Examples
-------- 
From MariaDB 5.1.x
 
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 |
+---------+-------+-----------+------+---------+------+-----------+----------------------------------------------+---------+
 
From MariaDB 5.5.x
 
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 |
+-----+--------+-----------+------+---------+------+-----------+----------------------------------------------+---------+-------+-----------+----------+
 
From MariaDB 10.0.x
 
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 |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+----------+
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/show-processlist/