BestHub
Sign in
Tagged articles
8 articles
Page 1 of 1
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.

Large TablesOnline DDLPerformance Monitoring
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.

Online DDLSchema Changedatabase migration
0 likes · 8 min read
How to Safely Add Columns to Billion‑Row MySQL Tables Without Downtime
Qunar Tech Salon
Qunar Tech Salon
May 31, 2022 · Databases

Comparison of pt-online-schema-change, gh-ost, and MySQL Online DDL for Online Schema Changes

This article introduces and compares three MySQL online schema‑change solutions—pt‑online‑schema‑change, gh‑ost, and native MySQL ONLINE DDL—detailing their workflows, limitations, risks, monitoring features, and practical considerations for safely altering large tables in production environments.

DDLOnline Schema Changedatabase migration
0 likes · 27 min read
Comparison of pt-online-schema-change, gh-ost, and MySQL Online DDL for Online Schema Changes
Qunar Tech Salon
Qunar Tech Salon
Oct 11, 2021 · Databases

Resolving Data Inconsistency in Percona XtraDB Cluster Caused by MyISAM Tables and Applying pt-online-schema-change

This article documents a real‑world incident where a MyISAM table in a Percona XtraDB Cluster caused data inconsistency and node self‑shutdown, analyzes the root cause, and describes how using pt-online-schema-change together with proper engine conversion restored consistency across the cluster.

Database operationsInnoDBMyISAM
0 likes · 14 min read
Resolving Data Inconsistency in Percona XtraDB Cluster Caused by MyISAM Tables and Applying pt-online-schema-change
High Availability Architecture
High Availability Architecture
Nov 14, 2019 · Databases

Why We Should Not Use Database Foreign Keys: Insights from a GitHub Engineer

A GitHub engineer argues that database foreign keys should be avoided because they shift integrity responsibilities to the DB, incur performance overhead, and cause complications during online schema migrations, illustrating the points with parent‑child tables, gh‑ost, and pt‑online‑schema‑change tools.

Foreign KeysSchema Migrationdatabases
0 likes · 4 min read
Why We Should Not Use Database Foreign Keys: Insights from a GitHub Engineer
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.

DDLINPLACEcopy
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.

DDLINPLACESchema Change
0 likes · 15 min read
Mastering MySQL DDL: Algorithms, Tools, and Performance Tips