*** (2) TRANSACTION:
TRANSACTION 0 1829811506, ACTIVE 2846 sec, process no 23099, OS thread
id 1183709504 fetching rows, thread declared inside InnoDB 79
mysql tables in use 1, locked 1
39659 lock struct(s), heap size 3848176, undo log entries 2530785
MySQL thread id 30117358, query id 176461999 221.192.134.7 joycdn
updating
delete from tmp where DATE_SUB(CURDATE(), INTERVAL 1 DAY) >=
inserttime
delete from tmp where DATE_SUB(CURDATE(), INTERVAL 1 DAY) >=
inserttime
请教一下,这个语句以前就执行过一次产生了死锁.后来每次重启数据库解决死锁的时候.过个两天又会出现这条语句导致的死锁.请问有没有办法解决.这个语
句以前只运行过一次.重启数据库后他还是会继续执行.有没有办法取消他?非常感谢.
于 2011-2-17 2:49, foxbin 写道:
> ------------------------
> LATEST DETECTED DEADLOCK
> ------------------------
>
> *** (2) TRANSACTION:
> TRANSACTION 0 1829811506, ACTIVE 2846 sec, process no 23099, OS thread
> id 1183709504 fetching rows, thread declared inside InnoDB 79
> mysql tables in use 1, locked 1
> 39659 lock struct(s), heap size 3848176, undo log entries 2530785
> MySQL thread id 30117358, query id 176461999 221.192.134.7 joycdn
> updating
> delete from tmp where DATE_SUB(CURDATE(), INTERVAL 1 DAY) >=
> inserttime
>
> delete from tmp where DATE_SUB(CURDATE(), INTERVAL 1 DAY) >=
> inserttime
> 请教一下,这个语句以前就执行过一次产生了死锁.后来每次重启数据库解决死锁的时候.过个两天又会出现这条语句导致的死锁.请问有没有办法解决.这个语
> 句以前只运行过一次.重启数据库后他还是会继续执行.有没有办法取消他?非常感谢.
>
--
您收到此邮件是因为您订阅了 Google 网上论坛的“[MySQL中文用户群]”论坛。
要向此网上论坛发帖,请发送电子邮件至 imy...@googlegroups.com。
要取消订阅此网上论坛,请发送电子邮件至 imysql+un...@googlegroups.com。
若有更多问题,请通过 http://groups.google.com/group/imysql?hl=zh-CN 访问此网上论坛。