Community

InnoDB Deadlock – Next Key Locking

(Parvesh Garg) So you use InnoDB, have indexes on your table, think of row level locking and concurrent queries, feel good and go to sleep. All this while forgetting that even UPDATE and SELECT …. FOR UPDATE statements will (or may) also use the same index for scanning or updating. Then what? You

Read More - Register for Free Membership