BestHub
Sign in
Tag

INSTANT

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 11, 2022 · Databases

Exploring MySQL 8.0.29 Instant ADD/DROP COLUMN Feature and Its Impact on Online DDL

This article demonstrates how MySQL 8.0.29’s ALGORITHM=INSTANT enables instant column addition, deletion, and row‑size checks at any position in large tables, compares performance with previous versions, and discusses related XtraBackup backup considerations.

ALTER TABLEINSTANTMySQL
0 likes · 9 min read
Exploring MySQL 8.0.29 Instant ADD/DROP COLUMN Feature and Its Impact on Online DDL
NetEase Game Operations Platform
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
Understanding MySQL DDL Algorithms and How to Minimize Their Impact