BestHub
Sign in
Tag

add column

0 views collected around this technical thread.

Architecture Digest
Architecture Digest
Feb 26, 2021 · Databases

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.

Data IntegrityDatabase PerformanceMySQL
0 likes · 4 min read
Adding a Column to a Massive MySQL Table Safely
NetEase Game Operations Platform
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.

DatabaseInstant DDLadd column
0 likes · 9 min read
Instant Column Addition in MySQL 8.0: Principles, Usage, Performance and Limitations