Why You Deadlock Touching Only 1 Row: Gap Locks & The 3 Access Paths of WHERE
Deep dive into MySQL InnoDB storage engine locking mechanics: why two users updating distinct draft carts trigger Deadlock 1213, decoding the 3 access paths of a WHERE clause, and why READ COMMITTED won't save you.