MYSQL数据库限制

007

刚收到GD的邮件，这个是说我数据库太大么？谁帮翻译下啊




Dear Sir/Madam,



Regarding your hosting account 007gzs.net:



Access to the dbcnl918com01 MySQL database for the 007gzs.net website 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 dbcnl918com01 data base 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 A.*,B.*,C.title as owner_name,C.is_agent,C.is_vip,C.city_id,C.province_id,C.renzheng FROM l918_business_content_sell A FORCE INDEX(posttime) INNER JOIN `l918_business_sell_fid` sf FORCE INDEX (PRIMARY) ON A.id = sf.id INNER JOIN l918_business_company C ON A.uid = C.uid INNER JOIN l918_business_content_1 B ON A.id=B.id WHERE A.yz = 1 AND sf.fid IN (2016) ORDER BY A.levels DESC, A.posttime DESC LIMIT 0,15

EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE A index posttime 9 870223 Using where
1 SIMPLE B eq_ref PRIMARY PRIMARY 4 dbcnl918com01.A.id 1
1 SIMPLE sf eq_ref PRIMARY PRIMARY 7 dbcnl918com01.A.id,const 1 Using index
1 SIMPLE C ref uid uid 3 dbcnl918com01.A.uid 1

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


Please remove the FORCE INDEX hints.


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.)


*** IMPORTANT ***


Due to the serious nature of this situation, your web site is scheduled to be suspended if you do not take immediate action. This suspension will take place July 19, 2011 if either you fail to reply to this message.


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


If you require clarification in regards to this notice, Go Daddy's Advanced Hosting Support team, can be reached via telephone at 480-505-8871 or via email at networkviolations@godaddy.com .



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

天毅

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

意思是你的一个数据库查询，查找了870223行，这样对系统资源占用非常大，对于虚拟主机来说是不可接受的

你的数据量有那么大？或者你可以考虑让技术人员分表处理算了

具体的语句：
SELECT A.*,B.*,C.title as owner_name,C.is_agent,C.is_vip,C.city_id,C.province_id,C.renzheng FROM l918_business_content_sell A FORCE INDEX(posttime) INNER JOIN `l918_business_sell_fid` sf FORCE INDEX (PRIMARY) ON A.id = sf.id INNER JOIN l918_business_company C ON A.uid = C.uid INNER JOIN l918_business_content_1 B ON A.id=B.id WHERE A.yz = 1 AND sf.fid IN (2016) ORDER BY A.levels DESC, A.posttime DESC LIMIT 0,15

lwbo1987

dbcnl918com01这个数据库占用资源太大了，需要楼主解决