I'm running show processlist and see a lot of similar queries to one particular table (btw it has myisam engine) in state Locked, I just want to figure out which one query stucked all others, because when i'm killing 1st from top of the list (ordered by spending time) it does not help :(
我正在运行show processlist并看到很多类似的查询到一个特定的表(顺便说一下,它有myisam引擎)处于Locked状态,我只是想弄清楚哪一个查询引起了所有其他查询,因为当我从顶部杀死第一的列表(按花时间排序)它没有帮助:(
Is there any possibility, to figure out, who is the reason of soooo long queue ?
有没有可能,弄清楚,谁是太长队列的原因?
1 个解决方案
#1
0
Please check Time column on show processlist result, the one with highest value for Time column should be the query which is locking the table
请检查show processlist结果中的Time列,Time列的值最大的那个应该是锁定表的查询
#1
0
Please check Time column on show processlist result, the one with highest value for Time column should be the query which is locking the table
请检查show processlist结果中的Time列,Time列的值最大的那个应该是锁定表的查询