mysql问题，请教高手

toryzen · 发表于 2010-4-16 09:16:21

我收到一封信，把我的mysql停掉了。。怎么解决，请高手帮忙。
Dear Sir/Madam,

Regarding your hosting account ××××.com:
It has come to our attention that your 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 * from url limit 3376695,10

EXPLAIN:
id| select_type| table| type| possible_keys| key| key_len| ref| rows| Extra
1| SIMPLE| url| ALL| | | | | 7216402|

This query examines 7216402 rows, which is unacceptable in shared hosting. Access will reinstated upon request.

If you have questions about this matter, you may contact us by replying to this email or by calling 480-505-8871.

Please contact us if you have any further questions.

Hosting Support Team

我回复了一封信。
I'm sorry to bring you the trouble.
I have correct the query to
"select * from url order by rand() limit 0,10"
I hope the problems can be sovled by this change.

Would you please re-enable my database?

And I'm not sure the problem can be sovled by the new query or not.
if that query can't sovled that problem,which query should i use to query my database like this?

但是没有两分钟，就有回信了，回信的内容跟第一封信一模一样。。。怎么回事？

add.c · 发表于 2010-4-16 09:50:46

7216402 rows

这个问题呢？

toryzen · 发表于 2010-4-16 10:25:31

那是什么问题？？？

add.c · 发表于 2010-4-16 10:34:20

[提问] mysql问题，请教高手

回复 2# 的帖子

GoDaddy讨论