Youzan Coder

Feb 15, 2019 · Databases

Why Three Concurrent INSERTs Trigger a Deadlock in InnoDB?

This article walks through a step‑by‑step InnoDB deadlock case where three sessions inserting rows with the same unique key cause a lock‑compatibility conflict, explains the INSERT lock phases, shows the actual deadlock log, and reveals why the deadlock occurs.