新换的服务器2008R2运行DX3.2之后的效率，有点相死！

doloer · 发表于 2014-8-4 18:50:19

各种插件都挨个测试了，最后开启debug 发现是主题表的问题！但是不知道为什么会这么慢！！

http://bbs.04168.com/forum.php?mod=forumdisplay&fid=51 测试地址，在游客状态下的确很速度，因为有缓存，大约在0.0X 左右！！！

但是在登陆状态下，就不一定了，慢的时候达到 117.X 我设置的是120超时！！

Queries: 18
0.001000s • DBLink 1 • source/class/discuz/discuz_table.php
SELECT * FROM pre_common_member_newprompt WHERE `uid`='1'
0.000000s • DBLink 1 • source/class/table/table_common_session.php
SELECT * FROM pre_common_session WHERE `sid`='cRobR9'
0.001000s • DBLink 1 • source/class/table/table_forum_forum.php
SELECT ff.*, f.* FROM pre_forum_forum f LEFT JOIN pre_forum_forumfield ff ON ff.fid=f.fid WHERE f.fid=51
0.001001s • DBLink 1 • source/class/discuz/discuz_table.php
SELECT * FROM pre_common_member_wechatmp WHERE `uid`='1'
0.001000s • DBLink 1 • source/class/table/table_forum_thread.php
SELECT COUNT(*) FROM pre_forum_thread WHERE fid=51 AND displayorder=-2 AND authorid=1
0.000000s • DBLink 1 • source/class/table/table_forum_forumrecommend.php
SELECT * FROM pre_forum_forumrecommend WHERE fid=51 AND `position` IN('0','1') ORDER BY displayorder
0.000000s • DBLink 1 • source/class/table/table_forum_thread.php
SELECT COUNT(*) FROM pre_forum_thread t WHERE t.`fid` IN('52','53','54','51') AND t.`displayorder`>='0'
0.001000s • DBLink 1 • source/class/table/table_forum_thread.php
SELECT * FROM pre_forum_thread WHERE `tid` IN('1243349','1243357','1244179') AND `displayorder` IN('2','3','4') ORDER BY displayorder DESC, lastpost DESC LIMIT 30
Using where; Using filesort
0.001000s • DBLink 1 • source/class/table/table_forum_thread.php
SELECT * FROM pre_forum_thread WHERE `fid` IN('52','53','54','51') AND `displayorder` IN('0','1') ORDER BY displayorder DESC, lastpost DESC LIMIT 30
Using where; Using filesort
0.001000s • DBLink 1 • source/class/table/table_forum_post.php
SELECT tid, posttableid FROM pre_forum_thread WHERE tid IN('1244280')
0.001000s • DBLink 1 • source/class/table/table_forum_post.php
SELECT * FROM pre_forum_post WHERE tid=1244280 AND first=1
0.002000s • DBLink 1 • source/class/discuz/discuz_table.php
SELECT * FROM pre_forum_threadaddviews WHERE `tid` IN('1244179','1243349','1243357','1244280','1244286','1244287','1244271','1244276','1244275','1244277','1244285','1244284','1244283','1244282','1244281','1244274','1244273','1244272','1244267','1244248','1244257','1244258','1244259','1244260','1244261','1244262','1244263','1244180','1244192','1244210','1244211','1244204','1244061')
0.000000s • DBLink 1 • source/class/discuz/discuz_table.php
SELECT * FROM pre_common_member_verify WHERE `uid` IN('71941','70654','74280')
0.001001s • DBLink 1 • source/class/discuz/discuz_table_archive.php
SELECT * FROM pre_common_member WHERE `uid` IN('70589','281')
0.001000s • DBLink 1 • source/class/discuz/discuz_table.php
SELECT * FROM pre_common_cache WHERE `cachekey`='threadclasscount_51'
0.001000s • DBLink 1 • source/class/table/table_home_favorite.php
SELECT * FROM pre_home_favorite WHERE uid=1 AND idtype='fid' ORDER BY dateline DESC
0.001000s • DBLink 1 • source/class/discuz/discuz_table.php
SELECT count(*) FROM pre_security_failedlog
0.000000s • DBLink 1 • source/class/discuz/discuz_table.php
UPDATE pre_common_session SET `sid`='cRobR9' , `ip1`='113' , `ip2`='239' , `ip3`='148' , `ip4`='42' , `uid`='1' , `username`='doloer' , `groupid`='1' , `invisible`='0' , `action`='2' , `lastactivity`='1407148868' , `fid`='51' , `tid`='0' , `lastolupdate`='1407148934' WHERE `sid`='cRobR9'

复制代码

doloer · 发表于 2014-8-4 18:54:52

目测问题可能出自对 pre_forum_thread 的索引问题，貌似没有有效索引，可能是升级过来的索引异常?
修复N次都如此！！！对于mysql的优化也做到了位，同服务器，PHPCMS 的 250万数据，读取时间也不超过0.5。具体原因真的迷茫，在后台查看主题的时候查询好像相对，快一些，肯定不能超过2秒就读取出来了！！

pcyi · 发表于 2014-8-5 08:33:51

楼主Discuz!X3.2的Debug模式在哪儿开启之前X2.5之类方法不奏效

imtest01 · 发表于 2014-8-6 13:27:16

学习了。

doloer · 发表于 2014-8-7 18:16:14

pcyi 发表于 2014-8-5 08:33
楼主Discuz!X3.2的Debug模式在哪儿开启之前X2.5之类方法不奏效

开启 debug 需要 debug 运行库支持，使用X3利系列的就可以论坛里面有下载的！！

开启方式就是在 config 加上一句 $_config['debug'] = 'xxxx'; xxxx 相当于进入 debug 的密码！！！

pcyi · 发表于 2014-8-8 07:54:08

doloer 发表于 2014-8-7 18:16
开启 debug 需要 debug 运行库支持，使用X3利系列的就可以论坛里面有下载的！！

开启方式就是在 con ...

我找找看X3系列的Debug文件，谢谢了

doloer · 发表于 2014-8-8 17:56:37

就这么就沉下去了吗、？？？

wang714806849 · 发表于 2014-8-9 07:50:19

还是用LINUX会快很多

		自动登录	找回密码
密码			立即注册