delete\update where… in语句 导致死锁问题分析

1、问题描述

2、问题分析

delete from b where (a,b,c,d,e) in ((1,1,1,1,1));

delete from b where (a,b,c,d,e) in ((1,1,2,1,1));

delete from b where where a=1 and b=1 and c=1 and d=1 and e=1;

delete from b where where a=1 and b=1 and c=2 and d=1 and e=1;

3、解决办法

4、半一致性读仍会死锁问题

6、源码分析