Debian Codegraph @

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

raw
1 ## 1. Verify compression at server 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_sent') ,
6 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_compressed_payload'),
7 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_uncompressed_frame')
8 INTO @send1,@send_comp1,@send_uncomp1
9
10 1 rows affected
11 RUN SHOW STATUS LIKE 'Mysqlx_%'
12 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_sent') ,
13 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_compressed_payload'),
14 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_uncompressed_frame')
15 INTO @send2,@send_comp2,@send_uncomp2
16
17 1 rows affected
18 RUN SHOW STATUS LIKE 'Mysqlx_%'
19 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_sent') ,
20 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_compressed_payload'),
21 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_uncompressed_frame')
22 INTO @send3,@send_comp3,@send_uncomp3
23
24 1 rows affected
25 RUN SELECT @send3 > 0;
26 Verify ["SELECT @send3 > 0" returns in first column, following value 1]
27 RUN SELECT @send2 > 0;
28 Verify ["SELECT @send2 > 0" returns in first column, following value 1]
29 RUN SELECT @send1 > 0;
30 Verify ["SELECT @send1 > 0" returns in first column, following value 1]
31 RUN SELECT @send_uncomp3 > 0;
32 Verify ["SELECT @send_uncomp3 > 0" returns in first column, following value 1]
33 RUN SELECT @send_uncomp2 > 0;
34 Verify ["SELECT @send_uncomp2 > 0" returns in first column, following value 1]
35 RUN SELECT @send_uncomp3 > 0+@send_uncomp2;
36 Verify ["SELECT @send_uncomp3 > 0+@send_uncomp2" returns in first column, following value 1]
37 RUN SELECT @send_comp3 > 0;
38 Verify ["SELECT @send_comp3 > 0" returns in first column, following value 1]
39 RUN SELECT @send_comp2 > 0;
40 Verify ["SELECT @send_comp2 > 0" returns in first column, following value 1]
41 RUN SELECT @send_comp3 > 0+@send_comp2;
42 Verify ["SELECT @send_comp3 > 0+@send_comp2" returns in first column, following value 1]
43 Mysqlx.Ok {
44 msg: "bye!"
45 }
46 ok
47 ## 2. Verify compression at server 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_sent') ,
52 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_compressed_payload'),
53 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_uncompressed_frame')
54 INTO @send1,@send_comp1,@send_uncomp1
55
56 1 rows affected
57 RUN SHOW STATUS LIKE 'Mysqlx_%'
58 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_sent') ,
59 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_compressed_payload'),
60 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_uncompressed_frame')
61 INTO @send2,@send_comp2,@send_uncomp2
62
63 1 rows affected
64 RUN SHOW STATUS LIKE 'Mysqlx_%'
65 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_sent') ,
66 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_compressed_payload'),
67 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_uncompressed_frame')
68 INTO @send3,@send_comp3,@send_uncomp3
69
70 1 rows affected
71 RUN SELECT @send3 > 0;
72 Verify ["SELECT @send3 > 0" returns in first column, following value 1]
73 RUN SELECT @send2 > 0;
74 Verify ["SELECT @send2 > 0" returns in first column, following value 1]
75 RUN SELECT @send1 > 0;
76 Verify ["SELECT @send1 > 0" returns in first column, following value 1]
77 RUN SELECT @send_uncomp3 > 0;
78 Verify ["SELECT @send_uncomp3 > 0" returns in first column, following value 1]
79 RUN SELECT @send_uncomp2 > 0;
80 Verify ["SELECT @send_uncomp2 > 0" returns in first column, following value 1]
81 RUN SELECT @send_uncomp3 > 0+@send_uncomp2;
82 Verify ["SELECT @send_uncomp3 > 0+@send_uncomp2" returns in first column, following value 1]
83 RUN SELECT @send_comp3 > 0;
84 Verify ["SELECT @send_comp3 > 0" returns in first column, following value 1]
85 RUN SELECT @send_comp2 > 0;
86 Verify ["SELECT @send_comp2 > 0" returns in first column, following value 1]
87 RUN SELECT @send_comp3 > 0+@send_comp2;
88 Verify ["SELECT @send_comp3 > 0+@send_comp2" returns in first column, following value 1]
89 Mysqlx.Ok {
90 msg: "bye!"
91 }
92 ok
93 ## 3. Verify compression at server 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_sent') ,
98 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_compressed_payload'),
99 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_uncompressed_frame')
100 INTO @send1,@send_comp1,@send_uncomp1
101
102 1 rows affected
103 RUN SHOW STATUS LIKE 'Mysqlx_%'
104 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_sent') ,
105 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_compressed_payload'),
106 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_uncompressed_frame')
107 INTO @send2,@send_comp2,@send_uncomp2
108
109 1 rows affected
110 RUN SHOW STATUS LIKE 'Mysqlx_%'
111 RUN SELECT (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'mysqlx_bytes_sent') ,
112 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_compressed_payload'),
113 (select VARIABLE_VALUE from session_status WHERE VARIABLE_NAME like 'Mysqlx_bytes_sent_uncompressed_frame')
114 INTO @send3,@send_comp3,@send_uncomp3
115
116 1 rows affected
117 RUN SELECT @send3 > 0;
118 Verify ["SELECT @send3 > 0" returns in first column, following value 1]
119 RUN SELECT @send2 > 0;
120 Verify ["SELECT @send2 > 0" returns in first column, following value 1]
121 RUN SELECT @send1 > 0;
122 Verify ["SELECT @send1 > 0" returns in first column, following value 1]
123 RUN SELECT @send_uncomp3 > 0;
124 Verify ["SELECT @send_uncomp3 > 0" returns in first column, following value 1]
125 RUN SELECT @send_uncomp2 > 0;
126 Verify ["SELECT @send_uncomp2 > 0" returns in first column, following value 1]
127 RUN SELECT @send_uncomp3 > 0+@send_uncomp2;
128 Verify ["SELECT @send_uncomp3 > 0+@send_uncomp2" returns in first column, following value 1]
129 RUN SELECT @send_comp3 > 0;
130 Verify ["SELECT @send_comp3 > 0" returns in first column, following value 1]
131 RUN SELECT @send_comp2 > 0;
132 Verify ["SELECT @send_comp2 > 0" returns in first column, following value 1]
133 RUN SELECT @send_comp3 > 0+@send_comp2;
134 Verify ["SELECT @send_comp3 > 0+@send_comp2" returns in first column, following value 1]
135 Mysqlx.Ok {
136 msg: "bye!"
137 }
138 ok