这怎么办？我的网站由于超资源MySQL被停止了

myspa

论坛目前显示：

Discuz! info: Can not connect to MySQL server

Time: 2009-4-25 1:24pm
Script: /index.php

Error: Access denied for user 'abc34d'@'72.167.131.115' (using password: YES)
Errno.: 1045

Similar error report has beed dispatched to administrator before.



我该怎么办啊？请大家指教，谢谢啊

我用的是dz论坛。

Godaddy发给我的邮件如下：

Dear Sir/Madam,

It has come to our attention that your 54shandongren.com hosting account, specifically the abc34d 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:

SELECT
t.tid,t.fid,t.readperm,t.author,t.authorid,t.subject,t.dateline,t.lastpost,t.lastposter,t.views,t.replies,t.highlight,t.digest,t.typeid
,p.message FROM `cdb_threads` t LEFT JOIN `cdb_posts` p ON p.tid=t.tid
AND p.first='1' WHERE t.readperm='0'
AND t.fid IN
('13','42','115','121','123','97','110','111','99','104','109','118','125','126','129','130','120','106','105','122','100','98','101','102','103','27','38','88','75','77','66','67','60','68','10')
AND `special` IN ('')
AND t.displayorder>='0'
AND t.fid>'0'
ORDER BY t.dateline DESC
LIMIT 0,15


This query had been running for more than 2 minutes
.
Explain
+----+-------------+-------+-------+-----------------------------------------------------+--------+---------+------------------------------+-------+-----------------------------+

id select_type table type possible_keys key key_len ref
rows Extra
+----+-------------+-------+-------+-----------------------------------------------------+--------+---------+------------------------------+-------+-----------------------------+

1 SIMPLE t range
displayorder,typeid,displayorder_2,readperm,special typeid 2 NULL
22596 Using where; Using filesort
1 SIMPLE p ref
displayorder,first,first_2 first 4 abc34d.t.tid,const
8 Using where
+----+-------------+-------+-------+-----------------------------------------------------+--------+---------+------------------------------+-------+-----------------------------+

Accessing 180k rows is beyond acceptable limits.

Also the database is consuming 531MB which is beyond our 200MB advertised maximum size.

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.

myspa

现在有什么办法啊？

jjxy456

数据库太大了。

myspa

我知道数据库太大了啊，现在该怎么办啊？

看到前面写的好像占资源也超标，我如果升级到VPS可以解决吗？

add.c

升级到vps可以解决