mysql - 如何模拟mysql中一行的死锁？

Question

模拟 lock在 mysql 中，我可以使用以下命令抓取该行:

BEGIN;
SELECT * FROM table WHERE id=1 FOR UPDATE;

现在，如果我尝试更新该行(从另一个连接)，它会在 innodb_lock_wait_timeout 之后引发以下错误秒(默认值:50):

(1205, 'Lock wait timeout exceeded; try restarting transaction')

那么我将如何模拟死锁，所以我收到如下错误:

Deadlock found when trying to get lock; try restarting transaction”

当我尝试查询或更新行时？

更新 :即使尝试模拟 the mysql deadlock example , 我得到 Lock wait timeout exceeded; try restarting transaction而不是 deadlock信息。

Answer 1

是否启用了死锁检测？
您可以在这里阅读更多信息:https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-detection.html

A mechanism that automatically detects when a deadlock occurs, and automatically rolls back one of the transactions involved (the victim). Deadlock detection can be disabled using the innodb_deadlock_detect configuration option.