MySQL has since version 5.7 had support for progress information
for some queries. As promised in my previous post, I will here discuss how you
can use that to get progress information for ALTER
TABLE
on InnoDB tables.
Background and Setup
Progress information is implemented through the Performance
Schema using the stage events. In version 8.0.12 there are
currently seven stages that can provide this information
for ALTER TABLE
statements on InnoDB tables.
In MySQL 8, it is easy to list the stages capable of reporting
progress information by using the …