Instant Add Column

Aikesheng Open Source Community

Jun 20, 2019 · Databases

Understanding MySQL Instant Add Column: How It Works and Its Limitations

This article explains MySQL's Instant Add Column feature, describing the traditional costly column‑addition process, the instant method’s internal mechanics, how data is read and written before and after the change, and the practical constraints that limit its usage.

DDLDatabase InternalsInstant Add Column

0 likes · 7 min read

Understanding MySQL Instant Add Column: How It Works and Its Limitations

Efficient Ops

Oct 23, 2017 · Databases

How Tencent’s DBA Team Cut a 12‑Hour Schema Change to 0.04 seconds in MariaDB

The article recounts how Tencent Game DBA engineers contributed two core features—instant ADD COLUMN and large‑field compression—to MariaDB 10.3.2 Alpha, slashing a 12‑hour schema change to 0.04 seconds, earning public thanks from the MariaDB project and its founder Monty, and illustrating the impact of open‑source collaboration on high‑performance game databases.

Database performanceInstant Add ColumnMariaDB

0 likes · 9 min read

How Tencent’s DBA Team Cut a 12‑Hour Schema Change to 0.04 seconds in MariaDB

Understanding MySQL Instant Add Column: How It Works and Its Limitations

How Tencent’s DBA Team Cut a 12‑Hour Schema Change to 0.04 seconds in MariaDB

How Tencent’s DBA Team Cut a 12‑Hour Schema Change to 0.04 seconds in MariaDB