事务一 | 事务二 |
update lock_demo set name='a' where index=1; | |
| update lock_demo set name='a' where index=2; 未卡住,间隙锁之间不冲突 |
insert into lock_demo(id,`index`,name)values(1,1,'1'); 卡住,被事务二的间隙锁锁住 | |
| insert into lock_demo(id,`index`,name)values(2,2,'2'); 检测到死锁 |
欢迎光临 ToB企服应用市场:ToB评测及商务社交产业平台 (https://dis.qidao123.com/) | Powered by Discuz! X3.4 |