Locks vs. Latches

Locks

  • Protects the database's logical contents from other txns.

  • Held for txn duration

  • Need to be able to rollback changes

Latches

  • Protects the critical sections of the DBMS's internal data structure from other threads.

  • Held for operation duration.

  • Do not need to be able to rollback changes.

PreviousMulti-Threaded Index Concurrency ControlNextLatch modes

Last updated