Skip to content
Tagged articles

transaction locking

4 articles · Page 1 of 1
liandk
liandk
Sep 16, 2026 · Databases

Slow SQL Full-Chain Troubleshooting: Execution Plans, Index Failures & Lock Contention

This comprehensive guide covers the complete slow SQL troubleshooting lifecycle: enabling slow query logs, interpreting EXPLAIN plans, diagnosing nine common index failure patterns, resolving transaction lock contention, and applying architectural optimizations for large datasets, plus emergency mitigation and long-term governance practices.

Database PerformanceSQL TuningSlow SQL
0 likes · 16 min read
Slow SQL Full-Chain Troubleshooting: Execution Plans, Index Failures & Lock Contention
Architect
Architect
Apr 29, 2025 · Databases

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.

Database PerformanceINSERT INTO SELECTIndexing
0 likes · 8 min read
Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration
Java High-Performance Architecture
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.

Database MigrationINSERT INTO SELECTfull table scan
0 likes · 7 min read
Why ‘INSERT INTO SELECT’ Can Crash Your MySQL Production – A Cautionary Tale
dbaplus Community
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.

Large TableSQLdata migration
0 likes · 8 min read
How to Safely Delete Hundreds of Millions of Rows Without Locking Your Database