... 3)提升锁((promotable lock/update lock) 2、锁的粒度(granularity) 1)数据库级锁(database lock) ...
基于40个网页-相关网页
技术2:减小锁的粒度。
在这种情况下,锁的粒度是非常重要的。
并且由于每一行都被存储在固定的位置,使得锁升级这样的技术得以实现,以避免过多细粒度锁。
And the location of every row is in a fixed location, allowing for techniques such as lock escalation when too many fine-grained locks would otherwise be needed.
应用推荐