Aikesheng Open Source Community

Jul 24, 2020 · Databases

Monitoring ALTER TABLE Progress in MySQL Using Performance Schema

This article demonstrates how to enable MySQL's performance_schema, generate test data, run an ALTER TABLE operation, and continuously query a custom SQL statement to estimate the operation's progress and remaining time, providing practical insight into DDL monitoring.