mysql update使用了很长时间 是不是死锁了
发布网友
发布时间：2022-04-23 04:17
共1个回答
热心网友
时间：2022-04-07 19:22
UPDATE `wt` SET `status`=8 WHERE `edate`=20150505 AND `s_number`=35483
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 8032 page no 43 n bits 800 index `eDate` of table `db`.`wt` trx id 96651332 lock_mode X waiting
*** (2) TRANSACTION:
TRANSACTION 96651156, ACTIVE 2 sec fetching rows
mysql tables in use 3, locked 3
8 lock struct(s), heap size 1184, 384 row lock(s), undo log entries 1
MySQL thread id 43257753, OS thread handle 0x7fdd1179c700, query id 225480681 172.16.170.168 app updating
UPDATE `wt` SET `status`=8 WHERE `edate`=20150505 AND `s_number`=354
*** (2) HOLDS THE LOCK(S):
