在MySQL 5.6以前,我们通过show processlist\G命令查看系统中正在运行的所有进程,从5.7开始,我们又可以通过sys.session表来查看系统正在运行的所有进程,而且该表中的记录相对processlist比较完善:
mysql> SELECT * from sys.session\G
*************************** 1. row ***************************
thd_id: 29
conn_id: 4
user: root@localhost
db: test
command: Query
state: alter table (read PK and internal sort)
time: 6
current_statement: ALTER TABLE b add index(b)
statement_latency: 5.78 s
progress: 19.19
lock_latency: 203.70 ms
rows_examined: 0
rows_sent: 0
rows_affected: 0
tmp_tables: 0
mysql> SELECT * from sys.session\G
*************************** 1. row ***************************
thd_id: 29
conn_id: 4
user: root@localhost
db: test
command: Query
state: alter table (read PK and internal sort)
time: 6
current_statement: ALTER TABLE b add index(b)
statement_latency: 5.78 s
progress: 19.19
lock_latency: 203.70 ms
rows_examined: 0
rows_sent: 0
rows_affected: 0
tmp_tables: 0