/*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #090222 16:52:44 server id 1 end_log_pos 107 Start: binlog v 4, server v 6.0.9-alpha-log created 090222 16:52:44 at startup # Warning: this binlog was not closed properly. Most probably mysqld crashed writing it. ROLLBACK/*!*/; BINLOG ' zHShSQ8BAAAAZwAAAGsAAAABAAQANi4wLjktYWxwaGEtbG9nAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAADMdKFJEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA== '/*!*/; # at 107 #090222 16:52:52 server id 1 end_log_pos 217 Query thread_id=1 exec_time=0 error_code=0 use test/*!*/; SET TIMESTAMP=1235317972/*!*/; SET @@session.pseudo_thread_id=1/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=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 table10_innodb_int_autoinc /*!*/; # at 217 #090222 16:52:52 server id 1 end_log_pos 392 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317972/*!*/; CREATE TABLE `table10_innodb_int_autoinc` (pk integer auto_increment, `int` int, primary key (pk)) ENGINE=innodb /*!*/; # at 392 #090222 16:52:52 server id 1 end_log_pos 460 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317972/*!*/; BEGIN /*!*/; # at 460 # at 526 #090222 16:52:52 server id 1 end_log_pos 526 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 16 #090222 16:52:52 server id 1 end_log_pos 645 Write_rows: table id 16 flags: STMT_END_F BINLOG ' 1HShSRMBAAAAQgAAAA4CAAAAABAAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 1HShSRcBAAAAdwAAAIUCAAAQABAAAAAAAAEAAv/8AQAAAGQAAAD8AgAAAGQAAAD8AwAAAGQAAAD8 BAAAAGQAAAD8BQAAAGQAAAD8BgAAAGQAAAD8BwAAAGQAAAD8CAAAAGQAAAD8CQAAAGQAAAD8CgAA AGQAAAA= '/*!*/; ### INSERT INTO test.table10_innodb_int_autoinc ### SET ### @1=1 ### @2=100 ### INSERT INTO test.table10_innodb_int_autoinc ### SET ### @1=2 ### @2=100 ### INSERT INTO test.table10_innodb_int_autoinc ### SET ### @1=3 ### @2=100 ### INSERT INTO test.table10_innodb_int_autoinc ### SET ### @1=4 ### @2=100 ### INSERT INTO test.table10_innodb_int_autoinc ### SET ### @1=5 ### @2=100 ### INSERT INTO test.table10_innodb_int_autoinc ### SET ### @1=6 ### @2=100 ### INSERT INTO test.table10_innodb_int_autoinc ### SET ### @1=7 ### @2=100 ### INSERT INTO test.table10_innodb_int_autoinc ### SET ### @1=8 ### @2=100 ### INSERT INTO test.table10_innodb_int_autoinc ### SET ### @1=9 ### @2=100 ### INSERT INTO test.table10_innodb_int_autoinc ### SET ### @1=10 ### @2=100 # at 645 #090222 16:52:52 server id 1 end_log_pos 672 Xid = 6 COMMIT/*!*/; # at 672 #090222 16:52:52 server id 1 end_log_pos 755 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317972/*!*/; create database omer /*!*/; # at 755 #090222 16:52:52 server id 1 end_log_pos 878 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317972/*!*/; create table omer.zzlog (d datetime, rw int, od int, nw int) /*!*/; # at 878 #090222 16:52:52 server id 1 end_log_pos 1125 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317972/*!*/; CREATE DEFINER=`root`@`localhost` trigger log_updates after update on test.table10_innodb_int_autoinc for each row insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) /*!*/; # at 1125 #090222 16:52:52 server id 1 end_log_pos 1201 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317972/*!*/; SET /*!*/; SET @@session.time_zone='SYSTEM'/*!*/; BEGIN /*!*/; # at 1201 # at 1267 # at 1314 # at 1358 #090222 16:52:52 server id 1 end_log_pos 1267 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:52 server id 1 end_log_pos 1314 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:52 server id 1 end_log_pos 1358 Update_rows: table id 17 #090222 16:52:52 server id 1 end_log_pos 1408 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 1HShSRMBAAAAQgAAAPMEAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 1HShSRMBAAAALwAAACIFAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 1HShSRgBAAAALAAAAE4FAAAAABEAAAAAAAAAAgMC/AkAAABkAAAA/loAAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=9 ### @2=100 ### SET ### @2=90 1HShSRcBAAAAMgAAAIAFAAAQABIAAAAAAAEABA/wJIuOnkUSAAAJAAAAZAAAAFoAAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:52 ### @2=9 ### @3=100 ### @4=90 # at 1408 #090222 16:52:52 server id 1 end_log_pos 1485 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317972/*!*/; COMMIT /*!*/; # at 1485 #090222 16:52:52 server id 1 end_log_pos 1561 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317972/*!*/; BEGIN /*!*/; # at 1561 # at 1627 # at 1674 # at 1718 #090222 16:52:52 server id 1 end_log_pos 1627 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:52 server id 1 end_log_pos 1674 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:52 server id 1 end_log_pos 1718 Update_rows: table id 17 #090222 16:52:52 server id 1 end_log_pos 1768 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 1HShSRMBAAAAQgAAAFsGAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 1HShSRMBAAAALwAAAIoGAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 1HShSRgBAAAALAAAALYGAAAAABEAAAAAAAAAAgMC/AUAAABkAAAA/m4AAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=5 ### @2=100 ### SET ### @2=110 1HShSRcBAAAAMgAAAOgGAAAQABIAAAAAAAEABA/wJIuOnkUSAAAFAAAAZAAAAG4AAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:52 ### @2=5 ### @3=100 ### @4=110 # at 1768 #090222 16:52:52 server id 1 end_log_pos 1845 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317972/*!*/; COMMIT /*!*/; # at 1845 #090222 16:52:53 server id 1 end_log_pos 1921 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317973/*!*/; BEGIN /*!*/; # at 1921 # at 1987 # at 2034 # at 2078 #090222 16:52:53 server id 1 end_log_pos 1987 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:53 server id 1 end_log_pos 2034 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:53 server id 1 end_log_pos 2078 Update_rows: table id 17 #090222 16:52:53 server id 1 end_log_pos 2128 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 1XShSRMBAAAAQgAAAMMHAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 1XShSRMBAAAALwAAAPIHAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 1XShSRgBAAAALAAAAB4IAAAAABEAAAAAAAAAAgMC/AkAAABaAAAA/lAAAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=9 ### @2=90 ### SET ### @2=80 1XShSRcBAAAAMgAAAFAIAAAQABIAAAAAAAEABA/wJYuOnkUSAAAJAAAAWgAAAFAAAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:53 ### @2=9 ### @3=90 ### @4=80 # at 2128 #090222 16:52:53 server id 1 end_log_pos 2205 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317973/*!*/; COMMIT /*!*/; # at 2205 #090222 16:52:53 server id 1 end_log_pos 2281 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317973/*!*/; BEGIN /*!*/; # at 2281 # at 2347 # at 2394 # at 2438 #090222 16:52:53 server id 1 end_log_pos 2347 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:53 server id 1 end_log_pos 2394 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:53 server id 1 end_log_pos 2438 Update_rows: table id 17 #090222 16:52:53 server id 1 end_log_pos 2488 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 1XShSRMBAAAAQgAAACsJAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 1XShSRMBAAAALwAAAFoJAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 1XShSRgBAAAALAAAAIYJAAAAABEAAAAAAAAAAgMC/AEAAABkAAAA/m4AAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=1 ### @2=100 ### SET ### @2=110 1XShSRcBAAAAMgAAALgJAAAQABIAAAAAAAEABA/wJYuOnkUSAAABAAAAZAAAAG4AAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:53 ### @2=1 ### @3=100 ### @4=110 # at 2488 #090222 16:52:53 server id 1 end_log_pos 2565 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317973/*!*/; COMMIT /*!*/; # at 2565 #090222 16:52:54 server id 1 end_log_pos 2641 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317974/*!*/; BEGIN /*!*/; # at 2641 # at 2707 # at 2754 # at 2798 #090222 16:52:54 server id 1 end_log_pos 2707 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:54 server id 1 end_log_pos 2754 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:54 server id 1 end_log_pos 2798 Update_rows: table id 17 #090222 16:52:54 server id 1 end_log_pos 2848 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 1nShSRMBAAAAQgAAAJMKAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 1nShSRMBAAAALwAAAMIKAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 1nShSRgBAAAALAAAAO4KAAAAABEAAAAAAAAAAgMC/AcAAABkAAAA/loAAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=7 ### @2=100 ### SET ### @2=90 1nShSRcBAAAAMgAAACALAAAQABIAAAAAAAEABA/wJouOnkUSAAAHAAAAZAAAAFoAAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:54 ### @2=7 ### @3=100 ### @4=90 # at 2848 #090222 16:52:54 server id 1 end_log_pos 2925 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317974/*!*/; COMMIT /*!*/; # at 2925 #090222 16:52:54 server id 1 end_log_pos 3001 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317974/*!*/; BEGIN /*!*/; # at 3001 # at 3067 # at 3114 # at 3158 #090222 16:52:54 server id 1 end_log_pos 3067 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:54 server id 1 end_log_pos 3114 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:54 server id 1 end_log_pos 3158 Update_rows: table id 17 #090222 16:52:54 server id 1 end_log_pos 3208 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 1nShSRMBAAAAQgAAAPsLAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 1nShSRMBAAAALwAAACoMAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 1nShSRgBAAAALAAAAFYMAAAAABEAAAAAAAAAAgMC/AMAAABkAAAA/m4AAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=3 ### @2=100 ### SET ### @2=110 1nShSRcBAAAAMgAAAIgMAAAQABIAAAAAAAEABA/wJouOnkUSAAADAAAAZAAAAG4AAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:54 ### @2=3 ### @3=100 ### @4=110 # at 3208 #090222 16:52:54 server id 1 end_log_pos 3285 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317974/*!*/; COMMIT /*!*/; # at 3285 #090222 16:52:55 server id 1 end_log_pos 3361 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317975/*!*/; BEGIN /*!*/; # at 3361 # at 3427 # at 3474 # at 3518 #090222 16:52:55 server id 1 end_log_pos 3427 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:55 server id 1 end_log_pos 3474 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:55 server id 1 end_log_pos 3518 Update_rows: table id 17 #090222 16:52:55 server id 1 end_log_pos 3568 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 13ShSRMBAAAAQgAAAGMNAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 13ShSRMBAAAALwAAAJINAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 13ShSRgBAAAALAAAAL4NAAAAABEAAAAAAAAAAgMC/AcAAABaAAAA/lAAAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=7 ### @2=90 ### SET ### @2=80 13ShSRcBAAAAMgAAAPANAAAQABIAAAAAAAEABA/wJ4uOnkUSAAAHAAAAWgAAAFAAAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:55 ### @2=7 ### @3=90 ### @4=80 # at 3568 #090222 16:52:55 server id 1 end_log_pos 3645 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317975/*!*/; COMMIT /*!*/; # at 3645 #090222 16:52:55 server id 1 end_log_pos 3721 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317975/*!*/; BEGIN /*!*/; # at 3721 # at 3787 # at 3834 # at 3878 #090222 16:52:55 server id 1 end_log_pos 3787 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:55 server id 1 end_log_pos 3834 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:55 server id 1 end_log_pos 3878 Update_rows: table id 17 #090222 16:52:55 server id 1 end_log_pos 3928 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 13ShSRMBAAAAQgAAAMsOAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 13ShSRMBAAAALwAAAPoOAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 13ShSRgBAAAALAAAACYPAAAAABEAAAAAAAAAAgMC/AMAAABuAAAA/ngAAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=3 ### @2=110 ### SET ### @2=120 13ShSRcBAAAAMgAAAFgPAAAQABIAAAAAAAEABA/wJ4uOnkUSAAADAAAAbgAAAHgAAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:55 ### @2=3 ### @3=110 ### @4=120 # at 3928 #090222 16:52:55 server id 1 end_log_pos 4005 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317975/*!*/; COMMIT /*!*/; # at 4005 #090222 16:52:56 server id 1 end_log_pos 4081 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317976/*!*/; BEGIN /*!*/; # at 4081 # at 4147 # at 4194 # at 4238 #090222 16:52:56 server id 1 end_log_pos 4147 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:56 server id 1 end_log_pos 4194 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:56 server id 1 end_log_pos 4238 Update_rows: table id 17 #090222 16:52:56 server id 1 end_log_pos 4288 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 2HShSRMBAAAAQgAAADMQAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 2HShSRMBAAAALwAAAGIQAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 2HShSRgBAAAALAAAAI4QAAAAABEAAAAAAAAAAgMC/AgAAABkAAAA/loAAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=8 ### @2=100 ### SET ### @2=90 2HShSRcBAAAAMgAAAMAQAAAQABIAAAAAAAEABA/wKIuOnkUSAAAIAAAAZAAAAFoAAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:56 ### @2=8 ### @3=100 ### @4=90 # at 4288 #090222 16:52:56 server id 1 end_log_pos 4365 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317976/*!*/; COMMIT /*!*/; # at 4365 #090222 16:52:57 server id 1 end_log_pos 4441 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317977/*!*/; BEGIN /*!*/; # at 4441 # at 4507 # at 4554 # at 4598 #090222 16:52:57 server id 1 end_log_pos 4507 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:57 server id 1 end_log_pos 4554 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:57 server id 1 end_log_pos 4598 Update_rows: table id 17 #090222 16:52:57 server id 1 end_log_pos 4648 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 2XShSRMBAAAAQgAAAJsRAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 2XShSRMBAAAALwAAAMoRAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 2XShSRgBAAAALAAAAPYRAAAAABEAAAAAAAAAAgMC/AYAAABkAAAA/loAAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=6 ### @2=100 ### SET ### @2=90 2XShSRcBAAAAMgAAACgSAAAQABIAAAAAAAEABA/wKYuOnkUSAAAGAAAAZAAAAFoAAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:57 ### @2=6 ### @3=100 ### @4=90 # at 4648 #090222 16:52:57 server id 1 end_log_pos 4725 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317977/*!*/; COMMIT /*!*/; # at 4725 #090222 16:52:57 server id 1 end_log_pos 4801 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317977/*!*/; BEGIN /*!*/; # at 4801 # at 4867 # at 4914 # at 4958 #090222 16:52:57 server id 1 end_log_pos 4867 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:57 server id 1 end_log_pos 4914 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:57 server id 1 end_log_pos 4958 Update_rows: table id 17 #090222 16:52:57 server id 1 end_log_pos 5008 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 2XShSRMBAAAAQgAAAAMTAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 2XShSRMBAAAALwAAADITAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 2XShSRgBAAAALAAAAF4TAAAAABEAAAAAAAAAAgMC/AkAAABQAAAA/loAAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=9 ### @2=80 ### SET ### @2=90 2XShSRcBAAAAMgAAAJATAAAQABIAAAAAAAEABA/wKYuOnkUSAAAJAAAAUAAAAFoAAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:57 ### @2=9 ### @3=80 ### @4=90 # at 5008 #090222 16:52:57 server id 1 end_log_pos 5085 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317977/*!*/; COMMIT /*!*/; # at 5085 #090222 16:52:58 server id 1 end_log_pos 5161 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317978/*!*/; BEGIN /*!*/; # at 5161 # at 5227 # at 5274 # at 5318 #090222 16:52:58 server id 1 end_log_pos 5227 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:58 server id 1 end_log_pos 5274 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:58 server id 1 end_log_pos 5318 Update_rows: table id 17 #090222 16:52:58 server id 1 end_log_pos 5368 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 2nShSRMBAAAAQgAAAGsUAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 2nShSRMBAAAALwAAAJoUAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 2nShSRgBAAAALAAAAMYUAAAAABEAAAAAAAAAAgMC/AkAAABaAAAA/lAAAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=9 ### @2=90 ### SET ### @2=80 2nShSRcBAAAAMgAAAPgUAAAQABIAAAAAAAEABA/wKouOnkUSAAAJAAAAWgAAAFAAAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:58 ### @2=9 ### @3=90 ### @4=80 # at 5368 #090222 16:52:58 server id 1 end_log_pos 5445 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317978/*!*/; COMMIT /*!*/; # at 5445 #090222 16:52:58 server id 1 end_log_pos 5521 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317978/*!*/; BEGIN /*!*/; # at 5521 # at 5587 # at 5634 # at 5678 #090222 16:52:58 server id 1 end_log_pos 5587 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:58 server id 1 end_log_pos 5634 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:58 server id 1 end_log_pos 5678 Update_rows: table id 17 #090222 16:52:58 server id 1 end_log_pos 5728 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 2nShSRMBAAAAQgAAANMVAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 2nShSRMBAAAALwAAAAIWAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 2nShSRgBAAAALAAAAC4WAAAAABEAAAAAAAAAAgMC/AgAAABaAAAA/mQAAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=8 ### @2=90 ### SET ### @2=100 2nShSRcBAAAAMgAAAGAWAAAQABIAAAAAAAEABA/wKouOnkUSAAAIAAAAWgAAAGQAAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:58 ### @2=8 ### @3=90 ### @4=100 # at 5728 #090222 16:52:58 server id 1 end_log_pos 5805 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317978/*!*/; COMMIT /*!*/; # at 5805 #090222 16:52:59 server id 1 end_log_pos 5881 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317979/*!*/; BEGIN /*!*/; # at 5881 # at 5947 # at 5994 # at 6038 #090222 16:52:59 server id 1 end_log_pos 5947 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:59 server id 1 end_log_pos 5994 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:59 server id 1 end_log_pos 6038 Update_rows: table id 17 #090222 16:52:59 server id 1 end_log_pos 6088 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 23ShSRMBAAAAQgAAADsXAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 23ShSRMBAAAALwAAAGoXAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 23ShSRgBAAAALAAAAJYXAAAAABEAAAAAAAAAAgMC/AQAAABkAAAA/loAAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=4 ### @2=100 ### SET ### @2=90 23ShSRcBAAAAMgAAAMgXAAAQABIAAAAAAAEABA/wK4uOnkUSAAAEAAAAZAAAAFoAAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:59 ### @2=4 ### @3=100 ### @4=90 # at 6088 #090222 16:52:59 server id 1 end_log_pos 6165 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317979/*!*/; COMMIT /*!*/; # at 6165 #090222 16:52:59 server id 1 end_log_pos 6241 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317979/*!*/; BEGIN /*!*/; # at 6241 # at 6307 # at 6354 # at 6398 #090222 16:52:59 server id 1 end_log_pos 6307 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:52:59 server id 1 end_log_pos 6354 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:52:59 server id 1 end_log_pos 6398 Update_rows: table id 17 #090222 16:52:59 server id 1 end_log_pos 6448 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 23ShSRMBAAAAQgAAAKMYAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 23ShSRMBAAAALwAAANIYAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 23ShSRgBAAAALAAAAP4YAAAAABEAAAAAAAAAAgMC/AgAAABkAAAA/m4AAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=8 ### @2=100 ### SET ### @2=110 23ShSRcBAAAAMgAAADAZAAAQABIAAAAAAAEABA/wK4uOnkUSAAAIAAAAZAAAAG4AAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:52:59 ### @2=8 ### @3=100 ### @4=110 # at 6448 #090222 16:52:59 server id 1 end_log_pos 6525 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317979/*!*/; COMMIT /*!*/; # at 6525 #090222 16:53:00 server id 1 end_log_pos 6601 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317980/*!*/; BEGIN /*!*/; # at 6601 # at 6667 # at 6714 # at 6758 #090222 16:53:00 server id 1 end_log_pos 6667 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:53:00 server id 1 end_log_pos 6714 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:53:00 server id 1 end_log_pos 6758 Update_rows: table id 17 #090222 16:53:00 server id 1 end_log_pos 6808 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 3HShSRMBAAAAQgAAAAsaAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 3HShSRMBAAAALwAAADoaAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 3HShSRgBAAAALAAAAGYaAAAAABEAAAAAAAAAAgMC/AcAAABQAAAA/kYAAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=7 ### @2=80 ### SET ### @2=70 3HShSRcBAAAAMgAAAJgaAAAQABIAAAAAAAEABA/wVIuOnkUSAAAHAAAAUAAAAEYAAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:53:00 ### @2=7 ### @3=80 ### @4=70 # at 6808 #090222 16:53:00 server id 1 end_log_pos 6885 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317980/*!*/; COMMIT /*!*/; # at 6885 #090222 16:53:00 server id 1 end_log_pos 6961 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317980/*!*/; BEGIN /*!*/; # at 6961 # at 7027 # at 7074 # at 7118 #090222 16:53:00 server id 1 end_log_pos 7027 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:53:00 server id 1 end_log_pos 7074 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:53:00 server id 1 end_log_pos 7118 Update_rows: table id 17 #090222 16:53:00 server id 1 end_log_pos 7168 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 3HShSRMBAAAAQgAAAHMbAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 3HShSRMBAAAALwAAAKIbAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 3HShSRgBAAAALAAAAM4bAAAAABEAAAAAAAAAAgMC/AEAAABuAAAA/ngAAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=1 ### @2=110 ### SET ### @2=120 3HShSRcBAAAAMgAAAAAcAAAQABIAAAAAAAEABA/wVIuOnkUSAAABAAAAbgAAAHgAAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:53:00 ### @2=1 ### @3=110 ### @4=120 # at 7168 #090222 16:53:00 server id 1 end_log_pos 7245 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317980/*!*/; COMMIT /*!*/; # at 7245 #090222 16:53:01 server id 1 end_log_pos 7321 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317981/*!*/; BEGIN /*!*/; # at 7321 # at 7387 # at 7434 # at 7478 #090222 16:53:01 server id 1 end_log_pos 7387 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:53:01 server id 1 end_log_pos 7434 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:53:01 server id 1 end_log_pos 7478 Update_rows: table id 17 #090222 16:53:01 server id 1 end_log_pos 7528 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 3XShSRMBAAAAQgAAANscAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 3XShSRMBAAAALwAAAAodAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 3XShSRgBAAAALAAAADYdAAAAABEAAAAAAAAAAgMC/AMAAAB4AAAA/m4AAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=3 ### @2=120 ### SET ### @2=110 3XShSRcBAAAAMgAAAGgdAAAQABIAAAAAAAEABA/wVYuOnkUSAAADAAAAeAAAAG4AAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:53:01 ### @2=3 ### @3=120 ### @4=110 # at 7528 #090222 16:53:01 server id 1 end_log_pos 7605 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317981/*!*/; COMMIT /*!*/; # at 7605 #090222 16:53:01 server id 1 end_log_pos 7681 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317981/*!*/; BEGIN /*!*/; # at 7681 # at 7747 # at 7794 # at 7838 #090222 16:53:01 server id 1 end_log_pos 7747 Table_map: `test`.`table10_innodb_int_autoinc` mapped to number 17 #090222 16:53:01 server id 1 end_log_pos 7794 Table_map: `omer`.`zzlog` mapped to number 18 #090222 16:53:01 server id 1 end_log_pos 7838 Update_rows: table id 17 #090222 16:53:01 server id 1 end_log_pos 7888 Write_rows: table id 18 flags: STMT_END_F BINLOG ' 3XShSRMBAAAAQgAAAEMeAAAAABEAAAAAAAAABHRlc3QAGnRhYmxlMTBfaW5ub2RiX2ludF9hdXRv aW5jAAIDAwAC 3XShSRMBAAAALwAAAHIeAAAAABIAAAAAAAAABG9tZXIABXp6bG9nAAQMAwMDAA8= 3XShSRgBAAAALAAAAJ4eAAAAABEAAAAAAAAAAgMC/AQAAABaAAAA/mQAAAA= ### UPDATE test.table10_innodb_int_autoinc ### WHERE ### @1=4 ### @2=90 ### SET ### @2=100 3XShSRcBAAAAMgAAANAeAAAQABIAAAAAAAEABA/wVYuOnkUSAAAEAAAAWgAAAGQAAAA= '/*!*/; ### INSERT INTO omer.zzlog ### SET ### @1=2009-02-22 18:53:01 ### @2=4 ### @3=90 ### @4=100 # at 7888 #090222 16:53:01 server id 1 end_log_pos 7965 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317981/*!*/; COMMIT /*!*/; # at 7965 #090222 16:53:02 server id 1 end_log_pos 8046 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317982/*!*/; drop database omer /*!*/; # at 8046 #090222 16:53:02 server id 1 end_log_pos 8151 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1235317982/*!*/; drop table test.table10_innodb_int_autoinc /*!*/; DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;