How Long Transactions Kill Services: Undo Log Bloat, Rollback Traps & The MDL Cascade
Physical mechanisms of long-running transaction failures: Undo tablespace and History List Length (HLL) bloat, the single-threaded rollback trap, the critical difference between KILL QUERY and KILL CONNECTION, and the Metadata Lock (MDL) queue cascade exhausting connection pools.