Database management systems notes

Locking & Deadlocks

Two-phase locking, what actually blocks what, and how to stop deadlocking. Every section is a drawn page beside a clear written explanation, about 21 minutes in all.

  • Chapter 29 of 34
  • About 21 minutes
  • 5 sections

Sign in with Google or GitHub and you land straight on this page. DSA comes with the all labs plan and every ChaiCode batch.

The first drawn page of Locking & Deadlocks: Shared and exclusive locks
The chapter's first page: Shared and exclusive locks

In this chapter

  • Shared and exclusive locks
  • Two-phase locking
  • What actually blocks what
  • Deadlock
  • The habit that prevents most deadlocks

Next chapters

Read the whole chapter

Sign in and the chapter opens with every drawn page, and all 35 database management systems chapters beside it.

DSA comes with the all labs plan and every ChaiCode batch.