Difference between revisions of "SHOW PROCESSLIST;"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
* https://mariadb.com/kb/en/show-processlist/ | * https://mariadb.com/kb/en/show-processlist/ | ||
| − | + | ||
| − | SHOW PROCESSLIST; | + | SHOW PROCESSLIST; |
| − | +----------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+ | + | +----------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+ |
| − | | Id | User | Host | db | Command | Time | State | Info | Progress | | + | | Id | User | Host | db | Command | Time | State | Info | Progress | |
| − | +----------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+ | + | +----------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+ |
| − | | 1 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | + | | 1 | system user | | NULL | Daemon | NULL | [[InnoDB purge worker]] | NULL | 0.000 | |
| − | | 2 | 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 | | + | | 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | |
| − | | 4 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | 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 | | + | | 5 | system user | | NULL | Daemon | NULL | [[InnoDB shutdown handler]] | NULL | 0.000 | |
| − | | 26747517 | root | localhost | NULL | Query | 0 | Init | SHOW PROCESSLIST | 0.000 | | + | | 26747517 | root | localhost | NULL | Query | 0 | Init | SHOW PROCESSLIST | 0.000 | |
| − | +----------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+ | + | +----------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+ |
| − | 6 rows in set (0.001 sec) | + | 6 rows in set (0.001 sec) |
| − | |||
== See also == | == See also == | ||
| + | * {{InnoDB}} | ||
* {{MariaDB}} | * {{MariaDB}} | ||
[[Category:MariaDB]] | [[Category:MariaDB]] | ||
Latest revision as of 18:20, 4 June 2022
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[edit]
- 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/
Advertising:
