MySQL gap locks and next-key locks: diagnosing and fixing deadlocks
InnoDB gap locks and next-key locks explained on a real case: deadlocks on concurrent INSERTs, diagnosis with SHOW ENGINE INNODB STATUS, and when READ COMMITTED fixes everything.
Start typing to search…
Select a result to see the preview