第34章 并发删除数据造成死锁 - xiaoboluo768/qianjinliangfang GitHub Wiki

34.3　表结构及操作步骤

mysql> CREATE TABLE t1 (id int unsigned NOT NULL PRIMARY KEY, c1 varchar(10));
mysql> INSERT INTO t1 VALUES (1, 'aa'), (2, 'bb'), (3, 'cc'), (4, 'dd'), (5, 'ee'), (6, 'ff');

• 表34-1

Session 1	Session 2
START TRANSACTION;DELETE FROM t1 WHERE id = 1;
	START TRANSACTION;DELETE FROM t1 WHERE id = 6;
DELETE FROM t1 WHERE id = 2;
	DELETE FROM t1 WHERE id = 5;
DELETE FROM t1 WHERE id = 3;
	DELETE FROM t1 WHERE id = 4;
DELETE FROM t1 WHERE id = 4;
	DELETE FROM t1 WHERE id = 3;//发生死锁

---

上一篇：第33章　硬件和系统调优 | 下一篇：第35章 删除不存在的数据造成死锁