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

hitxiong 发表于 2012-7-7 20:35:20

主要是打开帖子内容页速度不理想 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 发表于 2012-7-7 20:36:50

服务器探针

http://att.discuz.net/data/attachment/forum/201207/07/195803h4xhqhluxsxlx4gv.jpg

hitxiong 发表于 2012-7-7 20:40:22

DXdebug 功能打开的图

http://att.discuz.net/data/attachment/forum/201207/07/201748tsc72nqbtxnk2rm2.jpg

hitxiong 发表于 2012-7-9 08:28:55

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

hitxiong 发表于 2012-7-10 13:05:12

X2慢查询日志,慢的到10秒了

# Query_time: 8.359135Lock_time: 0.000068 Rows_sent: 39Rows_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 @ localhost []
# Query_time: 9.102929Lock_time: 0.000084 Rows_sent: 10Rows_examined: 10
SET timestamp=1341734404;
SELECT p.*FROM pre_forum_post_1 pWHERE p.tid='19025' AND p.invisible='0' ORDER BY p.dateline LIMIT 0, 10;
# Time: 120708 16:20:59
# User@Host: mysqluserxdh @ localhost []
# Query_time: 7.197750Lock_time: 0.000121 Rows_sent: 20Rows_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.tidAND 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;

页: [1]

VPS侦探论坛's Archiver