mysql:可重复读模式下
1. 快照读(snapshot read)
MVCC模式,并发高,数据不实时!
一般情况下的select
2.当前读(current read)
next-key lock模式,并发低,数据实时!
select ... lock in share mode
select ... for update
insert
update
delete
mysql:可重复读模式下
1. 快照读(snapshot read)
MVCC模式,并发高,数据不实时!
一般情况下的select
2.当前读(current read)
next-key lock模式,并发低,数据实时!
select ... lock in share mode
select ... for update
insert
update
delete