I am encountering deadlocks while trying to update multiple rows (a batch) using INSERT..ON DUPLICATE KEY UPDATE. Does MySQL lock all the rows in one batch or does it lock only the row it is updating at a point of time?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
This would depend on the Storage Engine.