mysql 5.7 performance_schema 提供一个进度跟踪功能,虽然还不是很直观,但是也相当不错了。
这边功能默认是关闭的,需要手动开启:
1,UPDATE performance_schema.setup_instruments SET ENABLED = ‘YES‘, TIMED = ‘YES‘ WHERE NAME = ‘stage/sql/altering table‘;
3,这样就开启成功了。
样例:
通过以下sql来查看进度:
SELECT EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED,(WORK_COMPLETED/WORK_ESTIMATED)*100 as COMPLETED FROM performance_schema.events_stages_current;
<