medium10 pts · first answer countstransactionsmysqlrow-locks
MySQL lock wait timeout behaviour
In MySQL InnoDB with default settings, an UPDATE waits 50 seconds and fails with error 1205, "Lock wait timeout exceeded". What is rolled back?
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