经过测试网站打开缓慢与php无直接关系

大胡子 · 发表于 2013-3-13 21:38:09

/usr/sbin/mysqld, Version: 5.1.66-0+squeeze1-log ((Debian)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
# Time: 130313 21:38:12
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Query_time: 0.000497 Lock_time: 0.000163 Rows_sent: 1 Rows_examined: 5
SET timestamp=1363181892;
SELECT count(*) FROM mysql.user WHERE user='root' and password='';
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Query_time: 0.015748 Lock_time: 0.000267 Rows_sent: 36 Rows_examined: 58
SET timestamp=1363181892;
select concat('select count(*) into @discard from `',
TABLE_SCHEMA, '`.`', TABLE_NAME, '`')
from information_schema.TABLES where ENGINE='MyISAM';
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Query_time: 0.025962 Lock_time: 0.000291 Rows_sent: 0 Rows_examined: 590
SET timestamp=1363181892;
select count(*) into @discard from `information_schema`.`COLUMNS`;
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Query_time: 0.000553 Lock_time: 0.000426 Rows_sent: 0 Rows_examined: 0
SET timestamp=1363181892;
select count(*) into @discard from `information_schema`.`EVENTS`;
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Query_time: 0.028746 Lock_time: 0.000403 Rows_sent: 0 Rows_examined: 58
SET timestamp=1363181892;
select count(*) into @discard from `information_schema`.`PARTITIONS`;
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Query_time: 0.000478 Lock_time: 0.000212 Rows_sent: 0 Rows_examined: 10
SET timestamp=1363181892;
select count(*) into @discard from `information_schema`.`PLUGINS`;
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Query_time: 0.000345 Lock_time: 0.000194 Rows_sent: 0 Rows_examined: 1
SET timestamp=1363181892;
select count(*) into @discard from `information_schema`.`PROCESSLIST`;
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Query_time: 0.000396 Lock_time: 0.000293 Rows_sent: 0 Rows_examined: 0
SET timestamp=1363181892;
select count(*) into @discard from `information_schema`.`ROUTINES`;
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Query_time: 0.002947 Lock_time: 0.000247 Rows_sent: 0 Rows_examined: 0
SET timestamp=1363181892;
select count(*) into @discard from `information_schema`.`TRIGGERS`;
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Query_time: 0.002985 Lock_time: 0.000246 Rows_sent: 0 Rows_examined: 0
SET timestamp=1363181892;
select count(*) into @discard from `information_schema`.`VIEWS`;
# Time: 130313 21:39:24
# User@Host: aabbcc[aabbcc] @ localhost []
# Query_time: 0.001011 Lock_time: 0.000059 Rows_sent: 52 Rows_examined: 52
use aabbcc;
SET timestamp=1363181964;
SELECT * FROM typecho_options WHERE (`user` = 0 );
# User@Host: aabbcc[aabbcc] @ localhost []
# Query_time: 0.000126 Lock_time: 0.000031 Rows_sent: 0 Rows_examined: 52
SET timestamp=1363181964;
SELECT * FROM typecho_options WHERE (`user` = '1' );
# Time: 130313 21:39:28
# User@Host: aabbcc[aabbcc] @ localhost []
# Query_time: 0.001375 Lock_time: 0.000151 Rows_sent: 2 Rows_examined: 4
SET timestamp=1363181968;
SELECT typecho_comments.`coid` , typecho_comments.`cid` , typecho_comments.`author` , typecho_comments.`mail` , typecho_comments.`url` , typecho_comments.`ip` , typecho_comments.`authorId` , typecho_comments.`ownerId` , typecho_comments.`agent` , typecho_comments.`text` , typecho_comments.`type` , typecho_comments.`status` , typecho_comments.`parent` , typecho_comments.`created` FROM typecho_comments WHERE (typecho_comments.`status` = 'approved' ) AND (`ownerId` <> `authorId` ) ORDER BY typecho_comments.`coid` DESC LIMIT 10;
# Time: 130313 21:39:41
# User@Host: aabbcc[aabbcc] @ localhost []
# Query_time: 12.555035 Lock_time: 0.000053 Rows_sent: 30 Rows_examined: 15135
SET timestamp=1363181981;
SELECT * FROM typecho_contents WHERE (`status` = 'publish' ) AND (`type` = 'post' ) ORDER BY RAND() ASC LIMIT 30;
# User@Host: aabbcc[aabbcc] @ localhost []
# Query_time: 0.000330 Lock_time: 0.000065 Rows_sent: 24 Rows_examined: 58
SET timestamp=1363181981;
SELECT * FROM typecho_metas WHERE (`type` = 'tag' ) AND (`count` > 0 ) ORDER BY `count` DESC LIMIT 28;
# User@Host: aabbcc[aabbcc] @ localhost []
# Query_time: 0.000295 Lock_time: 0.000087 Rows_sent: 10 Rows_examined: 44
SET timestamp=1363181981;
SELECT * FROM typecho_metas WHERE (`type` = 'category' ) ORDER BY typecho_metas.`order` ASC;
# Time: 130313 21:40:20
# User@Host: aabbcc[aabbcc] @ localhost []
# Query_time: 9.610633 Lock_time: 0.000123 Rows_sent: 30 Rows_examined: 15135
SET timestamp=1363182020;
SELECT * FROM typecho_contents WHERE (`status` = 'publish' ) AND (`type` = 'post' ) ORDER BY RAND() ASC LIMIT 30;
# Time: 130313 21:40:56
# User@Host: aabbcc[aabbcc] @ localhost []
# Query_time: 7.751408 Lock_time: 0.000074 Rows_sent: 30 Rows_examined: 15135
SET timestamp=1363182056;
SELECT * FROM typecho_contents WHERE (`status` = 'publish' ) AND (`type` = 'post' ) ORDER BY RAND() ASC LIMIT 30;
# Time: 130313 21:41:09
# User@Host: aabbcc[aabbcc] @ localhost []
# Query_time: 8.684856 Lock_time: 0.000103 Rows_sent: 30 Rows_examined: 15135
SET timestamp=1363182069;
SELECT * FROM typecho_contents WHERE (`status` = 'publish' ) AND (`type` = 'post' ) ORDER BY RAND() ASC LIMIT 30;

复制代码

求带每次查询时间基本7 -15秒这Y怎么受得了机子内存不够？

my.rar (2.14 KB, 下载次数: 375)

_____________Cc · 发表于 2013-3-13 21:38:46

看的晕乎乎的 ——来自MJJ果冻的挂机宝

犯戒心 · 发表于 2013-3-13 21:57:53

看不懂

过客 · 发表于 2013-3-13 21:59:26

_____________Cc 发表于 2013-3-13 21:38
看的晕乎乎的 ...

+1

wdlth · 发表于 2013-3-13 22:06:44

发slow-queries.log

动感天地 · 发表于 2013-3-13 22:07:03

晕乎乎的飘过~~

大胡子 · 发表于 2013-3-13 22:15:14

wdlth 发表于 2013-3-13 22:06
发slow-queries.log

这个就是

wangzenggogo · 发表于 2013-3-13 22:19:57

提示: 作者被禁止或删除内容自动屏蔽

smyz · 发表于 2013-3-13 22:30:07

大胡子。。。优化下php的SQL语句。。。

wdlth · 发表于 2013-3-13 22:31:38

大胡子发表于 2013-3-13 22:15
这个就是

看来有点索引不对，发show status和表结构出来看看。

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

wangzenggogo wangzenggogo 当前离线积分 1657	发表于 2013-3-13 22:19:57 \| 显示全部楼层提示: 作者被禁止或删除内容自动屏蔽
wangzenggogo wangzenggogo 当前离线积分 1657
	回复支持反对举报

经过测试网站打开缓慢与php无直接关系

相关帖子