/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #150127 23:58:37 server id 1 end_log_pos 107 Start: binlog v 4, server v 5.5.28-log created 150127 23:58:37 at startup # Warning: this binlog is either in use or was not closed properly. ROLLBACK/*!*/; BINLOG ' TULIVA8BAAAAZwAAAGsAAAABAAQANS41LjI4LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABNQshUEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA== '/*!*/; # at 107 #150128 0:21:28 server id 1 end_log_pos 195 Query thread_id=3 exec_time=0 error_code=0 use `test`/*!*/; SET TIMESTAMP=1422411688/*!*/; SET @@session.pseudo_thread_id=3/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=0/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8 *//*!*/; SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; create table some (i int) /*!*/; # at 195 #150128 0:21:39 server id 1 end_log_pos 286 Query thread_id=3 exec_time=1 error_code=0 SET TIMESTAMP=1422411699/*!*/; create table example (i int) /*!*/; # at 286 #150128 0:21:44 server id 1 end_log_pos 375 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411704/*!*/; create table names (i int) /*!*/; # at 375 #150128 0:21:54 server id 1 end_log_pos 464 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411714/*!*/; create database otherdb /*!*/; # at 464 #150128 0:21:58 server id 1 end_log_pos 555 Query thread_id=3 exec_time=0 error_code=0 use `otherdb`/*!*/; SET TIMESTAMP=1422411718/*!*/; create table some (i int) /*!*/; # at 555 #150128 0:22:08 server id 1 end_log_pos 647 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411728/*!*/; create table other (i int) /*!*/; # at 647 #150128 0:22:17 server id 1 end_log_pos 744 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411737/*!*/; create table table_names(i int) /*!*/; # at 744 #150128 0:22:50 server id 1 end_log_pos 815 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411770/*!*/; BEGIN /*!*/; # at 815 #150128 0:22:50 server id 1 end_log_pos 912 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411770/*!*/; insert into test.some values () /*!*/; # at 912 #150128 0:22:50 server id 1 end_log_pos 939 Xid = 29 COMMIT/*!*/; # at 939 #150128 0:22:54 server id 1 end_log_pos 1010 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411774/*!*/; BEGIN /*!*/; # at 1010 #150128 0:22:54 server id 1 end_log_pos 1110 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411774/*!*/; insert into test.example values () /*!*/; # at 1110 #150128 0:22:54 server id 1 end_log_pos 1137 Xid = 30 COMMIT/*!*/; # at 1137 #150128 0:22:57 server id 1 end_log_pos 1208 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411777/*!*/; BEGIN /*!*/; # at 1208 #150128 0:22:57 server id 1 end_log_pos 1306 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411777/*!*/; insert into test.names values () /*!*/; # at 1306 #150128 0:22:57 server id 1 end_log_pos 1333 Xid = 31 COMMIT/*!*/; # at 1333 #150128 0:23:04 server id 1 end_log_pos 1404 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411784/*!*/; BEGIN /*!*/; # at 1404 #150128 0:23:04 server id 1 end_log_pos 1496 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411784/*!*/; insert into some values () /*!*/; # at 1496 #150128 0:23:04 server id 1 end_log_pos 1523 Xid = 32 COMMIT/*!*/; # at 1523 #150128 0:23:06 server id 1 end_log_pos 1594 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411786/*!*/; BEGIN /*!*/; # at 1594 #150128 0:23:06 server id 1 end_log_pos 1687 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411786/*!*/; insert into other values () /*!*/; # at 1687 #150128 0:23:06 server id 1 end_log_pos 1714 Xid = 33 COMMIT/*!*/; # at 1714 #150128 0:23:10 server id 1 end_log_pos 1785 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411790/*!*/; BEGIN /*!*/; # at 1785 #150128 0:23:10 server id 1 end_log_pos 1884 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1422411790/*!*/; insert into table_names values () /*!*/; # at 1884 #150128 0:23:10 server id 1 end_log_pos 1911 Xid = 34 COMMIT/*!*/; # at 1911 #150128 0:33:15 server id 1 end_log_pos 1979 Query thread_id=4 exec_time=0 error_code=0 SET TIMESTAMP=1422412395/*!*/; BEGIN /*!*/; # at 1979 #150128 0:33:15 server id 1 end_log_pos 2074 Query thread_id=4 exec_time=0 error_code=0 use `test`/*!*/; SET TIMESTAMP=1422412395/*!*/; insert into test.some values (1) /*!*/; # at 2074 #150128 0:33:15 server id 1 end_log_pos 2101 Xid = 46 COMMIT/*!*/; # at 2101 #150128 0:33:20 server id 1 end_log_pos 2169 Query thread_id=4 exec_time=0 error_code=0 SET TIMESTAMP=1422412400/*!*/; BEGIN /*!*/; # at 2169 #150128 0:33:20 server id 1 end_log_pos 2267 Query thread_id=4 exec_time=0 error_code=0 SET TIMESTAMP=1422412400/*!*/; insert into test.example values (2) /*!*/; # at 2267 #150128 0:33:20 server id 1 end_log_pos 2294 Xid = 47 COMMIT/*!*/; # at 2294 #150128 0:33:25 server id 1 end_log_pos 2362 Query thread_id=4 exec_time=0 error_code=0 SET TIMESTAMP=1422412405/*!*/; BEGIN /*!*/; # at 2362 #150128 0:33:25 server id 1 end_log_pos 2458 Query thread_id=4 exec_time=0 error_code=0 SET TIMESTAMP=1422412405/*!*/; insert into test.names values (3) /*!*/; # at 2458 #150128 0:33:25 server id 1 end_log_pos 2485 Xid = 48 COMMIT/*!*/; # at 2485 #150128 0:33:39 server id 1 end_log_pos 2556 Query thread_id=4 exec_time=0 error_code=0 SET TIMESTAMP=1422412419/*!*/; BEGIN /*!*/; # at 2556 #150128 0:33:39 server id 1 end_log_pos 2649 Query thread_id=4 exec_time=0 error_code=0 use `otherdb`/*!*/; SET TIMESTAMP=1422412419/*!*/; insert into some values (4) /*!*/; # at 2649 #150128 0:33:39 server id 1 end_log_pos 2676 Xid = 56 COMMIT/*!*/; # at 2676 #150128 0:33:44 server id 1 end_log_pos 2747 Query thread_id=4 exec_time=0 error_code=0 SET TIMESTAMP=1422412424/*!*/; BEGIN /*!*/; # at 2747 #150128 0:33:44 server id 1 end_log_pos 2841 Query thread_id=4 exec_time=0 error_code=0 SET TIMESTAMP=1422412424/*!*/; insert into other values (5) /*!*/; # at 2841 #150128 0:33:44 server id 1 end_log_pos 2868 Xid = 57 COMMIT/*!*/; # at 2868 #150128 0:33:52 server id 1 end_log_pos 2939 Query thread_id=4 exec_time=0 error_code=0 SET TIMESTAMP=1422412432/*!*/; BEGIN /*!*/; # at 2939 #150128 0:33:52 server id 1 end_log_pos 3039 Query thread_id=4 exec_time=0 error_code=0 SET TIMESTAMP=1422412432/*!*/; insert into table_names values (6) /*!*/; # at 3039 #150128 0:33:52 server id 1 end_log_pos 3066 Xid = 58 COMMIT/*!*/; DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;