/usr/sbin/mysqld, Version: 5.6.30-76.3-log (Percona Server (GPL), Release 76.3, Revision 3850db5). started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id Command Argument # Time: 160628 22:38:46 # User@Host: root[root] @ localhost [] Id: 14 # Schema: Last_errno: 0 Killed: 0 # Query_time: 0.022693 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 # Bytes_sent: 11 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1467153526; flush logs; # Time: 160628 22:38:48 # User@Host: root[root] @ localhost [] Id: 14 # Schema: Last_errno: 0 Killed: 0 # Query_time: 0.000046 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 # Bytes_sent: 0 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1467153528; # administrator command: Quit; # Time: 160628 22:38:51 # User@Host: root[root] @ localhost [] Id: 15 # Schema: Last_errno: 0 Killed: 0 # Query_time: 0.000294 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 Rows_affected: 0 # Bytes_sent: 123 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1467153531; select @@version_comment limit 1; # Time: 160628 22:38:58 # User@Host: root[root] @ localhost [] Id: 15 # Schema: Last_errno: 0 Killed: 0 # Query_time: 0.000164 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 Rows_affected: 0 # Bytes_sent: 64 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1467153538; SELECT DATABASE(); # User@Host: root[root] @ localhost [] Id: 15 # Schema: slowlog Last_errno: 0 Killed: 0 # Query_time: 0.000096 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 # Bytes_sent: 11 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query use slowlog; SET timestamp=1467153538; # administrator command: Init DB; # User@Host: root[root] @ localhost [] Id: 15 # Schema: slowlog Last_errno: 0 Killed: 0 # Query_time: 0.000722 Lock_time: 0.000149 Rows_sent: 8 Rows_examined: 8 Rows_affected: 0 # Bytes_sent: 210 Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1467153538; show databases; # User@Host: root[root] @ localhost [] Id: 15 # Schema: slowlog Last_errno: 0 Killed: 0 # Query_time: 0.000428 Lock_time: 0.000105 Rows_sent: 1 Rows_examined: 1 Rows_affected: 0 # Bytes_sent: 127 Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1467153538; show tables; # User@Host: root[root] @ localhost [] Id: 15 # Schema: slowlog Last_errno: 0 Killed: 0 # Query_time: 0.000235 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 # Bytes_sent: 211 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1467153538; ; # Time: 160628 22:40:03 # User@Host: root[root] @ localhost [] Id: 15 # Schema: slowlog Last_errno: 0 Killed: 0 # Query_time: 0.000544 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 # Bytes_sent: 18446744073709550783 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1467153603; flush status; # Time: 160628 22:40:25 # User@Host: root[root] @ localhost [] Id: 15 # Schema: slowlog Last_errno: 0 Killed: 0 # Query_time: 0.001879 Lock_time: 0.000253 Rows_sent: 100 Rows_examined: 100 Rows_affected: 0 # Bytes_sent: 798 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # InnoDB_trx_id: F5B # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB_pages_distinct: 3 SET timestamp=1467153625; select i from joinit limit 100; # Time: 160628 22:40:30 # User@Host: root[root] @ localhost [] Id: 15 # Schema: slowlog Last_errno: 0 Killed: 0 # Query_time: 0.000888 Lock_time: 0.000244 Rows_sent: 1 Rows_examined: 1 Rows_affected: 0 # Bytes_sent: 208 Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1467153630; show status like 'handler_read_rnd_next'; # Time: 160628 22:40:43 # User@Host: root[root] @ localhost [] Id: 15 # Schema: slowlog Last_errno: 0 Killed: 0 # Query_time: 0.002341 Lock_time: 0.000436 Rows_sent: 100 Rows_examined: 100 Rows_affected: 0 # Bytes_sent: 5819 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # InnoDB_trx_id: F5C # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB_pages_distinct: 3 SET timestamp=1467153643; select * from joinit limit 100; # Time: 160628 22:41:05 # User@Host: root[root] @ localhost [] Id: 15 # Schema: slowlog Last_errno: 0 Killed: 0 # Query_time: 5.411578 Lock_time: 0.000232 Rows_sent: 524288 Rows_examined: 524288 Rows_affected: 0 # Bytes_sent: 5695202 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # InnoDB_trx_id: F5D # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB_pages_distinct: 2333 SET timestamp=1467153665; select i from joinit; # Time: 160628 22:41:16 # User@Host: root[root] @ localhost [] Id: 15 # Schema: slowlog Last_errno: 0 Killed: 0 # Query_time: 5.674435 Lock_time: 0.000521 Rows_sent: 524288 Rows_examined: 524288 Rows_affected: 0 # Bytes_sent: 31306727 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # InnoDB_trx_id: F5E # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB_pages_distinct: 2333 SET timestamp=1467153676; select * from joinit; # Time: 160628 22:41:27 # User@Host: root[root] @ localhost [] Id: 15 # Schema: slowlog Last_errno: 0 Killed: 0 # Query_time: 0.000947 Lock_time: 0.000269 Rows_sent: 1 Rows_examined: 1 Rows_affected: 0 # Bytes_sent: 213 Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1467153687; show status like 'handler_read_rnd_next'; # Time: 160628 22:41:35 # User@Host: root[root] @ localhost [] Id: 15 # Schema: slowlog Last_errno: 0 Killed: 0 # Query_time: 0.000059 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 # Bytes_sent: 0 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1467153695; # administrator command: Quit;