Debian Codegraph @

mysql-test/suite/rpl/t/applier_compression.test

raw
1 #
2 # WL#3549: binlog compression
3 #
4 # This test file contains tests for the applier.
5 # It tests the following scenarios:
6 #
7 # - Scenario 1: AC, IC
8 # - Scenario 2: AC, IR
9 # - Scenario 3: AR, IC
10 # - Scenario 4: AR, IR
11 #
12 # Legend:
13 # - AC - Applier Compresses (applier thread running with binlog_transaction_compression = ON)
14 # - AR - Applier Regular (applier thread running with binlog_transaction_compression = OFF)
15 # - IC - Incoming Compressed (incoming compressed transactions from the master)
16 # - IR - Incoming Regular (incoming regular transactions)
17 #
18 --source include/master-slave.inc
19 --source include/have_binlog_format_row.inc
20
21 # setup
22
23 --source include/rpl_connection_master.inc
24 --let $saved_global_binlog_transaction_compression_master = `SELECT @@GLOBAL.binlog_transaction_compression`
25 --let $saved_session_binlog_transaction_compression_master = `SELECT @@SESSION.binlog_transaction_compression`
26
27 --source include/rpl_connection_slave.inc
28 --let $saved_global_binlog_transaction_compression_slave = `SELECT @@GLOBAL.binlog_transaction_compression`
29 --let $saved_session_binlog_transaction_compression_slave = `SELECT @@SESSION.binlog_transaction_compression`
30
31 --source include/rpl_connection_master.inc
32 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
33
34 --source include/rpl_connection_slave.inc
35 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
36
37 --source include/rpl_connection_master.inc
38 --source include/rpl_reset.inc
39
40 --disable_query_log
41 --disable_result_log
42
43 # global variables
44 --let $show_rpl_debug_info = 0
45 --let $trx_size_bytes = 1000000
46 --let $ntrx_per_iteration = 3
47 --let $pfs_table = performance_schema.binary_log_transaction_compression_stats
48
49 # the four scenarios
50 --let $i=1
51 while($i<5)
52 {
53 if ($i == 1)
54 {
55 --echo # SCENARIO 1: AC, IC
56 #
57 # Scenario 1: AC, IC
58 #
59 # Expectation is that the applier applies compressed transactions
60 # and compresses those transactions that writes to its binary log
61 #
62 --source include/rpl_connection_slave.inc
63 --source include/stop_slave.inc
64 SET GLOBAL binlog_transaction_compression = ON;
65 --source include/start_slave.inc
66
67 --source include/rpl_connection_master.inc
68 SET SESSION binlog_transaction_compression = ON;
69
70 --let $comparison_master_cbytes_vs_trx_size_bytes = <
71 --let $comparison_master_ubytes_vs_trx_size_bytes = >
72 --let $comparison_master_cbytes_vs_ubytes = <
73
74 --let $comparison_slave_relaylog_cbytes_vs_trx_size_bytes = $comparison_master_cbytes_vs_trx_size_bytes
75 --let $comparison_slave_relaylog_ubytes_vs_trx_size_bytes = $comparison_master_ubytes_vs_trx_size_bytes
76 --let $comparison_slave_relaylog_cbytes_vs_ubytes = $comparison_master_cbytes_vs_ubytes
77
78 --let $comparison_slave_binlog_cbytes_vs_trx_size_bytes = <
79 --let $comparison_slave_binlog_ubytes_vs_trx_size_bytes = >
80 --let $comparison_slave_binlog_cbytes_vs_ubytes = <
81 }
82
83 if ($i == 2)
84 {
85 --echo # SCENARIO 2: AC, IR
86
87 #
88 # Scenario 2: AC, IR
89 #
90 # Expectation is that the applier applies regular transactions
91 # and compresses those transactions that writes to its binary log
92 #
93
94 --source include/rpl_connection_slave.inc
95 --source include/stop_slave.inc
96 SET GLOBAL binlog_transaction_compression = ON;
97 --source include/start_slave.inc
98
99 --source include/rpl_connection_master.inc
100 SET SESSION binlog_transaction_compression = OFF;
101
102 --let $comparison_master_cbytes_vs_trx_size_bytes = >
103 --let $comparison_master_ubytes_vs_trx_size_bytes = >
104 --let $comparison_master_cbytes_vs_ubytes = =
105
106 --let $comparison_slave_relaylog_cbytes_vs_trx_size_bytes = $comparison_master_cbytes_vs_trx_size_bytes
107 --let $comparison_slave_relaylog_ubytes_vs_trx_size_bytes = $comparison_master_ubytes_vs_trx_size_bytes
108 --let $comparison_slave_relaylog_cbytes_vs_ubytes = $comparison_master_cbytes_vs_ubytes
109
110 --let $comparison_slave_binlog_cbytes_vs_trx_size_bytes = <
111 --let $comparison_slave_binlog_ubytes_vs_trx_size_bytes = >
112 --let $comparison_slave_binlog_cbytes_vs_ubytes = <
113 }
114
115 if ($i == 3)
116 {
117 --echo # SCENARIO 3: AR, IC
118
119 #
120 # Scenario 3: AR, IC
121 #
122 # Expectation is that the applier applies compressed transactions
123 # and does not compress those transactions that writes to its binary log
124 #
125
126 --source include/rpl_connection_slave.inc
127 --source include/stop_slave.inc
128 SET GLOBAL binlog_transaction_compression = OFF;
129 --source include/start_slave.inc
130
131 --source include/rpl_connection_master.inc
132 SET SESSION binlog_transaction_compression = ON;
133
134 --let $comparison_master_cbytes_vs_trx_size_bytes = <
135 --let $comparison_master_ubytes_vs_trx_size_bytes = >
136 --let $comparison_master_cbytes_vs_ubytes = <
137
138 --let $comparison_slave_relaylog_cbytes_vs_trx_size_bytes = $comparison_master_cbytes_vs_trx_size_bytes
139 --let $comparison_slave_relaylog_ubytes_vs_trx_size_bytes = $comparison_master_ubytes_vs_trx_size_bytes
140 --let $comparison_slave_relaylog_cbytes_vs_ubytes = $comparison_master_cbytes_vs_ubytes
141
142 --let $comparison_slave_binlog_cbytes_vs_trx_size_bytes = >
143 --let $comparison_slave_binlog_ubytes_vs_trx_size_bytes = >
144 --let $comparison_slave_binlog_cbytes_vs_ubytes = =
145 }
146
147 if ($i == 4)
148 {
149 --echo # SCENARIO 4: AR, IR
150
151 #
152 # Scenario 4: AR, IR
153 #
154 # Expectation is that the applier applies regular transactions
155 # and does not compress those transactions that writes to its binary log
156 #
157 --source include/rpl_connection_master.inc
158 SET SESSION binlog_transaction_compression = OFF;
159
160 --source include/rpl_connection_slave.inc
161 --source include/stop_slave.inc
162 SET GLOBAL binlog_transaction_compression = OFF;
163 --source include/start_slave.inc
164
165 --let $comparison_master_cbytes_vs_trx_size_bytes = >
166 --let $comparison_master_ubytes_vs_trx_size_bytes = >
167 --let $comparison_master_cbytes_vs_ubytes = =
168
169 --let $comparison_slave_relaylog_cbytes_vs_trx_size_bytes = $comparison_master_cbytes_vs_trx_size_bytes
170 --let $comparison_slave_relaylog_ubytes_vs_trx_size_bytes = $comparison_master_ubytes_vs_trx_size_bytes
171 --let $comparison_slave_relaylog_cbytes_vs_ubytes = $comparison_master_cbytes_vs_ubytes
172
173 --let $comparison_slave_binlog_cbytes_vs_trx_size_bytes = >
174 --let $comparison_slave_binlog_ubytes_vs_trx_size_bytes = >
175 --let $comparison_slave_binlog_cbytes_vs_ubytes = =
176 }
177
178 # DDL: create table
179 --source include/rpl_connection_master.inc
180 CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY, c2 LONGTEXT);
181 --source include/sync_slave_sql_with_master.inc
182
183 # master: INSERT values
184 --source include/rpl_connection_master.inc
185 --eval INSERT INTO t1 VALUES (2, REPEAT('b', $trx_size_bytes));
186 --source include/sync_slave_sql_with_master.inc
187
188 # DDL: drop table
189 --source include/rpl_connection_master.inc
190 DROP TABLE t1;
191 --source include/sync_slave_sql_with_master.inc
192
193 # get the stats
194 --source include/rpl_connection_master.inc
195 --let $master_cbytes = `SELECT compressed_bytes_counter FROM $pfs_table WHERE log_type = 'BINARY'`
196 --let $master_ubytes = `SELECT uncompressed_bytes_counter FROM $pfs_table WHERE log_type = 'BINARY'`
197 --let $master_ctrxs = `SELECT SUM(transaction_counter) FROM $pfs_table WHERE log_type = 'BINARY'`
198
199 --source include/rpl_connection_slave.inc
200 --let $slave_relaylog_cbytes = `SELECT compressed_bytes_counter FROM $pfs_table WHERE log_type = 'RELAY'`
201 --let $slave_relaylog_ubytes = `SELECT uncompressed_bytes_counter FROM $pfs_table WHERE log_type = 'RELAY'`
202 --let $slave_relaylog_ctrxs = `SELECT SUM(transaction_counter) FROM $pfs_table WHERE log_type = 'RELAY'`
203
204 --let $slave_binlog_cbytes = `SELECT compressed_bytes_counter FROM $pfs_table WHERE log_type = 'BINARY'`
205 --let $slave_binlog_ubytes = `SELECT uncompressed_bytes_counter FROM $pfs_table WHERE log_type = 'BINARY'`
206 --let $slave_binlog_ctrxs = `SELECT SUM(transaction_counter) FROM $pfs_table WHERE log_type = 'BINARY'`
207
208 #
209 # Assertions
210 #
211
212 # MASTER, SLAVE_RELAYLOG, SLAVE_BINARY
213 --let $j = 1
214 while($j<4)
215 {
216 if ($j == 1)
217 {
218 --let $TAG = MASTER_BINLOG
219
220 --let $cbytes = $master_cbytes
221 --let $ubytes = $master_ubytes
222 --let $ctrxs = $master_ctrxs
223
224 --let $rel1 = $comparison_master_cbytes_vs_trx_size_bytes
225 --let $rel2 = $comparison_master_ubytes_vs_trx_size_bytes
226 --let $rel3 = $comparison_master_cbytes_vs_ubytes
227 }
228
229 if ($j == 2)
230 {
231 --let $TAG = SLAVE_RELAYLOG
232
233 --let $cbytes = $slave_relaylog_cbytes
234 --let $ubytes = $slave_relaylog_ubytes
235 --let $ctrxs = $slave_relaylog_ctrxs
236
237 --let $rel1 = $comparison_slave_relaylog_cbytes_vs_trx_size_bytes
238 --let $rel2 = $comparison_slave_relaylog_ubytes_vs_trx_size_bytes
239 --let $rel3 = $comparison_slave_relaylog_cbytes_vs_ubytes
240 }
241
242 if ($j == 3)
243 {
244 --let $TAG = SLAVE_BINLOG
245
246 --let $cbytes = $slave_binlog_cbytes
247 --let $ubytes = $slave_binlog_ubytes
248 --let $ctrxs = $slave_binlog_ctrxs
249
250 --let $rel1 = $comparison_slave_binlog_cbytes_vs_trx_size_bytes
251 --let $rel2 = $comparison_slave_binlog_ubytes_vs_trx_size_bytes
252 --let $rel3 = $comparison_slave_binlog_cbytes_vs_ubytes
253 }
254
255 --let $assert_cond= $ctrxs = $ntrx_per_iteration
256 --let $assert_text= $TAG: The expected number of transactions was handled
257 --source include/assert.inc
258
259 --let $assert_cond= $cbytes $rel1 $trx_size_bytes
260 --let $assert_text= $TAG: compressed bytes $rel1 DML size
261 --source include/assert.inc
262
263 --let $assert_cond= $ubytes $rel2 $trx_size_bytes
264 --let $assert_text= $TAG: uncompressed bytes $rel2 DML size
265 --source include/assert.inc
266
267 --let $assert_cond= $cbytes $rel3 $ubytes
268 --let $assert_text= $TAG: compressed bytes $rel3 uncompressed bytes
269 --source include/assert.inc
270
271 --inc $j
272 }
273
274 --source include/rpl_connection_master.inc
275 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
276
277 --source include/rpl_connection_slave.inc
278 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
279
280 --source include/rpl_connection_master.inc
281
282 # clean up
283 --source include/rpl_reset.inc
284 --inc $i
285 }
286
287 --enable_query_log
288 --enable_result_log
289
290 #
291 # Clean up
292 #
293 --source include/rpl_connection_master.inc
294 --replace_result $saved_session_binlog_transaction_compression_master SAVED
295 --eval SET @@SESSION.binlog_transaction_compression = $saved_session_binlog_transaction_compression_master
296
297 --replace_result $saved_global_binlog_transaction_compression_master SAVED
298 --eval SET @@GLOBAL.binlog_transaction_compression = $saved_global_binlog_transaction_compression_master
299
300 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
301
302 --source include/rpl_connection_slave.inc
303
304 --replace_result $saved_session_binlog_transaction_compression_slave SAVED
305 --eval SET @@SESSION.binlog_transaction_compression = $saved_session_binlog_transaction_compression_slave
306
307 --replace_result $saved_global_binlog_transaction_compression_slave SAVED
308 --eval SET @@GLOBAL.binlog_transaction_compression = $saved_global_binlog_transaction_compression_slave
309
310 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
311
312 --source include/rpl_reset.inc
313 --source include/rpl_end.inc