|
|
Dear Sir/Madam,
Regarding your hosting account blog.shenl.com:
The XXX 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 XXX 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:
You will need to correct the following query :
Problematic query:
Select id,title,sortid From dede_story_content where bookid=664 And chapterid=1964 And sortid<7 order by sortid desc LIMIT 0,1
EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE dede_story_content ALL 130173 Using where; Using filesort
This query examines 130173 rows, which is unacceptable in shared hosting.
*** IMPORTANT ***
Due to the serious nature of this situation, your web site XXX.com is scheduled to be suspended if you do not take immediate action. This suspension will take place August 7, 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 |
|