GD 数据库

you2011

我网站使用的是zencart系统，今天突然数据库中断了，原来是数据库被停止了，收到一封gd客服发过来的邮件.
邮件内容如下：
Dear Sir/Madam,

Regarding your hosting account 根目录网站.com:

The shoeskd 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 shoeskd 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 p.products_id, p.products_image, pd.products_name, p.master_categories_id
from (products p
left join specials s on p.products_id = s.products_id
left join products_description pd on p.products_id = pd.products_id )
where p.products_id = s.products_id
and p.products_id = pd.products_id
and p.products_status = '1' and s.status = 1
and pd.language_id = '1'

EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s ALL idx_status_zen,idx_products_id_zen 25853 Using where
1 SIMPLE pd eq_ref PRIMARY PRIMARY 8 shoeskd.s.products_id,const 1 Using where
1 SIMPLE p eq_ref PRIMARY,idx_products_status_zen PRIMARY 4 shoeskd.s.products_id 1 Using where

This multi-table query examines table 'specials', which uses no indexes, which is unacceptable in shared hosting.

*** IMPORTANT ***

Due to the serious nature of this situation, your web site xxxxxxxxx.com is scheduled to be suspended if you do not take immediate action. This suspension will take place October 2, 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 Hosting and Virtual Dedicated Hosting 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
请问我该如何解决？？ 是不是数据库被人攻击导致呢？？？

[ 本帖最后由 you2011 于 2011-9-28 01:02 PM 编辑 ]

lwbo1987

数据库超资源了，删除数据库吧

you2011

老大有没有什么办法避免这个问题呢》》？？
关闭网站的插件会好一点呢？

lwbo1987

数据库的问题，你自己检查下为什么数据库会超资源

dwjy

数据库好大的，不容易超啊

lwbo1987

不一定是数据库容量超了，可能是数据库占用资源过大，影响了别人的使用

psdshow

弄不懂你们家SQL怎么写的
已经写了的条件 where还要加上去?
select p.products_id, p.products_image, pd.products_name, p.master_categories_id
from (products p
left join specials s on p.products_id = s.products_id
left join products_description pd on p.products_id = pd.products_id )
where p.products_id = s.products_id
and p.products_id = pd.products_idand p.products_status = '1' and s.status = 1
and pd.language_id = '1'

[ 本帖最后由 psdshow 于 2011-9-28 10:11 PM 编辑 ]

you2011

我数据库大小是：80mb
我是菜鸟 对数据库不懂，无法分析出原因，
请问使用phpadmin 数据库优化 这个功能对数据库有没有影响。帮助。

[ 本帖最后由 you2011 于 2011-9-28 11:24 PM 编辑 ]

lwbo1987

数据库优化并不能解决你的问题，还是联系客服问问吧