论坛风格切换
  • 5733阅读
  • 3回复

[bug]手机版 慢查询 [复制链接]

上一主题 下一主题
离线top
 

发帖
336
金币
0
威望
59
只看楼主 倒序阅读 使用道具 楼主  发表于: 2012-05-28
# Query_time: 30.882528  Lock_time: 0.000186 Rows_sent: 400  Rows_examined: 2080376
SET timestamp=1338170725;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1039600,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 30.018006  Lock_time: 0.000177 Rows_sent: 400  Rows_examined: 2077976
SET timestamp=1338170725;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1038400,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 30.319799  Lock_time: 0.000162 Rows_sent: 400  Rows_examined: 2051576
SET timestamp=1338170725;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1025200,400;
# Time: 120528 10:05:26
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 28.085818  Lock_time: 0.000155 Rows_sent: 400  Rows_examined: 2073976
SET timestamp=1338170726;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1036400,400;
# Time: 120528 10:05:27
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 18.380546  Lock_time: 0.000139 Rows_sent: 400  Rows_examined: 2048376
SET timestamp=1338170727;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1023600,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 29.066499  Lock_time: 0.000160 Rows_sent: 1  Rows_examined: 1131711
SET timestamp=1338170727;
SELECT count(*) as total FROM pw_threads t FORCE INDEX (idx_postdate) WHERE t.ifcheck = 1 AND t.fid !=0  AND t.postdate <  '1338171058';
# Time: 120528 10:05:29
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 3.276196  Lock_time: 0.000183 Rows_sent: 400  Rows_examined: 2081176
SET timestamp=1338170729;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1040000,400;
# Time: 120528 10:05:51
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 21.195674  Lock_time: 0.000149 Rows_sent: 400  Rows_examined: 2082776
SET timestamp=1338170751;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1040800,400;
# Time: 120528 10:05:52
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 21.947665  Lock_time: 0.208899 Rows_sent: 400  Rows_examined: 2052376
SET timestamp=1338170752;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1025600,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 21.290749  Lock_time: 0.000125 Rows_sent: 400  Rows_examined: 2077976
SET timestamp=1338170752;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1038400,400;
# Time: 120528 10:05:53
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 23.162070  Lock_time: 0.189128 Rows_sent: 400  Rows_examined: 2080376
SET timestamp=1338170753;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1039600,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 22.681838  Lock_time: 0.000089 Rows_sent: 400  Rows_examined: 2068376
SET timestamp=1338170753;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1033600,400;
# Time: 120528 10:05:55
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 22.853524  Lock_time: 0.000141 Rows_sent: 400  Rows_examined: 2076376
SET timestamp=1338170755;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1037600,400;
# Time: 120528 10:05:56
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 23.252480  Lock_time: 0.000125 Rows_sent: 400  Rows_examined: 2077976
SET timestamp=1338170756;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1038400,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 23.091890  Lock_time: 0.000106 Rows_sent: 400  Rows_examined: 2083576
SET timestamp=1338170756;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1041200,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 22.358188  Lock_time: 0.000144 Rows_sent: 400  Rows_examined: 2049176
SET timestamp=1338170756;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1024000,400;
# Time: 120528 10:05:57
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 23.519501  Lock_time: 0.000155 Rows_sent: 400  Rows_examined: 2081976
SET timestamp=1338170757;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1040400,400;
# Time: 120528 10:05:58
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 19.894060  Lock_time: 0.000188 Rows_sent: 400  Rows_examined: 2083576
SET timestamp=1338170758;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1041200,400;
# Time: 120528 10:05:59
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 16.762812  Lock_time: 0.000166 Rows_sent: 400  Rows_examined: 2053176
SET timestamp=1338170759;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1026000,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 16.230836  Lock_time: 0.000181 Rows_sent: 400  Rows_examined: 2082776
SET timestamp=1338170759;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1040800,400;
# User@Host: 0575bbs[0575bbs] @ localhost []
# Query_time: 15.702157  Lock_time: 0.000130 Rows_sent: 400  Rows_examined: 2077976
SET timestamp=1338170759;
SELECT t.*,f.name as forumname FROM pw_threads t LEFT JOIN pw_forums f USING(fid) WHERE t.fid != 0 AND t.ifcheck = 1 AND t.lastpost >=  '1'  AND lastpost <=  '1338150233'  LIMIT 1038400,400;


直接把服务器搞挂了
bbs/aCloud/version/phpwind/common/ver.common.thread.php

具体语句是在这个文件里面的   目前 把函数注释掉了
离线lfyzjck

发帖
22
金币
0
威望
1
只看该作者 沙发  发表于: 2012-05-28
回复测试,不要理我
离线cixinet

发帖
66
金币
8
威望
9
只看该作者 板凳  发表于: 2012-06-16
有具体的解决方案吗?把函数注释掉会有其他问题吗
离线ywhnhvio

发帖
9
金币
0
威望
0
只看该作者 地板  发表于: 2012-10-19
我只是路过,不发表意见<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>美白
快速回复
限100 字节
批量上传需要先选择文件,再选择上传
 
提到某人:
选择好友
上一个 下一个