In fact, the only row-level locking that remains during INSERT is the next-key locks that are required to protect an INSERT from adding keys to repeatable read scanners.
实际上,在INSERT期间惟一保持的行级锁是next - key锁,这个锁用于使INSERT不会添加键到可重复的读扫描器。
However, that is not the same as dictating how a "repeatable process" (level 2) must be performed in terms of process, tools, and organizational roles.
然而,这并不是规定一个“可重复过程”(二级)必须利用过程、工具和组织角色来完成。
These next key locks are only obtained when the key INSERT finds that a scanner with a Repeatable Read (RR) isolation level has a row lock on the next-higher key in the index.
这些next key锁只有在key INSERT发现带有Repeatable Read (RR)隔离级别的扫描器在索引中的next - higher键上有一个行锁时才能获得。
应用推荐