Tagged articles

INPLACE

6 articles · Page 1 of 1

Aug 17, 2026 · Databases

Does Adding an Index Lock the Table? JD Interview Deep Dive (Full Score Edition)

The article explains that whether adding an index locks a MySQL table depends on the version and DDL algorithm—MySQL 5.5 and earlier lock the whole table, 5.6‑5.7 use Online DDL with brief metadata locks, and 8.0+ can create secondary indexes instantly without locking, while primary, unique, and full‑text indexes always require locking.

COPYINPLACEINSTANT

0 likes · 10 min read

Does Adding an Index Lock the Table? JD Interview Deep Dive (Full Score Edition)

Java Architect Handbook

Apr 9, 2026 · Databases

Master MySQL DDL: Online DDL Algorithms, Version Differences, and Production Indexing Tips

This guide explains MySQL DDL mechanisms, compares COPY, INPLACE, and INSTANT algorithms across versions, details Online DDL execution phases and risks, and provides practical production‑grade indexing practices and interview Q&A for handling large tables without blocking reads or writes.

DDLINPLACEIndexing

0 likes · 11 min read

Master MySQL DDL: Online DDL Algorithms, Version Differences, and Production Indexing Tips

ITPUB

Feb 17, 2026 · Databases

From Midnight Table Locks to Instant DDL: MySQL’s Online Schema Evolution Explained

This article chronicles a decade of MySQL Online DDL improvements—from the painful COPY operations of 5.5 to the near‑zero‑impact INSTANT algorithm in 8.0—while exposing hidden costs, MDL lock pitfalls, and practical best‑practice checklists for safe schema changes.

INPLACEINSTANTMySQL

0 likes · 23 min read

From Midnight Table Locks to Instant DDL: MySQL’s Online Schema Evolution Explained

dbaplus Community

Dec 11, 2025 · Databases

Running DDL on Live MySQL Tables: Copy, In‑Place, and Instant Add Column

Learn the differences between MySQL’s copy and in‑place (online) DDL algorithms, how they manage locks, the steps of each process, the new Instant Add Column feature in MySQL 8, and practical strategies—including master‑slave switching—to safely alter tables in production.

DDLINPLACEInstant Add Column

0 likes · 10 min read

Running DDL on Live MySQL Tables: Copy, In‑Place, and Instant Add Column

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

dbaplus Community

Apr 18, 2019 · Databases

Mastering MySQL DDL: Algorithms, Tools, and Performance Tips

This article explains the challenges of MySQL DDL on large tables, details the built‑in COPY, INPLACE, and INSTANT algorithms, compares third‑party tools like pt‑online‑schema‑change and gh‑ost, and provides practical guidance on minimizing impact, monitoring progress, and handling metadata locks.

DDLINPLACEINSTANT

0 likes · 15 min read

Mastering MySQL DDL: Algorithms, Tools, and Performance Tips