mysql update使用了很长时间 是不是死锁了
1个回答
展开全部
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`=35489
*** (2) HOLDS THE LOCK(S):
*** (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`=35489
*** (2) HOLDS THE LOCK(S):
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
