uchome的mysql经常出现大量locked状态语句

uchome-2.0 已经打最新补丁
for linux

1. mysql> show processlist\G
   
2. *************************** 1. row ***************************
   
3.      Id: 101
   
4.    User: uchome
   
5.    Host: localhost
   
6.      db: uchome
   
7. Command: Query
   
8.    Time: 1
   
9.   State: Locked
   
10.    Info: SELECT sf.*, s.* FROM uchome_space s LEFT JOIN uchome_spacefield sf ON sf.uid=s.uid WHERE s.uid='322
    
11. *************************** 2. row ***************************
    
12.      Id: 194
    
13.    User: uchome
    
14.    Host: localhost
    
15.      db: uchome
    
16. Command: Query
    
17.    Time: 1
    
18.   State: Locked
    
19.    Info: UPDATE uchome_space SET notenum=notenum+1 WHERE uid='162835'
    
20. *************************** 3. row ***************************
    
21.      Id: 215
    
22.    User: root
    
23.    Host: localhost
    
24.      db: uchome
    
25. Command: Query
    
26.    Time: 0
    
27.   State: NULL
    
28.    Info: show processlist
    
29. *************************** 4. row ***************************
    
30.      Id: 446
    
31.    User: uchome
    
32.    Host: localhost
    
33.      db: uchome
    
34. Command: Query
    
35.    Time: 1
    
36.   State: Locked
    
37.    Info: SELECT username FROM uchome_space WHERE uid=399616
    
38. *************************** 18. row ***************************
    
39.      Id: 574
    
40.    User: uchome
    
41.    Host: localhost
    
42.      db: uchome
    
43. Command: Query
    
44.    Time: 1
    
45.   State: Locked
    
46.    Info: UPDATE uchome_space SET `newpm`='' WHERE `uid`='404667'
    
47. *************************** 19. row ***************************
    
48.      Id: 577
    
49.    User: uchome
    
50.    Host: localhost
    
51.      db: uchome
    
52. Command: Query
    
53.    Time: 1
    
54.   State: Locked
    
55.    Info: SELECT sf.*, s.* FROM uchome_space s LEFT JOIN uchome_spacefield sf ON sf.uid=s.uid WHERE s.uid='303
    
56. *************************** 20. row ***************************
    
57.      Id: 580
    
58.    User: uchome
    
59.    Host: localhost
    
60.      db: uchome
    
61. Command: Query
    
62.    Time: 1
    
63.   State: Locked
    
64.    Info: SELECT sf.*, s.* FROM uchome_space s LEFT JOIN uchome_spacefield sf ON sf.uid=s.uid WHERE s.uid='407
    
65. *************************** 21. row ***************************
    
66.      Id: 581
    
67.    User: uchome
    
68.    Host: localhost
    
69.      db: uchome
    
70. Command: Query
    
71.    Time: 1
    
72.   State: Locked
    
73.    Info: SELECT sf.*, s.* FROM uchome_space s LEFT JOIN uchome_spacefield sf ON sf.uid=s.uid WHERE s.uid='227
    

复制代码

基本上一天会出现个10~20次左右，出现一次mysql就死一次，要重启mysql才行，这是程序问题吗？

请问楼主这个问题解决了吗？盼回复

程序中并没有这条SQL语句，您是不是添加了数据调用，或者安装了什么插件