mysql update in 死锁_mysql update使用了很长时间 是不是死锁了

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):

取消

评论