问题描述
出于测试目的，我需要在 MySQL 上生成"1213:死锁" ，以便UPDATE查询无法更新表.
For test purposes, I need to generate a "1213: Deadlock" on MySQL so that UPDATE query can't update a table.
我不太确定如何导致死锁?
I am not not quite sure how to cause deadlock?
推荐答案
有很多使用两个会话的帖子.
There are numerous posts for this by using two sessions.
https://dba.stackexchange.com/questions/309/code-to-simulate -死锁
http://www.xaprb.com/blog/2006/08/08/how-to-deliberately-cause-a-deadlock-in-mysql/
方法是从上面的第二篇文章中复制的
首先，选择一个未使用的表名.我将使用test.innodb_deadlock_maker.这是您需要执行的语句:
First, choose an unused table name. I’ll use test.innodb_deadlock_maker. Here are the statements you need to execute:
create table test.innodb_deadlock_maker(a int primary key) engine=innodb;
insert into test.innodb_deadlock_maker(a) values(0), (1);
现在，已建立表格及其数据.接下来，在两个不同的连接上执行以下操作:
Now the table and its data are set up. Next, execute the following on two different connections:
-连接0
set transaction isolation level serializable;
start transaction;
select * from test.innodb_deadlock_maker where a = 0;
update test.innodb_deadlock_maker set a = 0 where a <> 0;
-连接1
set transaction isolation level serializable;
start transaction;
select * from test.innodb_deadlock_maker where a = 1;
update test.innodb_deadlock_maker set a = 1 where a <> 1;
这篇关于如何在MySQL上造成死锁的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！