Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration

A real‑world MySQL data‑migration case study shows how using INSERT INTO SELECT without proper indexing caused a full table scan, OOM errors, and data loss, and explains how to avoid the pitfall by adding appropriate indexes and understanding transaction locking.

Data MigrationDatabase PerformanceFull Table Scan

0 likes · 8 min read

Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration

Java High-Performance Architecture

May 15, 2024 · Databases

Why ‘INSERT INTO SELECT’ Can Crash Your MySQL Production – A Cautionary Tale

A developer used MySQL’s INSERT INTO SELECT to migrate millions of rows, causing full‑table scans, OOM errors and lost payment records, leading to a costly incident; the post analyzes the root causes, explains transaction locking behavior, and offers practical indexing and testing safeguards.

Full Table ScanINSERT INTO SELECTdatabase migration

0 likes · 7 min read

Why ‘INSERT INTO SELECT’ Can Crash Your MySQL Production – A Cautionary Tale

dbaplus Community

Oct 27, 2022 · Databases

How to Safely Delete Hundreds of Millions of Rows Without Locking Your Database

This guide explains why a single massive DELETE on a 500‑million‑row table creates long‑running transactions and locks, and shows step‑by‑step techniques—date‑range batching, primary‑key range slicing, and insert‑instead‑of‑delete—to break the operation into manageable chunks and improve performance.

Data MigrationLarge Tabledelete batching

0 likes · 8 min read

How to Safely Delete Hundreds of Millions of Rows Without Locking Your Database