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 | | ||
| Line 14: | Line 14: | ||
6 rows in set (0.001 sec) | 6 rows in set (0.001 sec) | ||
| − | + | == Related == | |
| + | * [[ps]] | ||
== See also == | == See also == | ||
Latest revision as of 09:58, 18 December 2024
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)
Related[edit]
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:
