数据库超载了，停掉了我的数据库，晕，限制真多！

泛泛

让我优化数据库或停掉数据库
晕，就是dedecms的程序，每天采集10来篇文章，还要怎么优化啊？

1. Details given:
   
2. We are notifying you that your account, or a portion or feature of your account has caused an overload on one of our servers. We have a shared hosting environment that we must maintain at a certain level of performance. This performance is monitored and balanced by us, however there are times when accounts can cause the server's load to increase degrading the performance for all other customers on this server.
   
3. 
   
4. To protect your account from further action you must agree to our request for compliance. Please respond to this message stating your intent to do so. You may either log into your control panel with us, and access this ticket via the 24/7 help desk, or provide this ticket number to our Live Chat or phone representatives.
   
5. 
   
6. Failure to respond to this message within 72 hours will result in the suspension of the affected domain with us until such a time as this matter is resolved.
   
7. 
   
8. Most common queries for C326816_*:
   
9. 
   
10. 1.Time: 9% (978 sec)
    
11. Amount: 9% (116 queries)
    
12. Rows Examined/Sent: 539051 / 630
    
13. Avg. Query Exec/Lock Time: 8 / 1 sec.
    
14. Used databases: [C326816_cnmeii|C326816_comweibozhuce|C326816_lmxiangxieli|C326816_infohaoyanwo|C326816_info51yujiadian|C326816_lakala|C326816_com520jiafa|C326816_infohaoejiao|C326816_info51shenhaiyuyou|C326816_inmeitongtuan|C326816_infohaoxueha|C326816_com450v|C326816_infotaobaoxy|C326816_infosty|C326816_infopaipaixy|C326816_info51fengjiao|C326816_comquanqiuguo|C326816_commii3]
    
15. Query example: use C326816_inmeitongtuan; Select arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule, tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath from `dede_archives` arc left join `dede_arctype` tp on arc.typeid=tp.id where FIND_IN_SET('p', arc.flag)>0 And arc.typeid in (6) And arc.arcrank > -1 order by arc.sortrank desc limit 0,1;
    
16. 
    
17. 2.Time: 5% (612 sec)
    
18. Amount: 5% (66 queries)
    
19. Rows Examined/Sent: 26096 / 100
    
20. Avg. Query Exec/Lock Time: 9 / 2 sec.
    
21. Used databases: [C326816_comqfanli]
    
22. Query example: use C326816_comqfanli; select * from duoduo_shop where nick='hntczmd';
    
23. 
    
24. 3.Time: 3% (416 sec)
    
25. Amount: 4% (48 queries)
    
26. Avg. Query Exec/Lock Time: 8 / 1 sec.
    
27. Used databases: [C326816_cnmeii|C326816_com22boy|C326816_info51yujiadian|C326816_comweibozhuce|C326816_comquanqiuguo|C326816_lmxiangxieli|C326816_lakala|C326816_inmeitongtuan|C326816_infohaoejiao|C326816_commii3|C326816_infotaobaoxy|C326816_infosty|C326816_infopaipaixy|C326816_info51fengjiao|C326816_info51dingjiayi|C326816_comyongshentang|C326816_com520lm|C326816_com450v]
    
28. Query example: use C326816_cnmeii; INSERT INTO `dede_arccache`(`md5hash`,`uptime`,`cachedata`) VALUES ('32a803fd398e8aa3470245d26ac0c72e','1304924954', '6981,6990,6983,3971,4050,4235,4038,6977,6651,3920');
    
29. 
    
30. 4.Time: 3% (340 sec)
    
31. Amount: 3% (39 queries)
    
32. Rows Examined/Sent: 49369 / 487
    
33. Avg. Query Exec/Lock Time: 8 / 2 sec.
    
34. Used databases: [C326816_info51shenhaiyuyou|C326816_infosty|C326816_infohaoxueha|C326816_comweibozhuce|C326816_com22boy|C326816_cnmeii|C326816_lmxiangxieli|C326816_inmeitongtuan|C326816_infopaipaixy|C326816_info51yujiadian|C326816_commii3|C326816_lakala|C326816_infohaoyanwo|C326816_info51dingjiayi|C326816_fengxiongjy|C326816_com520jiafa]
    
35. Query example: use C326816_infohaoxueha; Select id From `dede_arctiny` arc where arc.arcrank > -1 And ( arc.typeid = '3' OR CONCAT(',', arc.typeid2, ',') like '%,3,%' ) order by arc.sortrank desc limit 70,10;
    
36. 
    
37. 5.Time: 2% (319 sec)
    
38. Amount: 2% (29 queries)
    
39. Rows Examined/Sent: 29 / 0
    
40. Avg. Query Exec/Lock Time: 11 / 2 sec.
    
41. Used databases: [C326816_comqfanli]
    
42. Query example: use C326816_comqfanli; update duoduo_shop set level=12,score=41987,total_num=42080,good_num=42010,type='C',consumer_protection='' , city='南通',state='江苏',hits=hits+1 where nick='e连锁';
    
43. 
    
44. 6.Time: 2% (297 sec)
    
45. Amount: 3% (36 queries)
    
46. Rows Examined/Sent: 735 / 147
    
47. Avg. Query Exec/Lock Time: 8 / 1 sec.
    
48. Used databases: [C326816_ll100com]
    
49. Query example: use C326816_ll100com; SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (3208, 3206) ORDER BY t.name ASC;
    
50. 
    
51. Databases C326816_* have been chmoded to 0.

复制代码

微微百科

估计是采集造成的，联系他们

66so

以后别采集了啊

微微百科

估计是采集多了，导致数据库超了。