NetEase Game Operations Platform
Apr 20, 2019 · Databases
Understanding MySQL DDL Algorithms and How to Minimize Their Impact
This article explains the three MySQL DDL algorithms (COPY, INPLACE, INSTANT), compares third‑party tools like pt‑online‑schema‑change and gh‑ost, and provides practical guidance on selecting algorithms, using ALGORITHM clauses, monitoring progress, and handling performance, space, replication lag, and metadata lock issues.
CopyDDLINPLACE
0 likes · 13 min read