Debian Codegraph @

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

raw
1 ## 1. Verify compression at client side using ZLIB algorithm
2 RUN use performance_schema
3
4 0 rows affected
5 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received') ,
6 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_compressed_payload'),
7 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_uncompressed_frame')
8 INTO @received1,@received_comp1,@received_uncomp1
9
10 1 rows affected
11 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received') ,
12 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_compressed_payload'),
13 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_uncompressed_frame')
14 INTO @received2,@received_comp2,@received_uncomp2
15
16 1 rows affected
17 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received') ,
18 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_compressed_payload'),
19 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_uncompressed_frame')
20 INTO @received3,@received_comp3,@received_uncomp3
21
22 1 rows affected
23 RUN SELECT @received3 > 0;
24 Verify ["SELECT @received3 > 0" returns in first column, following value 1]
25 RUN SELECT @received2 > 0;
26 Verify ["SELECT @received2 > 0" returns in first column, following value 1]
27 RUN SELECT @received1 > 0;
28 Verify ["SELECT @received1 > 0" returns in first column, following value 1]
29 RUN SELECT @received_uncomp3 > 0;
30 Verify ["SELECT @received_uncomp3 > 0" returns in first column, following value 1]
31 RUN SELECT @received_uncomp2 > 0;
32 Verify ["SELECT @received_uncomp2 > 0" returns in first column, following value 1]
33 RUN SELECT @received_uncomp3 > @received_uncomp2;
34 Verify ["SELECT @received_uncomp3 > @received_uncomp2" returns in first column, following value 1]
35 RUN SELECT @received_comp3 > 0;
36 Verify ["SELECT @received_comp3 > 0" returns in first column, following value 1]
37 RUN SELECT @received_comp2 > 0;
38 Verify ["SELECT @received_comp2 > 0" returns in first column, following value 1]
39 RUN SELECT @received_comp3 > 0+@received_comp2;
40 Verify ["SELECT @received_comp3 > 0+@received_comp2" returns in first column, following value 1]
41 RUN SELECT (@received_comp2 - @received_comp1) >= (@received_comp3 - @received_comp2);
42 Verify ["SELECT (@received_comp2 - @received_comp1) >= (@received_comp3 - @received_comp2)" returns in first column, following value 1]
43 Mysqlx.Ok {
44 msg: "bye!"
45 }
46 ok
47 ## 2. Verify compression at client side using LZ4Frame algorithm
48 RUN use performance_schema
49
50 0 rows affected
51 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received') ,
52 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_compressed_payload'),
53 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_uncompressed_frame')
54 INTO @received1,@received_comp1,@received_uncomp1
55
56 1 rows affected
57 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received') ,
58 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_compressed_payload'),
59 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_uncompressed_frame')
60 INTO @received2,@received_comp2,@received_uncomp2
61
62 1 rows affected
63 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received') ,
64 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_compressed_payload'),
65 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_uncompressed_frame')
66 INTO @received3,@received_comp3,@received_uncomp3
67
68 1 rows affected
69 RUN SELECT @received3 > 0;
70 Verify ["SELECT @received3 > 0" returns in first column, following value 1]
71 RUN SELECT @received2 > 0;
72 Verify ["SELECT @received2 > 0" returns in first column, following value 1]
73 RUN SELECT @received1 > 0;
74 Verify ["SELECT @received1 > 0" returns in first column, following value 1]
75 RUN SELECT @received_uncomp3 > 0;
76 Verify ["SELECT @received_uncomp3 > 0" returns in first column, following value 1]
77 RUN SELECT @received_uncomp2 > 0;
78 Verify ["SELECT @received_uncomp2 > 0" returns in first column, following value 1]
79 RUN SELECT @received_uncomp3 > @received_uncomp2;
80 Verify ["SELECT @received_uncomp3 > @received_uncomp2" returns in first column, following value 1]
81 RUN SELECT @received_comp3 > 0;
82 Verify ["SELECT @received_comp3 > 0" returns in first column, following value 1]
83 RUN SELECT @received_comp2 > 0;
84 Verify ["SELECT @received_comp2 > 0" returns in first column, following value 1]
85 RUN SELECT @received_comp3 > 0+@received_comp2;
86 Verify ["SELECT @received_comp3 > 0+@received_comp2" returns in first column, following value 1]
87 RUN SELECT (@received_comp2 - @received_comp1) >= (@received_comp3 - @received_comp2);
88 Verify ["SELECT (@received_comp2 - @received_comp1) >= (@received_comp3 - @received_comp2)" returns in first column, following value 1]
89 Mysqlx.Ok {
90 msg: "bye!"
91 }
92 ok
93 ## 3. Verify compression at client side using ZSTD algorithm
94 RUN use performance_schema
95
96 0 rows affected
97 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received') ,
98 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_compressed_payload'),
99 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_uncompressed_frame')
100 INTO @received1,@received_comp1,@received_uncomp1
101
102 1 rows affected
103 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received') ,
104 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_compressed_payload'),
105 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_uncompressed_frame')
106 INTO @received2,@received_comp2,@received_uncomp2
107
108 1 rows affected
109 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received') ,
110 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_compressed_payload'),
111 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_received_uncompressed_frame')
112 INTO @received3,@received_comp3,@received_uncomp3
113
114 1 rows affected
115 RUN SELECT @received3 > 0;
116 Verify ["SELECT @received3 > 0" returns in first column, following value 1]
117 RUN SELECT @received2 > 0;
118 Verify ["SELECT @received2 > 0" returns in first column, following value 1]
119 RUN SELECT @received1 > 0;
120 Verify ["SELECT @received1 > 0" returns in first column, following value 1]
121 RUN SELECT @received_uncomp3 > 0;
122 Verify ["SELECT @received_uncomp3 > 0" returns in first column, following value 1]
123 RUN SELECT @received_uncomp2 > 0;
124 Verify ["SELECT @received_uncomp2 > 0" returns in first column, following value 1]
125 RUN SELECT @received_uncomp3 > @received_uncomp2;
126 Verify ["SELECT @received_uncomp3 > @received_uncomp2" returns in first column, following value 1]
127 RUN SELECT @received_comp3 > 0;
128 Verify ["SELECT @received_comp3 > 0" returns in first column, following value 1]
129 RUN SELECT @received_comp2 > 0;
130 Verify ["SELECT @received_comp2 > 0" returns in first column, following value 1]
131 RUN SELECT @received_comp3 > 0+@received_comp2;
132 Verify ["SELECT @received_comp3 > 0+@received_comp2" returns in first column, following value 1]
133 RUN SELECT (@received_comp2 - @received_comp1) >= (@received_comp3 - @received_comp2);
134 Verify ["SELECT (@received_comp2 - @received_comp1) >= (@received_comp3 - @received_comp2)" returns in first column, following value 1]
135 Mysqlx.Ok {
136 msg: "bye!"
137 }
138 ok