Debian Codegraph @

mysql-test/suite/x/r/compression_level_deflate_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_deflate_max_client_compression_level=9;
5
6 Verify DEFLATE_STREAM at level 1
7 ================================
8 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of DEFLATE_STREAM]
9 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 1]
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 DEFLATE_STREAM at level 2
18 ================================
19 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of DEFLATE_STREAM]
20 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 2]
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 DEFLATE_STREAM at level 3
29 ================================
30 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of DEFLATE_STREAM]
31 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 3]
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 DEFLATE_STREAM at level 4
40 ================================
41 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of DEFLATE_STREAM]
42 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 4]
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 DEFLATE_STREAM at level 5
51 ================================
52 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of DEFLATE_STREAM]
53 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 5]
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 DEFLATE_STREAM at level 6
62 ================================
63 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of DEFLATE_STREAM]
64 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 6]
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 DEFLATE_STREAM at level 7
73 ================================
74 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of DEFLATE_STREAM]
75 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 7]
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 DEFLATE_STREAM at level 8
84 ================================
85 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of DEFLATE_STREAM]
86 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 8]
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 DEFLATE_STREAM at level 9
95 ================================
96 Verify [Status variable "Mysqlx_compression_algorithm" needs to have a value of DEFLATE_STREAM]
97 Verify [Status variable "Mysqlx_compression_level" needs to have a value of 9]
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 SET GLOBAL mysqlx_deflate_max_client_compression_level=DEFAULT;
105 SET GLOBAL mysqlx_compression_algorithms=DEFAULT;