medium10 pts · first answer countstransactionsmysqltable-locks
LOCK TABLES in a transaction
In MySQL a session has an open transaction with inserts, then runs LOCK TABLES orders WRITE. What happens to the open transaction?
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