• /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.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 @ 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 BY count DESC 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.order ASC;
  • # 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怎么受得了 机子内存不够?

*

![](rar.gif)

22570
(2.14 KB, 下载次数: 377)

2013-3-13 21:37 上传
点击文件名下载附件

*