27 lines
546 B
Markdown
27 lines
546 B
Markdown
# LBCC
|
||
|
||
Lock Base Concurrency Control 基于锁的并发控制。
|
||
|
||
# MVCC
|
||
|
||
Multi-Version Concurrency Control，即多版本并发控制
|
||
|
||
生成快照read view
|
||
|
||
隐藏字段，redolog
|
||
|
||
# 处理幻读
|
||
|
||
在一个事物中同时出现快照读，当前读和数据插入（另一个事物）会出现事物。
|
||
|
||
## 串行化
|
||
|
||
## 间隙锁
|
||
|
||
select * from user where age = 18 for update;
|
||
|
||
show engine innodb status\G;(需要开启参数innodb_status_output和innodb_status_output_lock)
|
||
|
||
# 锁根据索引处理
|
||
|
||
记录锁(行锁)，间隙锁，临界锁 |