Repeatable Read 可重复读 ; 可重复读取 ; 重复读 ; 可重读
Non-repeatable Read 不可重复读 ; 不可重复的读 ; 非重复读 ; 重复读
RR-Repeatable Read 可重复读
Repeatable read isolation 可重复读级别
non-repeatable read problem 不可重复读问题
locking REPEATABLE READ 锁可重复读
read-uncommited read-commited repeatable-read serializable 提交前读
READ REPEATABLE 可重复读
Supports table and row level locking and 4 isolation levels, RR (repeatable read), rs (read stability), CS (default - cursor stability) and ur (uncommitted read).
支持表级和行级锁以及4个隔离级别:RR(可重复读)、RS(读可靠)、CS(默认——游标可靠)和UR(未提交读)。
With the "Repeatable Read" data region fetch requests issued multiple times within the same transaction will always produce the same result yielding better application throughput.
在相同事务下对“可重复读取”区域内数据的多次请求的结果是相同的,但能够带来更好的应用吞吐量。
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不会添加键到可重复的读扫描器。
应用推荐