收到邮件说数据库影响别的用户 给暂停了 怎么处理

cn286

收到邮件说数据库影响别的用户 给暂停了 怎么处理  暂停了不能登录后台修改数据库了?? 还有要删除的是数据库的内容 但是 userid 在PHPADMIN里面又不能删除 这个怎么办？


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



Dear Sir/Madam,


Regarding your hosting account 0535hz.com:


It has come to our attention that your 0535hz.com hosting account, specifically the ytlife database is causing the shared resources to be over-utilized. This, in turn, affects the usage by other customers.

We have disabled your database to return the server to normal usage. To re-enable your database, you will need to correct the following query:

-Problematic query:
SELECT count(*) FROM my_information WHERE userid LIKE 'asd201011' AND begintime > '1279900800'

EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE my_information ALL 571553 Using where

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


You will have until August 22, 2010, 12:00 pm MST to resolve this issue.

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

add.c

说你这个查询使用数据库资源太多, 要你修改

EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE my_information ALL 571553 Using where