- 论坛徽章:
- 0
|
本帖最后由 outstrip 于 2012-05-27 15:33 编辑
网站后台缓存刷新后,打开页面的时候基本上就不能打开了,需要将近1分钟才可以打开,然后网站访问就正常; 日志信息如下:
/usr/local/mysql/libexec/mysqld, Version: 5.1.60 (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
# Time: 120527 15:17:47
# User@Host: root[root] @ localhost []
# Query_time: 11.210304 Lock_time: 0.000060 Rows_sent: 30 Rows_examined: 718503
use shop520;
SET timestamp=1338103067;
SELECT s.*,st.tag_name FROM fanwe_share as s
INNER JOIN fanwe_share_category as sc ON sc.share_id = s.share_id
INNER JOIN fanwe_share_tags as st ON st.share_id = s.share_id
INNER JOIN fanwe_goods_category_tags as gct ON gct.cate_id = sc.cate_id
WHERE gct.cate_id in (2,14,15,16,17,1 AND s.is_index=1 AND s.status=1 GROUP BY s.share_id ORDER BY s.sort desc,s.share_id desc limit 30;
# Time: 120527 15:18:16
# User@Host: root[root] @ localhost []
# Query_time: 14.779179 Lock_time: 0.000058 Rows_sent: 10 Rows_examined: 793881
SET timestamp=1338103096;
SELECT s.*,st.tag_name FROM fanwe_share as s
INNER JOIN fanwe_share_category as sc ON sc.share_id = s.share_id
INNER JOIN fanwe_share_tags as st ON st.share_id = s.share_id
INNER JOIN fanwe_goods_category_tags as gct ON gct.cate_id = sc.cate_id
WHERE gct.cate_id in (8,36,37,38,39,40,46) AND s.is_index=1 AND s.status=1 GROUP BY s.share_id ORDER BY s.sort desc,s.share_id desc limit 30;
现在不知道下一步怎么排查问题.谢谢各位大大.指导下下一步该怎么样来排查问题.非常感谢. |
|
免费注册
发表于 2012-05-27 14:49
发表于 2012-05-27 22:03
