Deadlock Detection
Detection approach: Detect deadlocks automatically, and abort a deadlocked transactions (the victim).
It’s the preferred approach, because it
- allows higher resource utilization and
- uses cheaper algorithms
Timeout-based deadlock detection - If a transaction is blocked for too long, then abort it.
- Simple and easy to implement
- But aborts unnecessarily and
- some deadlocks persist for too long