/*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #110116 23:27:54 server id 1 end_log_pos 107 Start: binlog v 4, server v 5.5.8-log created 110116 23:27:54 at startup ROLLBACK/*!*/; BINLOG ' SuQyTQ8BAAAAZwAAAGsAAAAAAAQANS41LjgtbG9nAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABK5DJNEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA== '/*!*/; # at 107 #110116 23:27:55 server id 1 end_log_pos 221 Query thread_id=1 exec_time=0 error_code=0 use test/*!*/; SET TIMESTAMP=1295180875/*!*/; SET @@session.pseudo_thread_id=1/*!*/; 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 latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; DROP TABLE IF EXISTS `t1` /* generated by server */ /*!*/; # at 221 #110116 23:27:55 server id 1 end_log_pos 344 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1295180875/*!*/; create table t1 (id int auto_increment not null primary key) /*!*/; # at 344 #110116 23:27:55 server id 1 end_log_pos 412 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1295180875/*!*/; BEGIN /*!*/; # at 412 #110116 23:27:55 server id 1 end_log_pos 440 Intvar SET INSERT_ID=1/*!*/; # at 440 #110116 23:27:55 server id 1 end_log_pos 527 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1295180875/*!*/; insert into t1 values () /*!*/; # at 527 #110116 23:27:55 server id 1 end_log_pos 554 Xid = 18 COMMIT/*!*/; # at 554 #110116 23:27:55 server id 2 end_log_pos 622 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1295180875/*!*/; BEGIN /*!*/; # at 622 #110116 23:27:55 server id 2 end_log_pos 650 Intvar SET INSERT_ID=2/*!*/; # at 650 #110116 23:27:55 server id 2 end_log_pos 737 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1295180875/*!*/; insert into t1 values () /*!*/; # at 737 #110116 23:27:55 server id 2 end_log_pos 764 Xid = 20 COMMIT/*!*/; # at 764 #110116 23:27:55 server id 2 end_log_pos 808 Rotate to binary-log.000002 pos: 4 DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;