GODADDY MYSQL数据库负载超标 .使用程序:DISCUZ 7.2

暮木娃娃

你的sql语句查询的量太大了，不能用在虚拟主机上

csw199388

一大早客服打电话给我,也听不懂很多,叫我看邮件,我看了一下,大概就是数据库负载过高,让我检查完后回复邮件,,麻烦各位帮忙看一下什么问题,如何解决...

You will need to correct the following query:





Problematic query:
SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM cdb_attachments attach LEFT JOIN cdb_threads t ON t.tid=attach.tid WHERE attach.readperm='0' AND displayorder>='0' AND isimage='1' GROUP BY attach.tid ORDER BY attach.dateline DESC LIMIT 18

EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE attach index tid dateline 8 941276 Using where; Using temporary
1 SIMPLE t eq_ref PRIMARY PRIMARY 3 XXXXXXXXX.attach.tid 1 Using where

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

20111208sbd

是不是你的网站访问量很大啊

enta

说明你的网站很牛，虚拟主机已经承受不起了，赶快换VPS吧