Difference between revisions of "SHOW PROCESSLIST;"
Jump to navigation
Jump to search
Line 17: | Line 17: | ||
== 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: