hard20 pts · first answer countstransactionsmysqlrow-locks
One UPDATE blocks the whole table
In MySQL InnoDB at Repeatable Read, UPDATE orders SET flag = 1 WHERE note = 'x' runs where note has no index. Other sessions now cannot update any order row. Why?
Discussion 0
Join free to post in the discussion.
Related questions
- Durability in ACIDDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- What ROLLBACK undoesDatabase Administrator
- Why InnoDB over MyISAMDatabase Administrator
- Finding slow MySQL queriesDatabase Administrator
- How InnoDB stores table rowsDatabase Administrator
- What an InnoDB secondary index points toDatabase Administrator
- type = ALL in MySQL EXPLAINDatabase Administrator