经过测试网站打开缓慢与php无直接关系
16317
- 大胡子2013-03-13论坛元老24438
- /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 @ 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 @ 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 @ 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.createdFROM typecho_comments WHERE (typecho_comments.status= 'approved' ) AND (ownerIdauthorId) ORDER BY typecho_comments.coidDESC LIMIT 10; - # Time: 130313 21:39:41
- # User@Host: 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 @ 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 BYcountDESC LIMIT 28; - # User@Host: 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.orderASC; - # Time: 130313 21:40:20
- # User@Host: 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 @ 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 @ 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怎么受得了 机子内存不够?
*

22570
(2.14 KB, 下载次数: 377)2013-3-13 21:37 上传
点击文件名下载附件*