################################################ Validate binary log transaction compression option values and ranges ################################################ set @@SESSION.ndb_log_transaction_compression = ON; ERROR HY000: Variable 'ndb_log_transaction_compression' is a GLOBAL variable and should be set with SET GLOBAL set @@GLOBAL.ndb_log_transaction_compression = ON; set @@SESSION.ndb_log_transaction_compression_level_zstd = 1; ERROR HY000: Variable 'ndb_log_transaction_compression_level_zstd' is a GLOBAL variable and should be set with SET GLOBAL set @@GLOBAL.ndb_log_transaction_compression_level_zstd = 0; Warnings: Warning 1292 Truncated incorrect ndb_log_transaction_compression_level_zstd value: '0' Truncated to 1 show variables like 'ndb_log_transaction_compression_level_zstd'; Variable_name Value ndb_log_transaction_compression_level_zstd 1 set @@GLOBAL.ndb_log_transaction_compression_level_zstd = 23; Warnings: Warning 1292 Truncated incorrect ndb_log_transaction_compression_level_zstd value: '23' Truncated to 22 show variables like 'ndb_log_transaction_compression_level_zstd'; Variable_name Value ndb_log_transaction_compression_level_zstd 22 set @@GLOBAL.ndb_log_transaction_compression = DEFAULT; set @@GLOBAL.ndb_log_transaction_compression_level_zstd = DEFAULT; ################################################ Case 1: Observe binlog compression in ndbcluster when ndb_log_transaction_compression = default ################################################ show variables like 'ndb_log_bin'; Variable_name Value ndb_log_bin ON show variables like 'ndb_log_transaction_compression'; Variable_name Value ndb_log_transaction_compression OFF show variables like 'ndb_log_transaction_compression_level_zstd'; Variable_name Value ndb_log_transaction_compression_level_zstd 3 create table t1 (a int) engine=ndb; insert into t1 values (1); insert into t1 select a+1 from t1; insert into t1 select a+2 from t1; include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression (BINARY, ZSTD) = 0] ################################################ Case 2: Observe binlog compression in ndbcluster when ndb_log_transaction_compression = ON ################################################ set global ndb_log_transaction_compression = ON; show global variables like 'ndb_log_transaction_compression'; Variable_name Value ndb_log_transaction_compression ON insert into t1 select a+4 from t1; include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression (BINARY, ZSTD) = 1] ################################################ Case 3: Observe binlog compression in ndbcluster when ndb_log_transaction_compression = OFF ################################################ set global ndb_log_transaction_compression = OFF; show global variables like 'ndb_log_transaction_compression'; Variable_name Value ndb_log_transaction_compression OFF insert into t1 select a+8 from t1; include/assert.inc [Compressed data size remains same.] include/assert.inc [Uncompressed data size increased.] TRUNCATE performance_schema.binary_log_transaction_compression_stats; drop table t1;