Warning, /system/ksystemlog/autotests/testFiles/mysql/mysql-slow.log is written in an unsupported language. File is not indexed.
0001 /usr/sbin/mysqld, Version: 5.0.45-Debian_1ubuntu2-log (Debian etch distribution). started with:
0002 Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
0003 Time Id Command Argument
0004 # Time: 070920 11:33:41
0005 # User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
0006 # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 4
0007 SELECT count(*) FROM mysql.user WHERE user='root' and password='';
0008 # Time: 070920 11:39:28
0009 # User@Host: root[root] @ localhost []
0010 # Query_time: 0 Lock_time: 0 Rows_sent: 62 Rows_examined: 62
0011 use alfresco;
0012 SELECT *,
0013 `TABLE_SCHEMA` AS `Db`,
0014 `TABLE_NAME` AS `Name`,
0015 `ENGINE` AS `Engine`,
0016 `ENGINE` AS `Type`,
0017 `VERSION` AS `Version`,
0018 `ROW_FORMAT` AS `Row_format`,
0019 `TABLE_ROWS` AS `Rows`,
0020 `AVG_ROW_LENGTH` AS `Avg_row_length`,
0021 `DATA_LENGTH` AS `Data_length`,
0022 `MAX_DATA_LENGTH` AS `Max_data_length`,
0023 `INDEX_LENGTH` AS `Index_length`,
0024 `DATA_FREE` AS `Data_free`,
0025 `AUTO_INCREMENT` AS `Auto_increment`,
0026 `CREATE_TIME` AS `Create_time`,
0027 `UPDATE_TIME` AS `Update_time`,
0028 `CHECK_TIME` AS `Check_time`,
0029 `TABLE_COLLATION` AS `Collation`,
0030 `CHECKSUM` AS `Checksum`,
0031 `CREATE_OPTIONS` AS `Create_options`,
0032 `TABLE_COMMENT` AS `Comment`
0033 FROM `information_schema`.`TABLES`
0034 WHERE BINARY `TABLE_SCHEMA` IN ('alfresco');
0035 # User@Host: root[root] @ localhost []
0036 # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 2
0037 SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = 'alfresco' LIMIT 1;
0038 # Time: 070920 11:39:29
0039 # User@Host: root[root] @ localhost []
0040 # Query_time: 0 Lock_time: 0 Rows_sent: 62 Rows_examined: 62
0041 SELECT *,
0042 `TABLE_SCHEMA` AS `Db`,
0043 `TABLE_NAME` AS `Name`,
0044 `ENGINE` AS `Engine`,
0045 `ENGINE` AS `Type`,
0046 `VERSION` AS `Version`,
0047 `ROW_FORMAT` AS `Row_format`,
0048 `TABLE_ROWS` AS `Rows`,
0049 `AVG_ROW_LENGTH` AS `Avg_row_length`,
0050 `DATA_LENGTH` AS `Data_length`,
0051 `MAX_DATA_LENGTH` AS `Max_data_length`,
0052 `INDEX_LENGTH` AS `Index_length`,
0053 `DATA_FREE` AS `Data_free`,
0054 `AUTO_INCREMENT` AS `Auto_increment`,
0055 `CREATE_TIME` AS `Create_time`,
0056 `UPDATE_TIME` AS `Update_time`,
0057 `CHECK_TIME` AS `Check_time`,
0058 `TABLE_COLLATION` AS `Collation`,
0059 `CHECKSUM` AS `Checksum`,
0060 `CREATE_OPTIONS` AS `Create_options`,
0061 `TABLE_COMMENT` AS `Comment`
0062 FROM `information_schema`.`TABLES`
0063 WHERE BINARY `TABLE_SCHEMA` IN ('alfresco');
0064 # Time: 070920 11:39:31
0065 # User@Host: root[root] @ localhost []
0066 # Query_time: 0 Lock_time: 0 Rows_sent: 62 Rows_examined: 62
0067 SELECT *,
0068 `TABLE_SCHEMA` AS `Db`,
0069 `TABLE_NAME` AS `Name`,
0070 `ENGINE` AS `Engine`,
0071 `ENGINE` AS `Type`,
0072 `VERSION` AS `Version`,
0073 `ROW_FORMAT` AS `Row_format`,
0074 `TABLE_ROWS` AS `Rows`,
0075 `AVG_ROW_LENGTH` AS `Avg_row_length`,
0076 `DATA_LENGTH` AS `Data_length`,
0077 `MAX_DATA_LENGTH` AS `Max_data_length`,
0078 `INDEX_LENGTH` AS `Index_length`,
0079 `DATA_FREE` AS `Data_free`,
0080 `AUTO_INCREMENT` AS `Auto_increment`,
0081 `CREATE_TIME` AS `Create_time`,
0082 `UPDATE_TIME` AS `Update_time`,
0083 `CHECK_TIME` AS `Check_time`,
0084 `TABLE_COLLATION` AS `Collation`,
0085 `CHECKSUM` AS `Checksum`,
0086 `CREATE_OPTIONS` AS `Create_options`,
0087 `TABLE_COMMENT` AS `Comment`
0088 FROM `information_schema`.`TABLES`
0089 WHERE BINARY `TABLE_SCHEMA` IN ('alfresco');
0090 # Time: 070920 11:39:43
0091 # User@Host: root[root] @ localhost []
0092 # Query_time: 0 Lock_time: 0 Rows_sent: 30 Rows_examined: 30
0093 select * from node
0094 LIMIT 0, 30;