数据库超资源被封,英语电话打给我,我该怎么回复

csw199388

Our support staff has important information regarding your account, details of which are described below:

Discussion Notes
Support Staff Response
Dear Sir/Madam,


Regarding your hosting account XXXXX.XXXX:



The XXXX database has been suspended for violating Section 3 "Your Obligations" of Go Daddy's “Web Hosting and Virtual Dedicated Hosting 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 Hosting and Virtual Dedicated Hosting 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 csw199388 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 attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM cdb_attachments attach LEFT JOIN cdb_threads t ON t.tid=attach.tid WHERE attach.readperm='0' AND displayorder>='0' AND isimage='1' GROUP BY attach.tid ORDER BY attach.dateline DESC LIMIT 18

EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE attach index tid dateline 8 606214 Using where; Using temporary
1 SIMPLE t eq_ref PRIMARY PRIMARY 3 XXXXX.attach.tid 1 Using where

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

*** IMPORTANT ***

Due to the serious nature of this situation, your web site XXXX.XXXX is scheduled to be suspended if you do not take immediate action. This suspension will take place October 16, 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:
A statement that you have reviewed and agree to abide by the terms of the "Web Hosting and Virtual Dedicated Hosting Service Agreement," and
A detailed description of the steps you have taken, or intend to take, to resolve and/or correct this issue, and
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


--------------------------------------------------------------------------------


If you need further assistance with this matter, please reply to this email or contact customer service at 480-505-8871 and reference [Incident ID: 13057150].

Thanks,
Customer Service

lwbo1987

删除占用资源过大的数据库脚本，如果自己不知道的话，可以联系客服删除，具体的英文可以去翻译版块求助下

mchotdog

优秀你的数据库北。如果是CMS就静态化，如果是别的网站就定时缓存

csw199388

是DISCUZ啊..肯定是设置了缓存的

[ 本帖最后由 csw199388 于 2011-10-12 01:34 PM 编辑 ]

csw199388

我是DISCUZ 7.2,删除这个代码对DISCUZ7.2源程序的正常运行有影响吗?

lwbo1987

如果是数据库代码，删除了肯定对网站有影响的

mchotdog

dz...那个互动类网站基本缓存也没什么用。因为要经常刷新。所以数据库承受不了。。。也是正常的要是自己写的程序还好控制。。。