Debian Codegraph @

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

raw
1 ## Preamle
2 --source include/xplugin_preamble.inc
3
4 ## Test case
5
6
7 # Please update the test case when the variable count changes
8 # add/remove variable
9 let $wait_condition=
10 SELECT COUNT(*)=29 FROM performance_schema.global_variables where variable_name like "Mysqlx_%";
11 --source include/wait_condition_or_abort.inc
12
13 # Values for variables that were overwritten by MTR
14 --let $mtr_overwrited_port= $MASTER_X_MYPORT
15 --let $mtr_overwrited_socket= $MASTER_X_MYSOCK
16
17
18 ## Verify default value of system variables
19 --let $assert_text= Mysqlx_port must match value set by MTR
20 --let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_port", Value, 1] = $mtr_overwrited_port
21 --source include/assert.inc
22
23 --let $assert_text= Mysqlx_socket must match value set by MTR
24 --let $assert_cond= [select VARIABLE_VALUE="$mtr_overwrited_socket" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_socket", Value, 1] = 1
25 --source include/assert.inc
26
27 --let $assert_text= Mysqlx_max_connections must be 1 connection, default values
28 --let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_max_connections", Value, 1] = 100
29 --source include/assert.inc
30
31 --let $assert_text= Mysqlx_min_worker_threads must be 2 workers, default values
32 --let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_min_worker_threads", Value, 1] = 2
33 --source include/assert.inc
34
35 --let $assert_text= Mysqlx_idle_worker_thread_timeout must be 60 seconds, default values
36 --let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_idle_worker_thread_timeout", Value, 1] = 60
37 --source include/assert.inc
38
39 --let $assert_text= Mysqlx_max_allowed_packet must be 64M, the default value
40 --let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_max_allowed_packet", Value, 1] = 67108864
41 --source include/assert.inc
42
43 --let $assert_text= Mysqlx_connect_timeout must be 30 seconds, the default value
44 --let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_connect_timeout", Value, 1] = 30
45 --source include/assert.inc
46
47 --let $assert_text= Mysqlx_wait_timeout must be 28800 seconds, the default value
48 --let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_wait_timeout", Value, 1] = 28800
49 --source include/assert.inc
50
51 --let $assert_text= Mysqlx_interactive_timeout must be 28800 seconds, the default value
52 --let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_interactive_timeout", Value, 1] = 28800
53 --source include/assert.inc
54
55 --let $assert_text= Mysqlx_read_timeout must be 30 seconds, the default value
56 --let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_read_timeout", Value, 1] = 30
57 --source include/assert.inc
58
59 --let $assert_text= Mysqlx_write_timeout must be 60 seconds, the default value
60 --let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_write_timeout", Value, 1] = 60
61 --source include/assert.inc
62
63 --let $assert_text= Mysqlx_ssl_key must be empty, the default value
64 --let $assert_cond= [select VARIABLE_VALUE like "" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_ssl_key", Value, 1] = 1
65 --source include/assert.inc
66
67 --let $assert_text= Mysqlx_ssl_ca must be empty, the default value
68 --let $assert_cond= [select VARIABLE_VALUE like "" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_ssl_ca", Value, 1] = 1
69 --source include/assert.inc
70
71 --let $assert_text= Mysqlx_ssl_capath must be empty, the default value
72 --let $assert_cond= [select VARIABLE_VALUE like "" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_ssl_capath", Value, 1] = 1
73 --source include/assert.inc
74
75 --let $assert_text= Mysqlx_ssl_cert must be empty, the default value
76 --let $assert_cond= [select VARIABLE_VALUE like "" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_ssl_cert", Value, 1] = 1
77 --source include/assert.inc
78
79 --let $assert_text= Mysqlx_ssl_cipher must be empty, the default value
80 --let $assert_cond= [select VARIABLE_VALUE like "" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_ssl_cipher", Value, 1] = 1
81 --source include/assert.inc
82
83 --let $assert_text= Mysqlx_ssl_crl must be empty, the default value
84 --let $assert_cond= [select VARIABLE_VALUE like "" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_ssl_crl", Value, 1] = 1
85 --source include/assert.inc
86
87 --let $assert_text= Mysqlx_ssl_crlpath must be empty, the default value
88 --let $assert_cond= [select VARIABLE_VALUE like "" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_ssl_crlpath", Value, 1] = 1
89 --source include/assert.inc
90
91 --let $assert_text= Mysqlx_bind_address must be "*", the default value
92 --let $assert_cond= [select VARIABLE_VALUE like "*" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_bind_address", Value, 1] = 1
93 --source include/assert.inc
94
95 --let $assert_text= Mysqlx_port_open_timeout must be 0 seconds, the default value
96 --let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_port_open_timeout", Value, 1] = 0
97 --source include/assert.inc
98
99 --let $assert_text= Mysqlx_document_id_unique_prefix must be 0, the default value
100 --let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_document_id_unique_prefix", Value, 1] = 0
101 --source include/assert.inc
102
103 --let $assert_text= Mysqlx_enable_hello_notice must be 0, the default value
104 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE "Mysqlx_enable_hello_notice", Value, 1]" = "ON"
105 --source include/assert.inc
106
107 --let $assert_text= Mysqlx_compression_algorithms must be DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM, the default value
108 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE "Mysqlx_compression_algorithms", Value, 1]" = "DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM"
109 --source include/assert.inc
110
111 --let $assert_text= Mysqlx_deflate_default_compression_level must be 3, the default value
112 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE "Mysqlx_deflate_default_compression_level", Value, 1]" = 3
113 --source include/assert.inc
114
115 --let $assert_text= Mysqlx_lz4_default_compression_level must be 2, the default value
116 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE "Mysqlx_lz4_default_compression_level", Value, 1]" = 2
117 --source include/assert.inc
118
119 --let $assert_text= Mysqlx_zstd_default_compression_level must be 3, the default value
120 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE "Mysqlx_zstd_default_compression_level", Value, 1]" = 3
121 --source include/assert.inc
122
123 --let $assert_text= Mysqlx_deflate_max_client_compression_level must be 5, the default value
124 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE "Mysqlx_deflate_max_client_compression_level", Value, 1]" = 5
125 --source include/assert.inc
126
127 --let $assert_text= Mysqlx_lz4_max_client_compression_level must be 8, the default value
128 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE "Mysqlx_lz4_max_client_compression_level", Value, 1]" = 8
129 --source include/assert.inc
130
131 --let $assert_text= Mysqlx_zstd_max_client_compression_level must be 11 or 3, the default value
132 --let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE "Mysqlx_zstd_max_client_compression_level", Value, 1]" IN (11,3)
133 --source include/assert.inc
134