MySQL Innodb表导致死锁日志情况分析与归纳

案例描述在定时脚本运行过程中，发现当备份表格的sql语句与删除该表部分数据的sql语句同时运行时，mysql会检测出死锁，并打印出日志。两个sql语句如下：（1）insert into backup_table select * from source_table（2）DELETE FROM source_table WHERE Id>5 AND titleWeight<32768 AND joinTime<‘$daysago_1week’teamUser表的表结构如下：PRIMARY KEY (`uid`,`Id`),KEY `k_id_titleWeight_score` (`Id`,`t