Debian Codegraph @

mysql-test/suite/x/r/compression_level_lz4_server.result

raw
1 SET GLOBAL mysqlx_compression_algorithms='DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM';
2 CREATE SCHEMA xtest;
3 CREATE TABLE xtest.data(val VARCHAR(256));
4 SET GLOBAL mysqlx_lz4_max_client_compression_level=16;
5
6 Verify LZ4_MESSAGE at level 0
7 =============================
8 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
9 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 0]
10 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
11 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
12 Mysqlx.Ok {
13 msg: "bye!"
14 }
15 ok
16
17 Verify LZ4_MESSAGE at level 1
18 =============================
19 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
20 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 1]
21 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
22 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
23 Mysqlx.Ok {
24 msg: "bye!"
25 }
26 ok
27
28 Verify LZ4_MESSAGE at level 2
29 =============================
30 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
31 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 2]
32 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
33 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
34 Mysqlx.Ok {
35 msg: "bye!"
36 }
37 ok
38
39 Verify LZ4_MESSAGE at level 3
40 =============================
41 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
42 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 3]
43 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
44 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
45 Mysqlx.Ok {
46 msg: "bye!"
47 }
48 ok
49
50 Verify LZ4_MESSAGE at level 4
51 =============================
52 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
53 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 4]
54 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
55 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
56 Mysqlx.Ok {
57 msg: "bye!"
58 }
59 ok
60
61 Verify LZ4_MESSAGE at level 5
62 =============================
63 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
64 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 5]
65 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
66 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
67 Mysqlx.Ok {
68 msg: "bye!"
69 }
70 ok
71
72 Verify LZ4_MESSAGE at level 6
73 =============================
74 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
75 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 6]
76 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
77 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
78 Mysqlx.Ok {
79 msg: "bye!"
80 }
81 ok
82
83 Verify LZ4_MESSAGE at level 7
84 =============================
85 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
86 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 7]
87 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
88 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
89 Mysqlx.Ok {
90 msg: "bye!"
91 }
92 ok
93
94 Verify LZ4_MESSAGE at level 8
95 =============================
96 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
97 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 8]
98 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
99 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
100 Mysqlx.Ok {
101 msg: "bye!"
102 }
103 ok
104
105 Verify LZ4_MESSAGE at level 9
106 =============================
107 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
108 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 9]
109 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
110 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
111 Mysqlx.Ok {
112 msg: "bye!"
113 }
114 ok
115
116 Verify LZ4_MESSAGE at level 10
117 ==============================
118 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
119 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 10]
120 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
121 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
122 Mysqlx.Ok {
123 msg: "bye!"
124 }
125 ok
126
127 Verify LZ4_MESSAGE at level 11
128 ==============================
129 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
130 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 11]
131 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
132 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
133 Mysqlx.Ok {
134 msg: "bye!"
135 }
136 ok
137
138 Verify LZ4_MESSAGE at level 12
139 ==============================
140 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
141 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 12]
142 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
143 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
144 Mysqlx.Ok {
145 msg: "bye!"
146 }
147 ok
148
149 Verify LZ4_MESSAGE at level 13
150 ==============================
151 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
152 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 13]
153 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
154 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
155 Mysqlx.Ok {
156 msg: "bye!"
157 }
158 ok
159
160 Verify LZ4_MESSAGE at level 14
161 ==============================
162 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
163 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 14]
164 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
165 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
166 Mysqlx.Ok {
167 msg: "bye!"
168 }
169 ok
170
171 Verify LZ4_MESSAGE at level 15
172 ==============================
173 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
174 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 15]
175 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
176 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
177 Mysqlx.Ok {
178 msg: "bye!"
179 }
180 ok
181
182 Verify LZ4_MESSAGE at level 16
183 ==============================
184 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of LZ4_MESSAGE]
185 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 16]
186 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to have a value of 0]
187 Verify [Status variable "Mysqlx_bytes_sent_compressed_payload" needs to be lower than "Mysqlx_bytes_sent_uncompressed_frame"]
188 Mysqlx.Ok {
189 msg: "bye!"
190 }
191 ok
192 SET GLOBAL mysqlx_lz4_max_client_compression_level=DEFAULT;
193 SET GLOBAL mysqlx_compression_algorithms=DEFAULT;