SHOW PROCESSLIST;

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

SHOW PROCESSLIST;
+----------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
| Id       | User        | Host      | db   | Command | Time | State                    | Info             | Progress |
+----------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+ 
|        1 | system user |           | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
|        2 | system user |           | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
|        3 | system user |           | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
|        4 | system user |           | NULL | Daemon  | NULL | InnoDB purge coordinator | NULL             |    0.000 |
|        5 | system user |           | NULL | Daemon  | NULL | InnoDB shutdown handler  | NULL             |    0.000 |
| 26747517 | root        | localhost | NULL | Query   |    0 | Init                     | SHOW PROCESSLIST |    0.000 |
+----------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
6 rows in set (0.001 sec)

See also

• InnoDB, InnoDB purge worker, mysqldump --single-transaction
• MariaDB: mariadbcheck, mariabackup, mysqldump, MyRocks, show (MariaDB) MariaDB Changelog, 50-server.cnf, MariaDB engines, .ibd, .myd, .myi, /var/log/mysql/error.log, /var/log/mysql/mariadb-slow.log, MariaDB files: .frm, .ibd, /etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries, show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306, /etc/mysql/