以下 sys schema 视图提供长时间运行事务的进度报告：The following sys schema views provide progress reporting for long-running transactions:

processlist
session
x$processlist
x$session

假设已启用所需的仪器和消费者，这些视图的 progress 列显示支持进度报告的阶段的完成工作百分比。Assuming that the required instruments and consumers are enabled, the progress column of these views shows the percentage of work completed for stages that support progress reporting.

阶段进度报告要求启用 events_stages_current 消费者，以及希望获取进度信息的仪器。目前这些阶段的仪器支持进度报告：Stage progress reporting requires that the events_stages_current consumer be enabled, as well as the instruments for which progress information is desired. Instruments for these stages currently support progress reporting:

stage/sql/Copying to tmp table
stage/innodb/alter table (end)
stage/innodb/alter table (flush)
stage/innodb/alter table (insert)
stage/innodb/alter table (log apply index)
stage/innodb/alter table (log apply table)
stage/innodb/alter table (merge sort)
stage/innodb/alter table (read PK and internal sort)
stage/innodb/buffer pool load

对于不支持估算和已完成工作报告的阶段，或者如果所需的工具或消费者未启用，则 progress 列为 NULL。For stages that do not support estimated and completed work reporting, or if the required instruments or consumers are not enabled, the progress column is NULL.