BestHub
Sign in
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.

Index OptimizationMySQLSQL Tuning
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.

INSERT INTO SELECTIndexingMySQL
0 likes · 8 min read
Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration
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