Debian Codegraph @

mysql-test/suite/binlog/r/binlog_mysqlbinlog_compression.result

raw
1 RESET MASTER;
2 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
3 SET SESSION binlog_transaction_compression = ON;
4 SET GLOBAL binlog_transaction_compression = ON;
5 CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY, c2 LONGTEXT);
6 include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression_stats = 1]
7 include/assert.inc [The number of transactions reported is 0 (0 = 0)]
8 FLUSH LOGS;
9 DROP TABLE t1;
10 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
11 RESET MASTER;
12 include/assert.inc [Table contents is the same after replaying with mysqlbinlog]
13 include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression_stats = 1]
14 DROP TABLE t1;
15 RESET MASTER;
16 CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY, c2 LONGTEXT);
17 RESET MASTER;
18 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
19 INSERT INTO t1 VALUES (2, REPEAT('b', 1000000));
20 include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression_stats = 1]
21 include/assert.inc [The number of transactions reported is 1 (1 = 1)]
22 FLUSH LOGS;
23 DELETE FROM t1;
24 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
25 RESET MASTER;
26 include/assert.inc [Table contents is the same after replaying with mysqlbinlog]
27 include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression_stats = 1]
28 include/assert.inc [The number of transactions reported is 1]
29 include/assert.inc [Compression bytes is the same after replaying with mysqlbinlog]
30 include/assert.inc [Uncompressed bytes is roughly the same after replaying with mysqlbinlog]
31 include/assert.inc [Last transaction commpressed bytes is roughly the same after replaying with mysqlbinlog]
32 include/assert.inc [Last transaction uncommpressed bytes is roughly the same after replaying with mysqlbinlog]
33 include/assert.inc [Last transaction id is the same after replaying with mysqlbinlog]
34 DROP TABLE t1;
35 RESET MASTER;
36 CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY, c2 LONGTEXT);
37 INSERT INTO t1 VALUES (2, REPEAT('b', 1000000));
38 RESET MASTER;
39 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
40 UPDATE t1 SET c2=REPEAT('c', 1000000);
41 include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression_stats = 1]
42 include/assert.inc [The number of transactions reported is 1 (1 = 1)]
43 FLUSH LOGS;
44 DELETE FROM t1;
45 INSERT INTO t1 VALUES (2, REPEAT('b', 1000000));
46 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
47 RESET MASTER;
48 include/assert.inc [Table contents is the same after replaying with mysqlbinlog]
49 include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression_stats = 1]
50 include/assert.inc [The number of transactions reported is 1]
51 include/assert.inc [Compression bytes is the same after replaying with mysqlbinlog]
52 include/assert.inc [Uncompressed bytes is roughly the same after replaying with mysqlbinlog]
53 include/assert.inc [Last transaction commpressed bytes is roughly the same after replaying with mysqlbinlog]
54 include/assert.inc [Last transaction uncommpressed bytes is roughly the same after replaying with mysqlbinlog]
55 include/assert.inc [Last transaction id is the same after replaying with mysqlbinlog]
56 DROP TABLE t1;
57 RESET MASTER;
58 CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY, c2 LONGTEXT);
59 INSERT INTO t1 VALUES (2, REPEAT('b', 1000000));
60 UPDATE t1 SET c2=REPEAT('c', 1000000);
61 RESET MASTER;
62 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
63 DELETE FROM t1;
64 include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression_stats = 1]
65 include/assert.inc [The number of transactions reported is 1 (1 = 1)]
66 FLUSH LOGS;
67 DELETE FROM t1;
68 INSERT INTO t1 VALUES (2, REPEAT('b', 1000000));
69 UPDATE t1 SET c2=REPEAT('c', 1000000);
70 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
71 RESET MASTER;
72 include/assert.inc [Table contents is the same after replaying with mysqlbinlog]
73 include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression_stats = 1]
74 include/assert.inc [The number of transactions reported is 1]
75 include/assert.inc [Compression bytes is the same after replaying with mysqlbinlog]
76 include/assert.inc [Uncompressed bytes is roughly the same after replaying with mysqlbinlog]
77 include/assert.inc [Last transaction commpressed bytes is roughly the same after replaying with mysqlbinlog]
78 include/assert.inc [Last transaction uncommpressed bytes is roughly the same after replaying with mysqlbinlog]
79 include/assert.inc [Last transaction id is the same after replaying with mysqlbinlog]
80 DROP TABLE t1;
81 RESET MASTER;
82 RESET MASTER;
83 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
84 SET SESSION binlog_transaction_compression = ON;
85 CREATE TABLE t1 (c1 INT);
86 INSERT INTO t1 VALUES (1);
87 DROP TABLE t1;
88 FLUSH LOGS;
89 include/assert_grep.inc [mysqlbinlog prints comments for compressed transactions as instructed by the specification]
90 include/assert_grep.inc [mysqlbinlog prints comments for compressed transactions as instructed by the specification]
91 RESET MASTER;
92 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
93 RESET MASTER;
94 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
95 SET SESSION binlog_transaction_compression = ON;
96 SET GLOBAL binlog_transaction_compression = OFF;
97 CREATE TABLE t1 (c1 INT);
98 INSERT INTO t1 VALUES (1);
99 FLUSH LOGS;
100 DROP TABLE t1;
101 RESET MASTER;
102 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
103 include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression_stats where log_type='BINARY' AND compression = 'ZSTD' is 0]
104 include/assert.inc [Number of rows in performance_schema.binary_log_transaction_compression_stats where log_type='BINARY' AND compression = 'NONE' is 1]
105 DROP TABLE t1;
106 RESET MASTER;
107 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
108 RESET MASTER;
109 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
110 SET SESSION binlog_transaction_compression = ON;;
111 SET SESSION SQL_LOG_BIN=0;
112 CREATE TABLE t1 (c1 INT);
113 INSERT INTO t1 VALUES (1);
114 DROP TABLE t1;
115 SET SESSION SQL_LOG_BIN=1;
116 include/assert.inc [No rows in the performance schema table.]
117 RESET MASTER;
118 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
119 SET SESSION binlog_transaction_compression = OFF;;
120 SET SESSION SQL_LOG_BIN=0;
121 CREATE TABLE t1 (c1 INT);
122 INSERT INTO t1 VALUES (1);
123 DROP TABLE t1;
124 SET SESSION SQL_LOG_BIN=1;
125 include/assert.inc [No rows in the performance schema table.]
126 RESET MASTER;
127 TRUNCATE performance_schema.binary_log_transaction_compression_stats;
128 SET SESSION binlog_transaction_compression = SAVED;
129 SET GLOBAL binlog_transaction_compression = SAVED;