| 1 |
SET SESSION binlog_transaction_compression = ON; |
| 2 |
CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY, c2 LONGTEXT); |
| 3 |
INSERT INTO t1 VALUES (2, REPEAT('b', 1000000)); |
| 4 |
DROP TABLE t1; |
| 5 |
include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression_stats = 2] |
| 6 |
# restart |
| 7 |
include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression_stats = 0] |
| 8 |
# restart:--skip-log-bin |
| 9 |
SET SESSION binlog_transaction_compression = ON; |
| 10 |
CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY, c2 LONGTEXT); |
| 11 |
INSERT INTO t1 VALUES (2, REPEAT('b', 1000000)); |
| 12 |
DROP TABLE t1; |
| 13 |
include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression_stats = 0] |
| 14 |
# restart |
| 15 |
SET SESSION binlog_transaction_compression = 0; |
| 16 |
SET GLOBAL binlog_transaction_compression = 0; |