The Lock Queue: Why a 2 ms ALTER TABLE Can Freeze Production
Reproduce it with three SQL sessions, then fix it with lock timeouts, retries, and the three clocks of a safe migration.
#mysql
Posts tagged #mysql
Offset vs Cursor Pagination: The 3 Ways Rows Still Go Missing
Ties, shifts and late arrivals, with the SQL to fix each one and a test that proves i
Your Database Transaction Didn't Save You From This Bug
You wrapped it in BEGIN and COMMIT and thought it was safe. Then money vanished under real traffic. Here's the lost-update race condition, why transactions don't stop it, and three fixes.
