Aikesheng Open Source Community

May 15, 2020 · Databases

Estimating Progress of Large UPDATE Statements in MySQL Using Performance Schema

This article explains how to monitor and estimate the progress of a massive MySQL UPDATE by observing rows_examined in performance_schema, deriving a progress formula, and adjusting the coefficient based on whether primary keys or only data columns are modified.