Adding a Column to a Massive MySQL Table Safely

This article explains practical strategies for adding a new column to a MySQL table with tens of millions of rows, including creating a temporary table, copying data, renaming tables, and alternative replica‑based or third‑party methods to avoid long locks and potential crashes.

Large TableSchema Migrationadd column

0 likes · 4 min read

Adding a Column to a Massive MySQL Table Safely

NetEase Game Operations Platform

Oct 26, 2019 · Databases

Instant Column Addition in MySQL 8.0: Principles, Usage, Performance and Limitations

The article explains how MySQL 8.0 introduced the instant algorithm for adding columns, compares it with older copy and inplace‑rebuild methods, shows usage examples, performance test results, and outlines the restrictions and version differences of this fast DDL operation.

Instant DDLadd columndatabase

0 likes · 9 min read

Instant Column Addition in MySQL 8.0: Principles, Usage, Performance and Limitations