Debian Codegraph @

mysql-test/suite/x/t/status_variables.test

raw
1 ## Preamle
2 --source include/xplugin_preamble.inc
3 --source include/xplugin_ssl_warnings_suppression.inc
4
5 ## Test case
6
7 # X Plugins thread management needs to be reinitialized
8 # to be able to test status variables like 'Mysqlx_worker_threads%'
9 --source include/restart_mysqld.inc
10
11 # Please update the test case when the variable count changes
12 # add/remove variable
13 let $wait_condition=
14 SELECT COUNT(*)=78 FROM performance_schema.global_status where variable_name like "Mysqlx_%";
15 --source include/wait_condition_or_abort.inc
16
17 # Values for variables that were overwritten by MTR
18 --let $mtr_overwrited_port= $MASTER_X_MYPORT
19 --let $mtr_overwrited_socket= $MASTER_X_MYSOCK
20
21 if (`SELECT CONVERT(@@version_compile_os using latin1) IN ("Win32","Win64","Windows")`)
22 {
23 --let $mtr_overwrited_socket= UNDEFINED
24 }
25
26
27 ## Verify default value of system variables
28 --let $assert_text= Mysqlx_port must match value set by MTR
29 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_port", Value, 1] = $mtr_overwrited_port
30 --source include/assert.inc
31
32 --let $assert_text= No connections were made, Mysqlx_stmt_execute_sql must match default value which is 0.
33 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_execute_sql", Value, 1] = 0
34 --source include/assert.inc
35
36 --let $assert_text= No connections were made, Mysqlx_stmt_execute_mysqlx must match default value which is 0.
37 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_execute_mysqlx", Value, 1] = 0
38 --source include/assert.inc
39
40 --let $assert_text= No connections were made, Mysqlx_crud_update must match default value which is 0.
41 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_update", Value, 1] = 0
42 --source include/assert.inc
43
44 --let $assert_text= No connections were made, Mysqlx_crud_update must match default value which is 0.
45 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_update", Value, 1] = 0
46 --source include/assert.inc
47
48 --let $assert_text= No connections were made, Mysqlx_crud_delete must match default value which is 0.
49 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_delete", Value, 1] = 0
50 --source include/assert.inc
51
52 --let $assert_text= No connections were made, Mysqlx_crud_find must match default value which is 0.
53 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_find", Value, 1] = 0
54 --source include/assert.inc
55
56 --let $assert_text= No connections were made, Mysqlx_crud_insert must match default value which is 0.
57 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_insert", Value, 1] = 0
58 --source include/assert.inc
59
60 --let $assert_text= No connections were made, Mysqlx_crud_create_view must match default value which is 0.
61 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_create_view", Value, 1] = 0
62 --source include/assert.inc
63
64 --let $assert_text= No connections were made, Mysqlx_crud_modify_view must match default value which is 0.
65 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_modify_view", Value, 1] = 0
66 --source include/assert.inc
67
68 --let $assert_text= No connections were made, Mysqlx_crud_drop_view must match default value which is 0.
69 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_drop_view", Value, 1] = 0
70 --source include/assert.inc
71
72 --let $assert_text= No connections were made, Mysqlx_expect_open must match default value which is 0.
73 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_expect_open", Value, 1] = 0
74 --source include/assert.inc
75
76 --let $assert_text= No connections were made, Mysqlx_expect_close must match default value which is 0.
77 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_expect_close", Value, 1] = 0
78 --source include/assert.inc
79
80 --let $assert_text= No connections were made, Mysqlx_stmt_create_collection must match default value which is 0.
81 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_create_collection", Value, 1] = 0
82 --source include/assert.inc
83
84 --let $assert_text= No connections were made, Mysqlx_stmt_modify_collection_options must match default value which is 0.
85 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_modify_collection_options", Value, 1] = 0
86 --source include/assert.inc
87
88 --let $assert_text= No connections were made, Mysqlx_stmt_get_collection_options must match default value which is 0.
89 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_get_collection_options", Value, 1] = 0
90 --source include/assert.inc
91
92 --let $assert_text= No connections were made, Mysqlx_stmt_create_collection_index must match default value which is 0.
93 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_create_collection_index", Value, 1] = 0
94 --source include/assert.inc
95
96 --let $assert_text= No connections were made, Mysqlx_stmt_drop_collection must match default value which is 0.
97 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_drop_collection", Value, 1] = 0
98 --source include/assert.inc
99
100 --let $assert_text= No connections were made, Mysqlx_stmt_ensure_collection must match default value which is 0.
101 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_ensure_collection", Value, 1] = 0
102 --source include/assert.inc
103
104 --let $assert_text= No connections were made, Mysqlx_stmt_drop_collection_index must match default value which is 0.
105 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_drop_collection_index", Value, 1] = 0
106 --source include/assert.inc
107
108 --let $assert_text= No connections were made, Mysqlx_stmt_list_objects must match default value which is 0.
109 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_list_objects", Value, 1] = 0
110 --source include/assert.inc
111
112 --let $assert_text= No connections were made, Mysqlx_stmt_enable_notices must match default value which is 0.
113 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_enable_notices", Value, 1] = 0
114 --source include/assert.inc
115
116 --let $assert_text= No connections were made, Mysqlx_stmt_disable_notices must match default value which is 0.
117 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_disable_notices", Value, 1] = 0
118 --source include/assert.inc
119
120 --let $assert_text= No connections were made, Mysqlx_stmt_list_notices must match default value which is 0.
121 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_list_notices", Value, 1] = 0
122 --source include/assert.inc
123
124 --let $assert_text= No connections were made, Mysqlx_stmt_list_clients must match default value which is 0.
125 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_list_clients", Value, 1] = 0
126 --source include/assert.inc
127
128 --let $assert_text= No connections were made, Mysqlx_stmt_kill_client must match default value which is 0.
129 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_kill_client", Value, 1] = 0
130 --source include/assert.inc
131
132 --let $assert_text= No connections were made, Mysqlx_stmt_ping must match default value which is 0.
133 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_ping", Value, 1] = 0
134 --source include/assert.inc
135
136 --let $assert_text= No connections were made, Mysqlx_bytes_sent must match default value which is 0.
137 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_bytes_sent", Value, 1] = 0
138 --source include/assert.inc
139
140 --let $assert_text= No connections were made, Mysqlx_bytes_sent_compressed_payload must match default value which is 0.
141 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_bytes_sent_compressed_payload", Value, 1] = 0
142 --source include/assert.inc
143
144 --let $assert_text= No connections were made, Mysqlx_bytes_sent_uncompressed_frame must match default value which is 0.
145 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_bytes_sent_uncompressed_frame", Value, 1] = 0
146 --source include/assert.inc
147
148 --let $assert_text= No connections were made, Mysqlx_bytes_received must match default value which is 0.
149 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_bytes_received", Value, 1] = 0
150 --source include/assert.inc
151
152 --let $assert_text= No connections were made, Mysqlx_bytes_received_uncompressed_frame must match default value which is 0.
153 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_bytes_received_uncompressed_frame", Value, 1] = 0
154 --source include/assert.inc
155
156 --let $assert_text= No connections were made, Mysqlx_bytes_received_compressed_payload must match default value which is 0.
157 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_bytes_received_compressed_payload", Value, 1] = 0
158 --source include/assert.inc
159
160 --let $assert_text= No connections were made, Mysqlx_errors_sent must match default value which is 0.
161 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_errors_sent", Value, 1] = 0
162 --source include/assert.inc
163
164 --let $assert_text= No connections were made, Mysqlx_errors_unknown_message_type must match default value which is 0.
165 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_errors_unknown_message_type", Value, 1] = 0
166 --source include/assert.inc
167
168 --let $assert_text= No connections were made, Mysqlx_rows_sent must match default value which is 0.
169 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_rows_sent", Value, 1] = 0
170 --source include/assert.inc
171
172 --let $assert_text= No connections were made, Mysqlx_notice_warning_sent must match default value which is 0.
173 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_notice_warning_sent", Value, 1] = 0
174 --source include/assert.inc
175
176 --let $assert_text= No connections were made, Mysqlx_notice_other_sent must match default value which is 0.
177 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_notice_other_sent", Value, 1] = 0
178 --source include/assert.inc
179
180 --let $assert_text= No connections were made, Mysqlx_notice_global_sent must match default value which is 0.
181 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_notice_global_sent", Value, 1] = 0
182 --source include/assert.inc
183
184 --let $assert_text= No connections were made, Mysqlx_notified_by_group_replication must match default value which is 0.
185 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_notified_by_group_replication", Value, 1] = 0
186 --source include/assert.inc
187
188 --let $assert_text= No connections were made, Mysqlx_sessions must match default value which is 0.
189 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_sessions", Value, 1] = 0
190 --source include/assert.inc
191
192 --let $assert_text= No connections were made, Mysqlx_sessions_closed must match default value which is 0.
193 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_sessions_closed", Value, 1] = 0
194 --source include/assert.inc
195
196 --let $assert_text= No connections were made, Mysqlx_sessions_fatal_error must match default value which is 0.
197 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_sessions_fatal_error", Value, 1] = 0
198 --source include/assert.inc
199
200 --let $assert_text= No init error occurred, Mysqlx_init_error must match default value which is 0.
201 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_init_error", Value, 1] = 0
202 --source include/assert.inc
203
204 --let $assert_text= No connections were made, Mysqlx_sessions_accepted must match default value which is 0.
205 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_sessions_accepted", Value, 1] = 0
206 --source include/assert.inc
207
208 --let $assert_text= No connections were made, Mysqlx_sessions_rejected must match default value which is 0.
209 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_sessions_rejected", Value, 1] = 0
210 --source include/assert.inc
211
212 --let $assert_text= No connections were made, Mysqlx_sessions_killed must match default value which is 0.
213 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_sessions_killed", Value, 1] = 0
214 --source include/assert.inc
215
216 --let $assert_text= No connections were made, Mysqlx_connections_closed must match default value which is 0.
217 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_connections_closed", Value, 1] = 0
218 --source include/assert.inc
219
220 --let $assert_text= No connections were made, Mysqlx_connections_accepted must match default value which is 0.
221 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_connections_accepted", Value, 1] = 0
222 --source include/assert.inc
223
224 --let $assert_text= No connections were made, Mysqlx_connections_rejected must match default value which is 0.
225 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_connections_rejected", Value, 1] = 0
226 --source include/assert.inc
227
228 --let $assert_text= No accept errors were triggered, Mysqlx_connection_accept_errors must match default value which is 0.
229 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_connection_accept_errors", Value, 1] = 0
230 --source include/assert.inc
231
232 --let $assert_text= No connections errors were simulated, Mysqlx_connection_errors must match default value which is 0.
233 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_connection_errors", Value, 1] = 0
234 --source include/assert.inc
235
236 --let $assert_text= XPlugin run two threads in default, Mysqlx_worker_threads should be set to 2.
237 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_worker_threads", Value, 1] = 2
238 --source include/assert.inc
239
240 --let $assert_text= Mysqlx_worker_threads_active must match default value which is 0.
241 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_worker_threads_active", Value, 1] = 0
242 --source include/assert.inc
243
244 --let $assert_text= Mysqlx_socket must match value set by MTR or UNDEFINED on windows
245 --let $assert_cond= [select VARIABLE_VALUE="$mtr_overwrited_socket" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_socket", Value, 1] = 1
246 --source include/assert.inc
247
248 --let $assert_text= SSL not configured, Mysqlx_ssl_active should be empty
249 --let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_active", Value, 1] = 1
250 --source include/assert.inc
251
252 --let $assert_text= SSL not configured, Mysqlx_ssl_cipher_list should be empty
253 --let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_cipher_list", Value, 1] = 1
254 --source include/assert.inc
255
256 --let $assert_text= SSL not configured, Mysqlx_ssl_cipher should be empty
257 --let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_cipher", Value, 1] = 1
258 --source include/assert.inc
259
260 --let $assert_text= SSL not configured, Mysqlx_ssl_version should be empty
261 --let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_version", Value, 1] = 1
262 --source include/assert.inc
263
264 --let $assert_text= SSL not configured, Mysqlx_ssl_verify_depth should be empty
265 --let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_verify_depth", Value, 1] = 1
266 --source include/assert.inc
267
268 --let $assert_text= SSL not configured, Mysqlx_ssl_verify_mode should be empty
269 --let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_verify_mode", Value, 1] = 1
270 --source include/assert.inc
271
272 --let $assert_text= Mysqlx_ssl_ctx_verify_depth must match default value which is 0.
273 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_ssl_ctx_verify_depth", Value, 1] = 0
274 --source include/assert.inc
275
276 --let $assert_text= Mysqlx_ssl_ctx_verify_mode must match default value which is 0.
277 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_ssl_ctx_verify_mode", Value, 1] = 0
278 --source include/assert.inc
279
280 --let $assert_text= No connections were made, Mysqlx_ssl_finished_accepts must match default value which is 0.
281 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_ssl_finished_accepts", Value, 1] = 0
282 --source include/assert.inc
283
284 --let $assert_text= No connections were made, Mysqlx_ssl_accepts must match default value which is 0.
285 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_ssl_accepts", Value, 1] = 0
286 --source include/assert.inc
287
288 --let $assert_text= Mysqlx_ssl_server_not_after should be empty
289 --let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_server_not_after", Value, 1] = 1
290 --source include/assert.inc
291
292 --let $assert_text= Mysqlx_ssl_active should be empty
293 --let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_server_not_before", Value, 1] = 1
294 --source include/assert.inc
295
296 --let $assert_text= Mysqlx_address must match default value which is "::"
297 --let $assert_cond= [select VARIABLE_VALUE="::" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_address", Value, 1] = 1
298 --source include/assert.inc
299
300 --let $assert_text= No connections were made, Mysqlx_aborted_clients must match default value which is 0.
301 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_aborted_clients", Value, 1] = 0
302 --source include/assert.inc
303
304 --let $assert_text= No connections were made, Mysqlx_prep_prepare must match default value which is 0.
305 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_prep_prepare", Value, 1] = 0
306 --source include/assert.inc
307
308 --let $assert_text= No connections were made, Mysqlx_prep_execute must match default value which is 0.
309 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_prep_execute", Value, 1] = 0
310 --source include/assert.inc
311
312 --let $assert_text= No connections were made, Mysqlx_prep_deallocate must match default value which is 0.
313 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_prep_deallocate", Value, 1] = 0
314 --source include/assert.inc
315
316 --let $assert_text= No connections were made, Mysqlx_cursor_open must match default value which is 0.
317 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_cursor_open", Value, 1] = 0
318 --source include/assert.inc
319
320 --let $assert_text= No connections were made, Mysqlx_cursor_close must match default value which is 0.
321 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_cursor_close", Value, 1] = 0
322 --source include/assert.inc
323
324 --let $assert_text= No connections were made, Mysqlx_cursor_fetch must match default value which is 0.
325 --let $assert_cond= [SHOW STATUS LIKE "Mysqlx_cursor_fetch", Value, 1] = 0
326 --source include/assert.inc
327
328 --let $assert_text= No connections were made, Mysqlx_compression_algorithm must match default value which is ''.
329 --let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_compression_algorithm", Value, 1] = 1
330 --source include/assert.inc
331
332 --let $assert_text= No connections were made, Mysqlx_compression_level must match default value which is ''.
333 --let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_compression_level", Value, 1] = 1
334 --source include/assert.inc