hard20 pts · first answer countslockingtransactions
Fixing a recurring deadlock
Two jobs transfer money. Job 1 updates account 10 then account 20. Job 2 updates account 20 then account 10. Deadlocks happen daily. What is the best fix?
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
- Non-repeatable readDatabase Administrator
- Workers fighting over jobsDatabase Administrator
- A migration froze the whole appDatabase Administrator
- InnoDB gap locksDatabase Administrator
- Two doctors go off callDatabase Administrator