Debian Codegraph @

mysql-test/suite/x/r/compression_level_deflate_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_deflate_max_client_compression_level=9;
5
6 Verify DEFLATE_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 DEFLATE_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 DEFLATE_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 DEFLATE_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 DEFLATE_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 DEFLATE_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 DEFLATE_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 DEFLATE_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 DEFLATE_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 SET GLOBAL mysqlx_deflate_max_client_compression_level=DEFAULT;
87 SET GLOBAL mysqlx_compression_algorithms=DEFAULT;