负载低，为什么processed 时间还不理想

hitxiong

主要是打开帖子内容页速度不理想   Processed in 0.119359 second(s), 8 queries , Memcache On

论坛是：http://bbs.tnbz.com/

打开首页速度还可以：  Processed in 0.025015 second(s), 4 queries , Memcache On
打开主题列表页都还可以：Processed in 0.049209 second(s), 7 queries , Memcache On

万网的服务器：四核酷睿2.5G/i3 3G 4G DDRII 320G SATA  ，装的是LNMP 0.9  

GZIP，eAccelerator
0.9.6.1，Memached，都开启了。  GZIP  我是在NGINX那儿开启的，DX里面没开启gzip.

DX2.0论坛，每日IP15000左右，PV 90000 左右。   我觉得我服务器该做的优化都做过了，DX2.0该做的优化设置也做了。

现在就是帖子内容页打开不理想，服务器的负载其实比较小。感觉就是服务器没有完全利用起来。

服务器 状态

[ 本帖最后由 hitxiong 于 2012-7-9 08:29 编辑 ]

hitxiong

hitxiong

hitxiong

有人能给点意见么？  谢谢。

hitxiong

# Query_time: 8.359135  Lock_time: 0.000068 Rows_sent: 39  Rows_examined: 78
use tnbzcomdx20;
SET timestamp=1341734404;
SELECT * FROM pre_forum_ratelog WHERE pid IN (0,1078552,1078559,1078560,1078562,1078584,1078585,1078591,1078594,1078604,1078634) ORDER BY dateline DESC;
# User@Host: mysqluserxdh[mysqluserxdh] @ localhost []
# Query_time: 9.102929  Lock_time: 0.000084 Rows_sent: 10  Rows_examined: 10
SET timestamp=1341734404;
SELECT p.*  FROM pre_forum_post_1 p  WHERE p.tid='19025' AND p.invisible='0'   ORDER BY p.dateline LIMIT 0, 10;
# Time: 120708 16:20:59
# User@Host: mysqluserxdh[mysqluserxdh] @ localhost []
# Query_time: 7.197750  Lock_time: 0.000121 Rows_sent: 20  Rows_examined: 750390
SET timestamp=1341735659;
SELECT p.authorid, p.tid, p.pid, p.fid, p.invisible, p.dateline, p.message, t.special, t.status, t.subject, t.digest,t.attachment, t.replies, t.views, t.lastposter, t.lastpost, t.displayorder FROM pre_forum_post p^M
                INNER JOIN pre_forum_thread t ON t.tid=p.tid  AND t.fid IN('71','75','6','67','2','61','4','73','5','23','64','57','59','15','72','63','70','77','58','68','51','28','55','38','56','60','20','69','25','34','54','22','49','26','27','30','29','32','33','8','65','50','37','36','11','9','41','76','42','43','62','35','19') ^M
                WHERE p.authorid='27369'  AND p.first='0' ORDER BY p.dateline DESC LIMIT 0,20;