TimesTen Lock

最新推荐文章于 2023-12-03 11:42:43 发布

原创最新推荐文章于 2023-12-03 11:42:43 发布 · 371 阅读

0 ·

CC 4.0 BY-SA版权

Timesten 专栏收录该内容

9 篇文章

订阅专栏

本文介绍了TimesTen In-Memory Database中的多种锁类型及其在不同隔离级别下的应用，包括共享锁、更新锁、意向锁及排他锁等，并解释了它们如何确保并发控制。

TimesTen In-Memory Database Reference

A value used to determine the level of concurrency that the lock provides:
S – Shared lock in serializable isolation.
Sn – Shared lock in non-serializable isolation
U – Update lock in serializable isolation.
Un – Update lock in non-serializable isolation.
En – End-of-scan lock for non-serializable isolation.
IRC – Intention shared lock in non-serializable isolation.
IS – Intention shared lock in serializable isolation
IU – Intention update lock in serializable isolation
IUn – Intention update lock in non-serializable isolationIX – Intention exclusive lock in serializable isolation
IXn – Intention exclusive lock non-serializable isolation
SIX – Shared lock with intent to set an exclusive lock in serializable isolation.
SIXn – Shared lock with intent to set an exclusive lock non-serializable isolation.
X – Exclusive lock.
Xn – Exclusive lock in non-serializable isolation.
W – Update, insert or delete table lock.
XNi – Next lock for inserting into tables or non-unique index
NS – Table lock in read-committed isolation that conflicts with all table locks in serializable isolationLock "0" means the blocker is still in the waiting list.