Difference between revisions of "SHOW PROCESSLIST;"
Jump to navigation
Jump to search
| 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) |
| − | |||
Revision as of 18:16, 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
- 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:
