DZ出现了大量的Locked信息怎么办啊

wangbin

/

1. | 836936 | kile | localhost | kiledata | Query   |   57 | Locked        | UPDATE cdb_stats SET count=count+1 WHERE (type='total' AND variable='hits')  OR (type='month' AND va |
   
2. 
   
3. | 836937 | kile | localhost | kiledata | Query   |   56 | Locked        | UPDATE cdb_stats SET count=count+1 WHERE (type='total' AND variable='hits')  OR (type='month' AND va |
   
4. 
   
5. | 836938 | kile | localhost | kiledata | Query   |   56 | Locked        | UPDATE cdb_stats SET count=count+1 WHERE (type='total' AND variable='hits') OR (type='browser' AND v |
   
6. 
   
7. | 836940 | kile | localhost | kiledata | Query   |   56 | Locked        | UPDATE cdb_stats SET count=count+1 WHERE (type='total' AND variable='hits')  OR (type='month' AND va |
   
8. 
   
9. | 836941 | kile | localhost | kiledata | Query   |   56 | Locked        | UPDATE cdb_stats SET count=count+1 WHERE (type='total' AND variable='hits')  OR (type='month' AND va |
   
10. 
    
11. | 836942 | kile | localhost | kiledata | Query   |   56 | Locked        | UPDATE cdb_stats SET count=count+1 WHERE (type='total' AND variable='hits')  OR (type='month' AND va |
    
12. 
    
13. | 836943 | kile | localhost | kiledata | Query   |   56 | Locked        | UPDATE cdb_stats SET count=count+1 WHERE (type='total' AND variable='hits')  OR (type='month' AND va |
    
14. 
    
15. | 836944 | kile | localhost | kiledata | Query   |   56 | Locked        | UPDATE cdb_stats SET count=count+1 WHERE (type='total' AND variable='hits')  OR (type='month' AND va |

复制代码

wangbin

现在的做法是打开InnoDB，然后 alter table cdb_stats type=InnoDB;

不知道大家有什么好的办法？

万里北国

帮顶，我在这个论坛也注册过的