1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
# The proper term is pseudo_replica_mode, but we use this compatibility alias
# to make the statement usable on server versions 8.0.24 and older.
/*!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 Source ID Size Source 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 Source ID Size Source 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 utf8mb3 *//*!*/;
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 Source ID Size Source 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 Source ID Size Source 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 Source ID Size Source 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 Source ID Size Source 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 Source ID Size Source 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 Source ID Size Source 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 Source ID Size Source 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*/;
|
