Debian Codegraph @

mysql-test/suite/rpl/r/rpl_binlog_sender_packet_shrink.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 include/stop_dump_threads.inc
7 CREATE TABLE t1 (a TEXT(1048576));
8 include/sync_slave_sql_with_master.inc
9 #
10 # 1. Generate a big event to make the packet to grow
11 #
12 INSERT 1M byte string
13 INSERT INTO t1 VALUES (REPEAT('a', 1048576));
14 include/sync_slave_sql_with_master.inc
15 include/assert.inc [The packet should have grown 64 times after a 1M big event]
16 #
17 # 2. Generate 100 events with some having more then 4097
18 # bytes to ensure that the packet will shrink
19 #
20 INSERT 20 x 8K string (x 5 events: GTID, BEGIN, TABLE_MAP, ROWS, XID)
21 INSERT INTO t1 VALUES (REPEAT('b', 8192));
22 INSERT INTO t1 VALUES (REPEAT('b', 8192));
23 INSERT INTO t1 VALUES (REPEAT('b', 8192));
24 INSERT INTO t1 VALUES (REPEAT('b', 8192));
25 INSERT INTO t1 VALUES (REPEAT('b', 8192));
26 INSERT INTO t1 VALUES (REPEAT('b', 8192));
27 INSERT INTO t1 VALUES (REPEAT('b', 8192));
28 INSERT INTO t1 VALUES (REPEAT('b', 8192));
29 INSERT INTO t1 VALUES (REPEAT('b', 8192));
30 INSERT INTO t1 VALUES (REPEAT('b', 8192));
31 INSERT INTO t1 VALUES (REPEAT('b', 8192));
32 INSERT INTO t1 VALUES (REPEAT('b', 8192));
33 INSERT INTO t1 VALUES (REPEAT('b', 8192));
34 INSERT INTO t1 VALUES (REPEAT('b', 8192));
35 INSERT INTO t1 VALUES (REPEAT('b', 8192));
36 INSERT INTO t1 VALUES (REPEAT('b', 8192));
37 INSERT INTO t1 VALUES (REPEAT('b', 8192));
38 INSERT INTO t1 VALUES (REPEAT('b', 8192));
39 INSERT INTO t1 VALUES (REPEAT('b', 8192));
40 INSERT INTO t1 VALUES (REPEAT('b', 8192));
41 include/sync_slave_sql_with_master.inc
42 include/assert.inc [The packet should be halved after 100 medium events]
43 #
44 # 3. Generate 700 events with some having less then 4096
45 # bytes to ensure that the packet will shrink to
46 # the minimum size.
47 #
48 INSERT 7 x 20 x 1K string (x 4 events: GTID, BEGIN, TABLE_MAP, ROWS, XID)
49 Iteration 1: INSERT 25 x 1K string (x 4 events: GTID, BEGIN, QUERY, XID)
50 INSERT INTO t1 VALUES (REPEAT('c', 1024));
51 INSERT INTO t1 VALUES (REPEAT('c', 1024));
52 INSERT INTO t1 VALUES (REPEAT('c', 1024));
53 INSERT INTO t1 VALUES (REPEAT('c', 1024));
54 INSERT INTO t1 VALUES (REPEAT('c', 1024));
55 INSERT INTO t1 VALUES (REPEAT('c', 1024));
56 INSERT INTO t1 VALUES (REPEAT('c', 1024));
57 INSERT INTO t1 VALUES (REPEAT('c', 1024));
58 INSERT INTO t1 VALUES (REPEAT('c', 1024));
59 INSERT INTO t1 VALUES (REPEAT('c', 1024));
60 INSERT INTO t1 VALUES (REPEAT('c', 1024));
61 INSERT INTO t1 VALUES (REPEAT('c', 1024));
62 INSERT INTO t1 VALUES (REPEAT('c', 1024));
63 INSERT INTO t1 VALUES (REPEAT('c', 1024));
64 INSERT INTO t1 VALUES (REPEAT('c', 1024));
65 INSERT INTO t1 VALUES (REPEAT('c', 1024));
66 INSERT INTO t1 VALUES (REPEAT('c', 1024));
67 INSERT INTO t1 VALUES (REPEAT('c', 1024));
68 INSERT INTO t1 VALUES (REPEAT('c', 1024));
69 INSERT INTO t1 VALUES (REPEAT('c', 1024));
70 include/sync_slave_sql_with_master.inc
71 include/assert.inc [Iteration 1: The packet should be halved after 100 small events]
72 Iteration 2: INSERT 25 x 1K string (x 4 events: GTID, BEGIN, QUERY, XID)
73 INSERT INTO t1 VALUES (REPEAT('c', 1024));
74 INSERT INTO t1 VALUES (REPEAT('c', 1024));
75 INSERT INTO t1 VALUES (REPEAT('c', 1024));
76 INSERT INTO t1 VALUES (REPEAT('c', 1024));
77 INSERT INTO t1 VALUES (REPEAT('c', 1024));
78 INSERT INTO t1 VALUES (REPEAT('c', 1024));
79 INSERT INTO t1 VALUES (REPEAT('c', 1024));
80 INSERT INTO t1 VALUES (REPEAT('c', 1024));
81 INSERT INTO t1 VALUES (REPEAT('c', 1024));
82 INSERT INTO t1 VALUES (REPEAT('c', 1024));
83 INSERT INTO t1 VALUES (REPEAT('c', 1024));
84 INSERT INTO t1 VALUES (REPEAT('c', 1024));
85 INSERT INTO t1 VALUES (REPEAT('c', 1024));
86 INSERT INTO t1 VALUES (REPEAT('c', 1024));
87 INSERT INTO t1 VALUES (REPEAT('c', 1024));
88 INSERT INTO t1 VALUES (REPEAT('c', 1024));
89 INSERT INTO t1 VALUES (REPEAT('c', 1024));
90 INSERT INTO t1 VALUES (REPEAT('c', 1024));
91 INSERT INTO t1 VALUES (REPEAT('c', 1024));
92 INSERT INTO t1 VALUES (REPEAT('c', 1024));
93 include/sync_slave_sql_with_master.inc
94 include/assert.inc [Iteration 2: The packet should be halved after 100 small events]
95 Iteration 3: INSERT 25 x 1K string (x 4 events: GTID, BEGIN, QUERY, XID)
96 INSERT INTO t1 VALUES (REPEAT('c', 1024));
97 INSERT INTO t1 VALUES (REPEAT('c', 1024));
98 INSERT INTO t1 VALUES (REPEAT('c', 1024));
99 INSERT INTO t1 VALUES (REPEAT('c', 1024));
100 INSERT INTO t1 VALUES (REPEAT('c', 1024));
101 INSERT INTO t1 VALUES (REPEAT('c', 1024));
102 INSERT INTO t1 VALUES (REPEAT('c', 1024));
103 INSERT INTO t1 VALUES (REPEAT('c', 1024));
104 INSERT INTO t1 VALUES (REPEAT('c', 1024));
105 INSERT INTO t1 VALUES (REPEAT('c', 1024));
106 INSERT INTO t1 VALUES (REPEAT('c', 1024));
107 INSERT INTO t1 VALUES (REPEAT('c', 1024));
108 INSERT INTO t1 VALUES (REPEAT('c', 1024));
109 INSERT INTO t1 VALUES (REPEAT('c', 1024));
110 INSERT INTO t1 VALUES (REPEAT('c', 1024));
111 INSERT INTO t1 VALUES (REPEAT('c', 1024));
112 INSERT INTO t1 VALUES (REPEAT('c', 1024));
113 INSERT INTO t1 VALUES (REPEAT('c', 1024));
114 INSERT INTO t1 VALUES (REPEAT('c', 1024));
115 INSERT INTO t1 VALUES (REPEAT('c', 1024));
116 include/sync_slave_sql_with_master.inc
117 include/assert.inc [Iteration 3: The packet should be halved after 100 small events]
118 Iteration 4: INSERT 25 x 1K string (x 4 events: GTID, BEGIN, QUERY, XID)
119 INSERT INTO t1 VALUES (REPEAT('c', 1024));
120 INSERT INTO t1 VALUES (REPEAT('c', 1024));
121 INSERT INTO t1 VALUES (REPEAT('c', 1024));
122 INSERT INTO t1 VALUES (REPEAT('c', 1024));
123 INSERT INTO t1 VALUES (REPEAT('c', 1024));
124 INSERT INTO t1 VALUES (REPEAT('c', 1024));
125 INSERT INTO t1 VALUES (REPEAT('c', 1024));
126 INSERT INTO t1 VALUES (REPEAT('c', 1024));
127 INSERT INTO t1 VALUES (REPEAT('c', 1024));
128 INSERT INTO t1 VALUES (REPEAT('c', 1024));
129 INSERT INTO t1 VALUES (REPEAT('c', 1024));
130 INSERT INTO t1 VALUES (REPEAT('c', 1024));
131 INSERT INTO t1 VALUES (REPEAT('c', 1024));
132 INSERT INTO t1 VALUES (REPEAT('c', 1024));
133 INSERT INTO t1 VALUES (REPEAT('c', 1024));
134 INSERT INTO t1 VALUES (REPEAT('c', 1024));
135 INSERT INTO t1 VALUES (REPEAT('c', 1024));
136 INSERT INTO t1 VALUES (REPEAT('c', 1024));
137 INSERT INTO t1 VALUES (REPEAT('c', 1024));
138 INSERT INTO t1 VALUES (REPEAT('c', 1024));
139 include/sync_slave_sql_with_master.inc
140 include/assert.inc [Iteration 4: The packet should be halved after 100 small events]
141 Iteration 5: INSERT 25 x 1K string (x 4 events: GTID, BEGIN, QUERY, XID)
142 INSERT INTO t1 VALUES (REPEAT('c', 1024));
143 INSERT INTO t1 VALUES (REPEAT('c', 1024));
144 INSERT INTO t1 VALUES (REPEAT('c', 1024));
145 INSERT INTO t1 VALUES (REPEAT('c', 1024));
146 INSERT INTO t1 VALUES (REPEAT('c', 1024));
147 INSERT INTO t1 VALUES (REPEAT('c', 1024));
148 INSERT INTO t1 VALUES (REPEAT('c', 1024));
149 INSERT INTO t1 VALUES (REPEAT('c', 1024));
150 INSERT INTO t1 VALUES (REPEAT('c', 1024));
151 INSERT INTO t1 VALUES (REPEAT('c', 1024));
152 INSERT INTO t1 VALUES (REPEAT('c', 1024));
153 INSERT INTO t1 VALUES (REPEAT('c', 1024));
154 INSERT INTO t1 VALUES (REPEAT('c', 1024));
155 INSERT INTO t1 VALUES (REPEAT('c', 1024));
156 INSERT INTO t1 VALUES (REPEAT('c', 1024));
157 INSERT INTO t1 VALUES (REPEAT('c', 1024));
158 INSERT INTO t1 VALUES (REPEAT('c', 1024));
159 INSERT INTO t1 VALUES (REPEAT('c', 1024));
160 INSERT INTO t1 VALUES (REPEAT('c', 1024));
161 INSERT INTO t1 VALUES (REPEAT('c', 1024));
162 include/sync_slave_sql_with_master.inc
163 include/assert.inc [Iteration 5: The packet should be halved after 100 small events]
164 Iteration 6: INSERT 25 x 1K string (x 4 events: GTID, BEGIN, QUERY, XID)
165 INSERT INTO t1 VALUES (REPEAT('c', 1024));
166 INSERT INTO t1 VALUES (REPEAT('c', 1024));
167 INSERT INTO t1 VALUES (REPEAT('c', 1024));
168 INSERT INTO t1 VALUES (REPEAT('c', 1024));
169 INSERT INTO t1 VALUES (REPEAT('c', 1024));
170 INSERT INTO t1 VALUES (REPEAT('c', 1024));
171 INSERT INTO t1 VALUES (REPEAT('c', 1024));
172 INSERT INTO t1 VALUES (REPEAT('c', 1024));
173 INSERT INTO t1 VALUES (REPEAT('c', 1024));
174 INSERT INTO t1 VALUES (REPEAT('c', 1024));
175 INSERT INTO t1 VALUES (REPEAT('c', 1024));
176 INSERT INTO t1 VALUES (REPEAT('c', 1024));
177 INSERT INTO t1 VALUES (REPEAT('c', 1024));
178 INSERT INTO t1 VALUES (REPEAT('c', 1024));
179 INSERT INTO t1 VALUES (REPEAT('c', 1024));
180 INSERT INTO t1 VALUES (REPEAT('c', 1024));
181 INSERT INTO t1 VALUES (REPEAT('c', 1024));
182 INSERT INTO t1 VALUES (REPEAT('c', 1024));
183 INSERT INTO t1 VALUES (REPEAT('c', 1024));
184 INSERT INTO t1 VALUES (REPEAT('c', 1024));
185 include/sync_slave_sql_with_master.inc
186 include/assert.inc [Iteration 6: The packet should be halved after 100 small events]
187 Iteration 7: INSERT 25 x 1K string (x 4 events: GTID, BEGIN, QUERY, XID)
188 INSERT INTO t1 VALUES (REPEAT('c', 1024));
189 INSERT INTO t1 VALUES (REPEAT('c', 1024));
190 INSERT INTO t1 VALUES (REPEAT('c', 1024));
191 INSERT INTO t1 VALUES (REPEAT('c', 1024));
192 INSERT INTO t1 VALUES (REPEAT('c', 1024));
193 INSERT INTO t1 VALUES (REPEAT('c', 1024));
194 INSERT INTO t1 VALUES (REPEAT('c', 1024));
195 INSERT INTO t1 VALUES (REPEAT('c', 1024));
196 INSERT INTO t1 VALUES (REPEAT('c', 1024));
197 INSERT INTO t1 VALUES (REPEAT('c', 1024));
198 INSERT INTO t1 VALUES (REPEAT('c', 1024));
199 INSERT INTO t1 VALUES (REPEAT('c', 1024));
200 INSERT INTO t1 VALUES (REPEAT('c', 1024));
201 INSERT INTO t1 VALUES (REPEAT('c', 1024));
202 INSERT INTO t1 VALUES (REPEAT('c', 1024));
203 INSERT INTO t1 VALUES (REPEAT('c', 1024));
204 INSERT INTO t1 VALUES (REPEAT('c', 1024));
205 INSERT INTO t1 VALUES (REPEAT('c', 1024));
206 INSERT INTO t1 VALUES (REPEAT('c', 1024));
207 INSERT INTO t1 VALUES (REPEAT('c', 1024));
208 include/sync_slave_sql_with_master.inc
209 include/assert.inc [Iteration 7: The packet should be halved after 100 small events]
210 DROP TABLE t1;
211 include/rpl_end.inc