/*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #090416 17:49:26 server id 1 end_log_pos 106 Start: binlog v 4, server v 5.1.35-debug-log created 090416 17:49:26 at startup # Warning: this binlog was not closed properly. Most probably mysqld crashed writing it. ROLLBACK/*!*/; BINLOG ' lmHnSQ8BAAAAZgAAAGoAAAABAAQANS4xLjM1LWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAACWYedJEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC '/*!*/; # at 106 #090416 17:51:27 server id 1 end_log_pos 194 Query thread_id=1 exec_time=0 error_code=0 use test/*!*/; SET TIMESTAMP=1239900687/*!*/; SET @@session.pseudo_thread_id=1/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@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/*!*/; create table test (a int) /*!*/; # at 194 #090416 17:51:52 server id 1 end_log_pos 262 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1239900712/*!*/; BEGIN /*!*/; # at 262 # at 305 #090416 17:51:52 server id 1 end_log_pos 305 Table_map: `test`.`test` mapped to number 17 #090416 17:51:52 server id 1 end_log_pos 339 Write_rows: table id 17 flags: STMT_END_F BINLOG ' KGLnSRMBAAAAKwAAADEBAAAAABEAAAAAAAAABHRlc3QABHRlc3QAAQMAAQ== KGLnSRcBAAAAIgAAAFMBAAAQABEAAAAAAAEAAf/+AQAAAA== '/*!*/; ### INSERT INTO test.test ### SET ### @1=1 # at 339 #090416 17:51:52 server id 1 end_log_pos 408 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1239900712/*!*/; COMMIT /*!*/; # at 408 #090416 17:52:44 server id 1 end_log_pos 476 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1239900764/*!*/; BEGIN /*!*/; # at 476 # at 519 #090416 17:52:41 server id 1 end_log_pos 519 Table_map: `test`.`test` mapped to number 17 #090416 17:52:41 server id 1 end_log_pos 553 Delete_rows: table id 17 flags: STMT_END_F BINLOG ' WWLnSRMBAAAAKwAAAAcCAAAAABEAAAAAAAAABHRlc3QABHRlc3QAAQMAAQ== WWLnSRkBAAAAIgAAACkCAAAQABEAAAAAAAEAAf/+CgAAAA== '/*!*/; ### DELETE FROM test.test ### WHERE ### @1=10 # at 553 #090416 17:52:44 server id 1 end_log_pos 622 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1239900764/*!*/; COMMIT /*!*/; # at 622 #090416 17:52:48 server id 1 end_log_pos 690 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1239900768/*!*/; BEGIN /*!*/; # at 690 # at 733 #090416 17:52:28 server id 1 end_log_pos 733 Table_map: `test`.`test` mapped to number 17 #090416 17:52:28 server id 1 end_log_pos 773 Update_rows: table id 17 flags: STMT_END_F BINLOG ' TGLnSRMBAAAAKwAAAN0CAAAAABEAAAAAAAAABHRlc3QABHRlc3QAAQMAAQ== TGLnSRgBAAAAKAAAAAUDAAAQABEAAAAAAAEAAf///gEAAAD+CgAAAA== '/*!*/; ### UPDATE test.test ### WHERE ### @1=1 ### SET ### @1=10 # at 773 #090416 17:52:48 server id 1 end_log_pos 842 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1239900768/*!*/; COMMIT /*!*/; DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;