Tag

DDL Monitoring

1 views collected around this technical thread.

Aikesheng Open Source Community
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.

ALTER TABLEDDL MonitoringPerformance Schema
0 likes · 4 min read
Monitoring ALTER TABLE Progress in MySQL Using Performance Schema