求救

jimesa110

今天收到一封来自godaddy的来信，信的内容是这样的
Dear Sir/Madam,


Regarding your hosting account webcam-driver.com:


The webcam-driver.com database has been suspended for violating Section 3 "Your Obligations" of Go Daddy's “Web Site and Virtual Dedicated Server Service Agreement.”

The relevant passage of this agreement has been provided below:



"If you are hosting your website on Go Daddy’s servers, you are responsible for ensuring there is no excessive overloading on Go Daddy’s DNS or servers. In the event you exceed your allotted bandwidth, compute cycles or disk space and thereby overload Go Daddy’s DNS or servers"
Go Daddy's "Web Site and Virtual Dedicated Server Service Agreement" is located at the following URL: https://www.godaddy.com/agreements/ShowDoc.aspx?pageid=HOSTING_SA

The administrators of Go Daddy’s database servers have discovered that your notebookblog database caused an overload of shared resources for the server that it resides on. This overload threatened the health of the server and, in turn, threatened the connectivity of other customers utilizing it. This is, of course, unacceptable. Go Daddy had no choice but to take immediate action to protect our network and to prevent the possibility of a service interruption for other customers. Your services were suspended as a result.

After detecting this problem Go Daddy's database administrators requested that Go Daddy's Advanced Hosting Support team notify you of the suspension and request that you resolve the underlying issue.

Unfortunately, we are unable to troubleshoot custom scripting, and therefore, unable to provide a specific solution to you. However the following information was provided by our administrators:

Problematic query:
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (1) ) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 5660, 10

EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE wp_posts ref PRIMARY,type_status_date type_status_date 124 const,const 47006 Using where; Using temporary; Using filesort
1 SIMPLE wp_term_relationships eq_ref PRIMARY,term_taxonomy_id PRIMARY 16 notebookblog.wp_posts.ID,const 1 Using index

This query examines 47006 rows, which is unacceptable in shared hosting.

*** IMPORTANT ***

Due to the serious nature of this situation, your web site webcam-driver.com is scheduled to be suspended if you do not take immediate action. This suspension will take place 08/29/2011 if either you fail to reply to this message OR fail to correct the problematic query after committing to do so.

****************

After you have examined this issue, your services can be reactivated by responding to this notice with the following:

1. A statement that you have reviewed and agree to abide by the terms of the "Web Site and Virtual Dedicated Server Service Agreement," and

2. A detailed description of the steps you have taken, or intend to take, to resolve and/or correct this issue, and

3. A statement that you agree to configure your site in such a way as to ensure that there is not a re-occurrence of this issue at any point in the future.

After we receive your reply with these statements we will contact Go Daddy’s database administrators, provide them with your solution, and request that they re-investigate the issue. If they approve your proposed solution, we will reactivate your service. (We reserve the right to suspend services again should its reactivation result in a repeat occurrence of the problem.)

If you have questions about this matter, you may contact us by replying to this email or by calling 480-505-8871.

We appreciate your cooperation in this matter.

Hosting Support Team

我该怎么办，不是懂啊

lwbo1987

你的数据库资源负载过大，需要解决

jimesa110

怎么解决和回复啊

jimesa110

版主，我现在在线等，昨天太迟睡觉了

lwbo1987

删除占用资源过大的脚本程序，可以联系godaddy客服删除，翻译的话可以去翻译版块求助