You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
122 lines
6.5 KiB
122 lines
6.5 KiB
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
|
|
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
|
|
DELIMITER /*!*/;
|
|
# at 4
|
|
#111118 13:10:33 server id 1 end_log_pos 114
|
|
# Position Timestamp Type Master ID Size Master Pos Flags
|
|
# 00000004 19 2f c6 4e 0f 01 00 00 00 6e 00 00 00 72 00 00 00 00 00
|
|
# 00000017 04 00 35 2e 36 2e 34 2d 6d 37 2d 64 65 62 75 67 |..5.6.4.m7.debug|
|
|
# 00000027 2d 6c 6f 67 00 00 00 00 00 00 00 00 00 00 00 00 |.log............|
|
|
# 00000037 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
|
|
# 00000047 00 00 00 00 19 2f c6 4e 13 38 0d 00 08 00 12 00 |.......N.8......|
|
|
# 00000057 04 04 04 04 12 00 00 56 00 04 1a 08 00 00 00 08 |.......V........|
|
|
# 00000067 08 08 02 00 00 00 00 ba 38 4d f8 |........8M.|
|
|
# Start: binlog v 4, server v 5.6.4-m7-debug-log created 111118 13:10:33 at startup
|
|
ROLLBACK/*!*/;
|
|
BINLOG '
|
|
GS/GTg8BAAAAbgAAAHIAAAAAAAQANS42LjQtbTctZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA
|
|
AAAAAAAAAAAAAAAAAAAZL8ZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAALo4Tfg=
|
|
'/*!*/;
|
|
# at 114
|
|
#111118 13:11:28 server id 1 end_log_pos 245
|
|
# Position Timestamp Type Master ID Size Master Pos Flags
|
|
# 00000072 50 2f c6 4e 02 01 00 00 00 83 00 00 00 f5 00 00 00 00 00
|
|
# 00000085 01 00 00 00 00 00 00 00 04 00 00 21 00 00 00 00 |................|
|
|
# 00000095 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std|
|
|
# 000000a5 04 21 00 21 00 08 00 0c 01 74 65 73 74 00 74 65 |.........test.te|
|
|
# 000000b5 73 74 00 44 52 4f 50 20 54 41 42 4c 45 20 49 46 |st.DROP.TABLE.IF|
|
|
# 000000c5 20 45 58 49 53 54 53 20 60 74 31 30 31 32 33 34 |.EXISTS..t101234|
|
|
# 000000d5 35 36 37 38 39 60 20 2f 2a 20 67 65 6e 65 72 61 |56789.....genera|
|
|
# 000000e5 74 65 64 20 62 79 20 73 65 72 76 65 72 20 2a 2f |ted.by.server...|
|
|
# Query thread_id=1 exec_time=0 error_code=0
|
|
use `test`/*!*/;
|
|
SET TIMESTAMP=1321611088/*!*/;
|
|
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 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/*!*/;
|
|
DROP TABLE IF EXISTS `t10123456789` /* generated by server */
|
|
/*!*/;
|
|
# at 245
|
|
#111118 13:11:48 server id 1 end_log_pos 347
|
|
# Position Timestamp Type Master ID Size Master Pos Flags
|
|
# 000000f5 64 2f c6 4e 02 01 00 00 00 66 00 00 00 5b 01 00 00 00 00
|
|
# 00000108 01 00 00 00 00 00 00 00 04 00 00 21 00 00 00 00 |................|
|
|
# 00000118 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std|
|
|
# 00000128 04 21 00 21 00 08 00 0c 01 74 65 73 74 00 74 65 |.........test.te|
|
|
# 00000138 73 74 00 63 72 65 61 74 65 20 74 61 62 6c 65 20 |st.create.table.|
|
|
# 00000148 74 31 30 31 32 33 34 35 36 37 38 39 28 69 20 69 |t10123456789.i.i|
|
|
# 00000158 6e 74 29 |nt.|
|
|
# Query thread_id=1 exec_time=0 error_code=0
|
|
SET TIMESTAMP=1321611108/*!*/;
|
|
create table t10123456789(i int)
|
|
/*!*/;
|
|
# at 347
|
|
#111118 13:12:21 server id 1 end_log_pos 422
|
|
# Position Timestamp Type Master ID Size Master Pos Flags
|
|
# 0000015b 85 2f c6 4e 02 01 00 00 00 4b 00 00 00 a6 01 00 00 08 00
|
|
# 0000016e 01 00 00 00 00 00 00 00 04 00 00 21 00 00 00 00 |................|
|
|
# 0000017e 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std|
|
|
# 0000018e 04 21 00 21 00 08 00 0c 01 74 65 73 74 00 74 65 |.........test.te|
|
|
# 0000019e 73 74 00 42 45 47 49 4e |st.BEGIN|
|
|
# Query thread_id=1 exec_time=0 error_code=0
|
|
SET TIMESTAMP=1321611141/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
# at 422
|
|
# at 447
|
|
#111118 13:12:21 server id 1 end_log_pos 447
|
|
# Position Timestamp Type Master ID Size Master Pos Flags
|
|
# 000001a6 85 2f c6 4e 0e 01 00 00 00 19 00 00 00 bf 01 00 00 00 00
|
|
# 000001b9 01 00 00 00 32 01 |....2.|
|
|
# User_var
|
|
SET @`2`:=NULL/*!*/;
|
|
#111118 13:12:21 server id 1 end_log_pos 552
|
|
# Position Timestamp Type Master ID Size Master Pos Flags
|
|
# 000001bf 85 2f c6 4e 02 01 00 00 00 69 00 00 00 28 02 00 00 00 00
|
|
# 000001d2 01 00 00 00 00 00 00 00 04 00 00 21 00 00 00 00 |................|
|
|
# 000001e2 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std|
|
|
# 000001f2 04 21 00 21 00 08 00 0c 01 74 65 73 74 00 74 65 |.........test.te|
|
|
# 00000202 73 74 00 69 6e 73 65 72 74 20 69 6e 74 6f 20 74 |st.insert.into.t|
|
|
# 00000212 31 30 31 32 33 34 35 36 37 38 39 20 76 61 6c 75 |10123456789.valu|
|
|
# 00000222 65 73 28 40 32 29 |es..2.|
|
|
# Query thread_id=1 exec_time=0 error_code=0
|
|
SET TIMESTAMP=1321611141/*!*/;
|
|
insert into t10123456789 values(@2)
|
|
/*!*/;
|
|
# at 552
|
|
#111118 13:12:21 server id 1 end_log_pos 579
|
|
# Position Timestamp Type Master ID Size Master Pos Flags
|
|
# 00000228 85 2f c6 4e 10 01 00 00 00 1b 00 00 00 43 02 00 00 00 00
|
|
# 0000023b 0a 00 00 00 00 00 00 00 |........|
|
|
# Xid = <number>
|
|
COMMIT/*!*/;
|
|
# at 579
|
|
#111118 13:12:33 server id 1 end_log_pos 710
|
|
# Position Timestamp Type Master ID Size Master Pos Flags
|
|
# 00000243 91 2f c6 4e 02 01 00 00 00 83 00 00 00 c6 02 00 00 00 00
|
|
# 00000256 01 00 00 00 00 00 00 00 04 00 00 21 00 00 00 00 |................|
|
|
# 00000266 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std|
|
|
# 00000276 04 21 00 21 00 08 00 0c 01 74 65 73 74 00 74 65 |.........test.te|
|
|
# 00000286 73 74 00 44 52 4f 50 20 54 41 42 4c 45 20 49 46 |st.DROP.TABLE.IF|
|
|
# 00000296 20 45 58 49 53 54 53 20 60 74 31 30 31 32 33 34 |.EXISTS..t101234|
|
|
# 000002a6 35 36 37 38 39 60 20 2f 2a 20 67 65 6e 65 72 61 |56789.....genera|
|
|
# 000002b6 74 65 64 20 62 79 20 73 65 72 76 65 72 20 2a 2f |ted.by.server...|
|
|
# Query thread_id=1 exec_time=0 error_code=0
|
|
SET TIMESTAMP=1321611153/*!*/;
|
|
DROP TABLE IF EXISTS `t10123456789` /* generated by server */
|
|
/*!*/;
|
|
# at 710
|
|
#111118 13:12:41 server id 1 end_log_pos 729
|
|
# Position Timestamp Type Master ID Size Master Pos Flags
|
|
# 000002c6 99 2f c6 4e 03 01 00 00 00 13 00 00 00 d9 02 00 00 00 00
|
|
# Stop
|
|
SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/;
|
|
DELIMITER ;
|
|
# End of log file
|
|
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
|
|
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
|
|
|