以下是我如何解决问题:
MysqL> show engine innodb status\G
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
120710 18:05:37 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 37 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 208374,signal count 196902
Mutex spin waits 0,rounds 39211638,OS waits 80663
RW-shared spins 588505,OS waits 68505; RW-excl spins 3204502,OS waits 53586
------------
TRANSACTIONS
------------
Trx id counter 1 3626791829
Purge done for trx's n:o < 1 3625948819 undo n:o < 0 0
History list length 6754
LIST OF TRANSACTIONS FOR EACH SESSION:
...
---TRANSACTION 1 3625948818,ACTIVE 2892 sec,process no 1981,OS thread id 140020625811200
2 lock struct(s),heap size 368,1 row lock(s),undo log entries 1
>>>>> MysqL thread id 14982,query id 232584561 localhost dbuser
Trx read view will not see trx with id >= 1 3625948819,sees < 1 3625948817
MysqL> kill 14982;
Query OK,0 rows affected (0.00 sec)
请注意,带有>>>>>的行是定义MysqL线程ID的地方 – 应该杀死这个线程.
请参阅this帖子 – 非常有用.
@H_301_2@
@H_301_2@
总结
如果觉得编程之家网站内容还不错,欢迎将编程之家网站推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您喜欢交流学习经验,点击链接加入交流1群:1065694478(已满)交流2群:163560250