Understanding InnoDB Lock Conflicts When Multiple Indexes Target the Same Row
The Index-Lock Binding Mechanism in InnoDB InnoDB attaches locks to index entries rather than physical rows directly. While this principle is well-known, the practical implications become less obvious when different transactions operate on the same row through different indexes. This analysis examin...