-
MySQL死锁检查处理的正常方法(4)
- 作者:孙紫潇 分类:win10 发布时间:2021-07-25 09:32:00
?123456789 #step 3:窗口一 (若第三步中锁请求太久,则出现锁超时而终止执行) mysql> update bb set name = 'bbb' ; ERROR 1205 (HY000): Lock wait timeout exceeded; try restarti...
?123456789
#step 3:窗口一 (若第三步中锁请求太久,则出现锁超时而终止执行)
mysql>
update
bb
set
name
=
'bbb'
;
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting
transaction
#
"窗口一"
锁请求超时前,执行第五步,使死锁产生,则该连接
"窗口二"
执行终止,
"窗口一"
顺利执行
#step 5:窗口二
mysql>
update
aa
set
name
=
'aa'
;
ERROR 1213 (40001): Deadlock found
when
trying
to
get lock; try restarting
transaction
查看最近一个死锁情况
?12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758#查看最近一个死锁情况
mysql> SHOW ENGINE INNODB STATUS\G ;
...............
------------------------
LATEST DETECTED DEADLOCK
------------------------
2018-03-12 11:01:06 7ffb4993a700 #发生时间
*** (1)
TRANSACTION
: #事务1
TRANSACTION
130718515, ACTIVE 19 sec starting
index
read
mysql tables
in
use 1, locked 1 #正被访问的表
LOCK WAIT 4 lock struct(s), heap
size
1184, 4 row lock(s), undo log entries 1 #影响行数
MySQL thread id 5, OS thread handle 0x7ffb498f8700, query id 205 localhost root updating #线程/连接host/用户
update
bb
set
name
=
'bb'
#请求语句
*** (1) WAITING
FOR
THIS LOCK
TO
BE GRANTED: #等待以下资源 (锁定位置及锁模式)
RECORD LOCKS
space
id 65 page
no
3 n bits 72
index
`GEN_CLUST_INDEX`
of
table
`test`.`bb` trx id 130718515 lock_mode X waiting
Record lock, heap
no
5 PHYSICAL RECORD: n_fields 5; compact format; info bits 0
0: len 6; hex 000000000300;
asc
;;
1: len 6; hex 000007ca9b34;
asc
4;;
2: len 7; hex 1f000002092075;
asc
u;;
3: len 4; hex 80000001;
asc
;;
4: len 2; hex 6262;
asc
bb;;
*** (2)
TRANSACTION
: #事务2
TRANSACTION
130718516, ACTIVE 14 sec starting
index
read
mysql tables
in
use 1, locked 1
4 lock struct(s), heap
size
1184, 4 row lock(s), undo log entries 1
MySQL thread id 4, OS thread handle 0x7ffb4993a700, query id 206 localhost root updating
update
aa
set
name
=
'aa'
#请求语句
猜您喜欢
- 轻松掌握win10看配置技巧,如何检查你..2024-03-26
- 揭秘!如何检查Windows 10是否已成功激..2024-03-24
- Win10提示无法连接打印机?检查打印机..2024-03-12
- Win10磁盘检查卡住?进不去系统?只需..2024-02-25
- 轻松一招:如何检查Win10是否激活,让..2024-02-24
- Win10小技巧:轻松关闭磁盘修复检查..2024-02-02
相关推荐
- win10控制面板在哪 win10 控制面板在哪里..2022-02-11
- win10打开屏幕键盘快捷键 windows打开屏..2023-09-17
- Win10如何安全的给移动硬盘分区?win..2022-09-07
- Win10系统正确设置虚拟内存的设置教程..2017-06-22
- 大师讲解win102004更新总是重启卡死,w..2017-09-19
- 电脑键盘全图详细图片 键盘108键位对..2023-10-12