案例五 最近高并发下有遇到不少

[jinpuxiang]

业务表有自增id主键和组合唯一键

insert into on duplicate key update写法
delete from where

操作两个账号的数据时，insert语句可能时二阶段加锁了，会出现了这个死锁特征：
delete WAITING FOR lock_mode X
insert WAITING FOR lock_mode X locks gap before rec insert intention, HOLDS lock_mode X locks rec but not gap

请问您有对insert into on duplicate key update加锁解释的文章吗