Debian Codegraph @

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

raw
1 CREATE SCHEMA xtest;
2 CREATE TABLE xtest.data(val VARCHAR(256));
3 SET GLOBAL mysqlx_compression_algorithms='DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM';
4 SET GLOBAL mysqlx_zstd_max_client_compression_level=22;
5
6 Verify ZSTD_STREAM at level 1
7 =============================
8 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 1]
9 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
10 Mysqlx.Ok {
11 msg: "bye!"
12 }
13 ok
14
15 Verify ZSTD_STREAM at level 2
16 =============================
17 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 2]
18 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
19 Mysqlx.Ok {
20 msg: "bye!"
21 }
22 ok
23
24 Verify ZSTD_STREAM at level 3
25 =============================
26 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 3]
27 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
28 Mysqlx.Ok {
29 msg: "bye!"
30 }
31 ok
32
33 Verify ZSTD_STREAM at level 4
34 =============================
35 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 4]
36 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
37 Mysqlx.Ok {
38 msg: "bye!"
39 }
40 ok
41
42 Verify ZSTD_STREAM at level 5
43 =============================
44 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 5]
45 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
46 Mysqlx.Ok {
47 msg: "bye!"
48 }
49 ok
50
51 Verify ZSTD_STREAM at level 6
52 =============================
53 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 6]
54 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
55 Mysqlx.Ok {
56 msg: "bye!"
57 }
58 ok
59
60 Verify ZSTD_STREAM at level 7
61 =============================
62 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 7]
63 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
64 Mysqlx.Ok {
65 msg: "bye!"
66 }
67 ok
68
69 Verify ZSTD_STREAM at level 8
70 =============================
71 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 8]
72 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
73 Mysqlx.Ok {
74 msg: "bye!"
75 }
76 ok
77
78 Verify ZSTD_STREAM at level 9
79 =============================
80 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 9]
81 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
82 Mysqlx.Ok {
83 msg: "bye!"
84 }
85 ok
86
87 Verify ZSTD_STREAM at level 10
88 ==============================
89 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 10]
90 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
91 Mysqlx.Ok {
92 msg: "bye!"
93 }
94 ok
95
96 Verify ZSTD_STREAM at level 11
97 ==============================
98 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 11]
99 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
100 Mysqlx.Ok {
101 msg: "bye!"
102 }
103 ok
104
105 Verify ZSTD_STREAM at level 12
106 ==============================
107 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 12]
108 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
109 Mysqlx.Ok {
110 msg: "bye!"
111 }
112 ok
113
114 Verify ZSTD_STREAM at level 13
115 ==============================
116 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 13]
117 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
118 Mysqlx.Ok {
119 msg: "bye!"
120 }
121 ok
122
123 Verify ZSTD_STREAM at level 14
124 ==============================
125 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 14]
126 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
127 Mysqlx.Ok {
128 msg: "bye!"
129 }
130 ok
131
132 Verify ZSTD_STREAM at level 15
133 ==============================
134 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 15]
135 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
136 Mysqlx.Ok {
137 msg: "bye!"
138 }
139 ok
140
141 Verify ZSTD_STREAM at level 16
142 ==============================
143 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 16]
144 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
145 Mysqlx.Ok {
146 msg: "bye!"
147 }
148 ok
149
150 Verify ZSTD_STREAM at level 17
151 ==============================
152 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 17]
153 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
154 Mysqlx.Ok {
155 msg: "bye!"
156 }
157 ok
158
159 Verify ZSTD_STREAM at level 18
160 ==============================
161 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 18]
162 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
163 Mysqlx.Ok {
164 msg: "bye!"
165 }
166 ok
167
168 Verify ZSTD_STREAM at level 19
169 ==============================
170 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 19]
171 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
172 Mysqlx.Ok {
173 msg: "bye!"
174 }
175 ok
176
177 Verify ZSTD_STREAM at level 20
178 ==============================
179 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 20]
180 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
181 Mysqlx.Ok {
182 msg: "bye!"
183 }
184 ok
185
186 Verify ZSTD_STREAM at level 21
187 ==============================
188 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 21]
189 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
190 Mysqlx.Ok {
191 msg: "bye!"
192 }
193 ok
194
195 Verify ZSTD_STREAM at level 22
196 ==============================
197 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 22]
198 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
199 Mysqlx.Ok {
200 msg: "bye!"
201 }
202 ok
203
204 Verify ZSTD_STREAM at level -1
205 ==============================
206 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -1]
207 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
208 Mysqlx.Ok {
209 msg: "bye!"
210 }
211 ok
212
213 Verify ZSTD_STREAM at level -2
214 ==============================
215 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -2]
216 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
217 Mysqlx.Ok {
218 msg: "bye!"
219 }
220 ok
221
222 Verify ZSTD_STREAM at level -3
223 ==============================
224 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -3]
225 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
226 Mysqlx.Ok {
227 msg: "bye!"
228 }
229 ok
230
231 Verify ZSTD_STREAM at level -4
232 ==============================
233 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -4]
234 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
235 Mysqlx.Ok {
236 msg: "bye!"
237 }
238 ok
239
240 Verify ZSTD_STREAM at level -5
241 ==============================
242 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -5]
243 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
244 Mysqlx.Ok {
245 msg: "bye!"
246 }
247 ok
248
249 Verify ZSTD_STREAM at level -6
250 ==============================
251 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -6]
252 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
253 Mysqlx.Ok {
254 msg: "bye!"
255 }
256 ok
257
258 Verify ZSTD_STREAM at level -7
259 ==============================
260 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -7]
261 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
262 Mysqlx.Ok {
263 msg: "bye!"
264 }
265 ok
266
267 Verify ZSTD_STREAM at level -8
268 ==============================
269 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -8]
270 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
271 Mysqlx.Ok {
272 msg: "bye!"
273 }
274 ok
275
276 Verify ZSTD_STREAM at level -9
277 ==============================
278 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -9]
279 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
280 Mysqlx.Ok {
281 msg: "bye!"
282 }
283 ok
284
285 Verify ZSTD_STREAM at level -10
286 ===============================
287 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -10]
288 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
289 Mysqlx.Ok {
290 msg: "bye!"
291 }
292 ok
293
294 Verify ZSTD_STREAM at level -11
295 ===============================
296 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -11]
297 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
298 Mysqlx.Ok {
299 msg: "bye!"
300 }
301 ok
302
303 Verify ZSTD_STREAM at level -12
304 ===============================
305 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -12]
306 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
307 Mysqlx.Ok {
308 msg: "bye!"
309 }
310 ok
311
312 Verify ZSTD_STREAM at level -13
313 ===============================
314 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -13]
315 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
316 Mysqlx.Ok {
317 msg: "bye!"
318 }
319 ok
320
321 Verify ZSTD_STREAM at level -14
322 ===============================
323 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -14]
324 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
325 Mysqlx.Ok {
326 msg: "bye!"
327 }
328 ok
329
330 Verify ZSTD_STREAM at level -15
331 ===============================
332 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -15]
333 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
334 Mysqlx.Ok {
335 msg: "bye!"
336 }
337 ok
338
339 Verify ZSTD_STREAM at level -16
340 ===============================
341 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -16]
342 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
343 Mysqlx.Ok {
344 msg: "bye!"
345 }
346 ok
347
348 Verify ZSTD_STREAM at level -17
349 ===============================
350 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -17]
351 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
352 Mysqlx.Ok {
353 msg: "bye!"
354 }
355 ok
356
357 Verify ZSTD_STREAM at level -18
358 ===============================
359 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -18]
360 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
361 Mysqlx.Ok {
362 msg: "bye!"
363 }
364 ok
365
366 Verify ZSTD_STREAM at level -19
367 ===============================
368 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -19]
369 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
370 Mysqlx.Ok {
371 msg: "bye!"
372 }
373 ok
374
375 Verify ZSTD_STREAM at level -20
376 ===============================
377 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -20]
378 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
379 Mysqlx.Ok {
380 msg: "bye!"
381 }
382 ok
383
384 Verify ZSTD_STREAM at level -21
385 ===============================
386 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -21]
387 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
388 Mysqlx.Ok {
389 msg: "bye!"
390 }
391 ok
392
393 Verify ZSTD_STREAM at level -22
394 ===============================
395 Verify [Status variable "Mysqlx_compression_level" needs to have a value of -22]
396 Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
397 Mysqlx.Ok {
398 msg: "bye!"
399 }
400 ok
401 SET GLOBAL mysqlx_zstd_max_client_compression_level=DEFAULT;
402 SET GLOBAL mysqlx_compression_algorithms=DEFAULT;