Debian Codegraph @

mysql-test/suite/ndb_binlog/r/ndb_binlog_compression.result

raw
1 ################################################
2 Validate binary log transaction compression
3 option values and ranges
4 ################################################
5 set @@SESSION.ndb_log_transaction_compression = ON;
6 ERROR HY000: Variable 'ndb_log_transaction_compression' is a GLOBAL variable and should be set with SET GLOBAL
7 set @@GLOBAL.ndb_log_transaction_compression = ON;
8 set @@SESSION.ndb_log_transaction_compression_level_zstd = 1;
9 ERROR HY000: Variable 'ndb_log_transaction_compression_level_zstd' is a GLOBAL variable and should be set with SET GLOBAL
10 set @@GLOBAL.ndb_log_transaction_compression_level_zstd = 0;
11 Warnings:
12 Warning 1292 Truncated incorrect ndb_log_transaction_compression_level_zstd value: '0'
13 Truncated to 1
14 show variables like 'ndb_log_transaction_compression_level_zstd';
15 Variable_name Value
16 ndb_log_transaction_compression_level_zstd 1
17 set @@GLOBAL.ndb_log_transaction_compression_level_zstd = 23;
18 Warnings:
19 Warning 1292 Truncated incorrect ndb_log_transaction_compression_level_zstd value: '23'
20 Truncated to 22
21 show variables like 'ndb_log_transaction_compression_level_zstd';
22 Variable_name Value
23 ndb_log_transaction_compression_level_zstd 22
24 set @@GLOBAL.ndb_log_transaction_compression = DEFAULT;
25 set @@GLOBAL.ndb_log_transaction_compression_level_zstd = DEFAULT;
26 ################################################
27 Case 1: Observe binlog compression in ndbcluster
28 when ndb_log_transaction_compression = default
29 ################################################
30 show variables like 'ndb_log_bin';
31 Variable_name Value
32 ndb_log_bin ON
33 show variables like 'ndb_log_transaction_compression';
34 Variable_name Value
35 ndb_log_transaction_compression OFF
36 show variables like 'ndb_log_transaction_compression_level_zstd';
37 Variable_name Value
38 ndb_log_transaction_compression_level_zstd 3
39 create table t1 (a int) engine=ndb;
40 insert into t1 values (1);
41 insert into t1 select a+1 from t1;
42 insert into t1 select a+2 from t1;
43 include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression (BINARY, ZSTD) = 0]
44 ################################################
45 Case 2: Observe binlog compression in ndbcluster
46 when ndb_log_transaction_compression = ON
47 ################################################
48 set global ndb_log_transaction_compression = ON;
49 show global variables like 'ndb_log_transaction_compression';
50 Variable_name Value
51 ndb_log_transaction_compression ON
52 insert into t1 select a+4 from t1;
53 include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression (BINARY, ZSTD) = 1]
54 ################################################
55 Case 3: Observe binlog compression in ndbcluster
56 when ndb_log_transaction_compression = OFF
57 ################################################
58 set global ndb_log_transaction_compression = OFF;
59 show global variables like 'ndb_log_transaction_compression';
60 Variable_name Value
61 ndb_log_transaction_compression OFF
62 insert into t1 select a+8 from t1;
63 include/assert.inc [Compressed data size remains same.]
64 include/assert.inc [Uncompressed data size increased.]
65 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
66 drop table t1;