BestHub
Sign in
Tagged articles

pt-online-schema-change

10 articles · Page 1 of 1
Su San Talks Tech
Su San Talks Tech
Aug 13, 2026 · Databases

How to Safely Add a Column to a Tens‑Million‑Row MySQL Table? 6 Proven Methods

Adding a column to a MySQL table with tens of millions of rows can lock the table for minutes or even hours, disrupting services, so this article evaluates six practical approaches—including native online DDL, offline maintenance, PT‑OSC, logical migration with dual‑write, gh‑ost, and partition sliding‑window—detailing their mechanisms, trade‑offs, and suitable scenarios.

MySQLOnline DDLdatabase operations
0 likes · 13 min read
How to Safely Add a Column to a Tens‑Million‑Row MySQL Table? 6 Proven Methods
Su San Talks Tech
Su San Talks Tech
May 5, 2026 · Databases

Alibaba Interview: Key Considerations for Indexing Tens‑Millions‑Row Tables

The article explains how to safely add indexes to a tens‑of‑millions‑row MySQL table, covering lock duration, disk‑space impact, write‑performance degradation, and six practical principles—selective columns, proper order, covering indexes, avoiding redundancy, short‑lock tools, and ongoing monitoring—plus pros, cons, and suitable use cases.

IndexingMySQLOnline DDL
0 likes · 10 min read
Alibaba Interview: Key Considerations for Indexing Tens‑Millions‑Row Tables
Ray's Galactic Tech
Ray's Galactic Tech
Jan 12, 2026 · Databases

How to Safely Add Columns to Billion‑Row MySQL Tables Without Downtime

This guide explains why using a plain ALTER TABLE on massive MySQL tables can lock the table and halt services, and presents tool‑based online DDL, native INPLACE options, phased migration strategies, cloud‑DB features, best‑practice checks, monitoring, and rollback techniques to add new columns safely.

MySQLOnline DDLdatabase migration
0 likes · 8 min read
How to Safely Add Columns to Billion‑Row MySQL Tables Without Downtime
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
dbaplus Community
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