Debian Codegraph @

mysql-test/suite/binlog_nogtid/t/compression_non_trans.test

raw
1 #
2 # WL#3549: Test non-transactional engines and binlog compression
3 #
4 # This test validates that whenever there are non-trans changes
5 # compression does not take place. In addition to that it also makes
6 # sure that no compression stats appear in performance schema.
7 #
8
9 --source include/have_binlog_format_row.inc
10 --source include/have_myisam.inc
11
12 --let $show_rpl_debug_info = 0
13 --let $keep_gtid_events= 1
14
15 --let $saved_binlog_transaction_compression_session = `SELECT @@SESSION.binlog_transaction_compression`
16 --let $compression_type = LZ4
17 --let $pfs_table = performance_schema.binary_log_transaction_compression_stats
18
19 --let $i = 1
20 while ($i < 4)
21 {
22 --let $test2_or_test3 = `SELECT $i > 1`
23
24 SET SESSION binlog_transaction_compression = ON;
25 CREATE TABLE t1(c1 INT PRIMARY KEY, data TEXT(30000)) ENGINE = MYISAM;
26 CREATE TABLE t2(c1 INT PRIMARY KEY, data TEXT(30000)) ENGINE = InnoDB;
27 INSERT INTO t1 VALUES (1, REPEAT ('a', 1000));
28 INSERT INTO t2 VALUES (1, REPEAT ('b', 1000));
29
30 RESET MASTER;
31 --eval TRUNCATE $pfs_table
32
33 if ($i == 1)
34 {
35 --echo #
36 --echo # Test 1: single non-trans statement
37 --echo #
38
39 INSERT INTO t1 VALUES (2, REPEAT ('c', 1000));
40 --let $evt1=Query
41 --let $evt2=Table_map
42 --let $evt3=Write_rows
43 --let $evt3_expected=Write_rows
44 --let $evt4=Query
45 }
46
47 if ($i == 2)
48 {
49 --echo #
50 --echo # Test 2: single non-trans + trans statement
51 --echo #
52
53 UPDATE t1, t2 SET t1.c1 = 2, t2.c1=2;
54 --let $evt1=Query
55 --let $evt2=Table_map
56 --let $evt3=Update_rows
57 --let $evt3_expected=Update_rows
58 --let $evt4=Query
59
60 --let $evt5=Query
61 --let $evt6=Table_map
62 --let $evt7=Update_rows
63 --let $evt8=Xid
64
65 --source include/show_binlog_events.inc
66 }
67
68 if ($i == 3)
69 {
70 --echo #
71 --echo # Test 3: transaction with non-trans and trans statement
72 --echo #
73
74 BEGIN;
75 UPDATE t2 SET c1=2;
76 UPDATE t1 SET c1=2;
77 COMMIT;
78
79 --let $evt1=Query
80 --let $evt2=Table_map
81 --let $evt3=Update_rows
82 --let $evt3_expected=Update_rows
83 --let $evt4=Query
84
85 --let $evt5=Query
86 --let $evt6=Table_map
87 --let $evt7=Update_rows
88 --let $evt8=Xid
89 }
90
91 # 1 - Format_desc event, 2 - Previous_gtids event, 3 - Gtid event
92
93 --let $evt= query_get_value(SHOW BINLOG EVENTS, Event_type, 4)
94 --let $assert_text = Expected event type Query (begin)
95 --let $assert_cond = "$evt" = "$evt1"
96 --source include/assert.inc
97
98 --let $evt= query_get_value(SHOW BINLOG EVENTS, Event_type, 5)
99 --let $assert_text = Expected event type Table_map
100 --let $assert_cond = "$evt" = "$evt2"
101 --source include/assert.inc
102
103 --let $evt= query_get_value(SHOW BINLOG EVENTS, Event_type, 6)
104 --let $assert_text = Expected event type $evt3_expected
105 --let $assert_cond = "$evt" = "$evt3"
106 --source include/assert.inc
107
108 --let $evt= query_get_value(SHOW BINLOG EVENTS, Event_type, 7)
109 --let $assert_text = Expected event type Query (commit)
110 --let $assert_cond = "$evt" = "$evt4"
111 --source include/assert.inc
112
113 if ($test2_or_test3 > 0)
114 {
115 # 8 - Gtid event
116
117 --let $evt= query_get_value(SHOW BINLOG EVENTS, Event_type, 9)
118 --let $assert_text = Expected event type Query (begin)
119 --let $assert_cond = "$evt" = "$evt5"
120 --source include/assert.inc
121
122 --let $evt= query_get_value(SHOW BINLOG EVENTS, Event_type, 10)
123 --let $assert_text = Expected event type Table_map
124 --let $assert_cond = "$evt" = "$evt6"
125 --source include/assert.inc
126
127 --let $evt= query_get_value(SHOW BINLOG EVENTS, Event_type, 11)
128 --let $assert_text = Expected event type Update_rows
129 --let $assert_cond = "$evt" = "$evt7"
130 --source include/assert.inc
131
132 --let $evt= query_get_value(SHOW BINLOG EVENTS, Event_type, 12)
133 --let $assert_text = Expected event type Xid
134 --let $assert_cond = "$evt" = "$evt8"
135 --source include/assert.inc
136 }
137
138 # assert that we have no stats on the performance_schema table for compression
139 --let $nrows = `SELECT COUNT(*) FROM $pfs_table WHERE log_type ='BINARY' AND compression_type='$compression_type'`
140 --let $assert_cond = $nrows = 0
141 --let $assert_text = Number of rows in $pfs_table = 0 for compression_type != NONE
142 --source include/assert.inc
143
144 # assert that we have the stats on the table
145 --let $nrows = `SELECT COUNT(*) FROM $pfs_table WHERE log_type ='BINARY' AND compression_type='NONE'`
146 --let $assert_cond = $nrows = 1
147 --let $assert_text = Number of rows in $pfs_table = 1 for compression_type = NONE
148 --source include/assert.inc
149
150 # clean up
151 DROP TABLE IF EXISTS t1, t2;
152 --replace_result $saved_binlog_transaction_compression_session SAVED
153 --eval SET SESSION binlog_transaction_compression = $saved_binlog_transaction_compression_session
154 RESET MASTER;
155 --eval TRUNCATE $pfs_table
156
157 --inc $i
158 }
159