106 lines
5.3 KiB
Plaintext
106 lines
5.3 KiB
Plaintext
## Preamle
|
|
--source include/xplugin_preamble.inc
|
|
|
|
## Test case
|
|
|
|
|
|
# Please update the test case when the variable count changes
|
|
# add/remove variable
|
|
let $wait_condition=
|
|
SELECT COUNT(*)=22 FROM performance_schema.global_variables where variable_name like "Mysqlx_%";
|
|
--source include/wait_condition_or_abort.inc
|
|
|
|
# Values for variables that were overwritten by MTR
|
|
--let $mtr_overwrited_port= $MASTER_X_MYPORT
|
|
--let $mtr_overwrited_socket= $MASTER_X_MYSOCK
|
|
|
|
|
|
## Verify default value of system variables
|
|
--let $assert_text= Mysqlx_port must match value set by MTR
|
|
--let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_port", Value, 1] = $mtr_overwrited_port
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_socket must match value set by MTR
|
|
--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
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_max_connections must be 1 connection, default values
|
|
--let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_max_connections", Value, 1] = 100
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_min_worker_threads must be 2 workers, default values
|
|
--let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_min_worker_threads", Value, 1] = 2
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_idle_worker_thread_timeout must be 60 seconds, default values
|
|
--let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_idle_worker_thread_timeout", Value, 1] = 60
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_max_allowed_packet must be 64M, the default value
|
|
--let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_max_allowed_packet", Value, 1] = 67108864
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_connect_timeout must be 30 seconds, the default value
|
|
--let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_connect_timeout", Value, 1] = 30
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_wait_timeout must be 28800 seconds, the default value
|
|
--let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_wait_timeout", Value, 1] = 28800
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_interactive_timeout must be 28800 seconds, the default value
|
|
--let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_interactive_timeout", Value, 1] = 28800
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_read_timeout must be 30 seconds, the default value
|
|
--let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_read_timeout", Value, 1] = 30
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_write_timeout must be 60 seconds, the default value
|
|
--let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_write_timeout", Value, 1] = 60
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_ssl_key must be empty, the default value
|
|
--let $assert_cond= [select VARIABLE_VALUE like "" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_ssl_key", Value, 1] = 1
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_ssl_ca must be empty, the default value
|
|
--let $assert_cond= [select VARIABLE_VALUE like "" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_ssl_ca", Value, 1] = 1
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_ssl_capath must be empty, the default value
|
|
--let $assert_cond= [select VARIABLE_VALUE like "" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_ssl_capath", Value, 1] = 1
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_ssl_cert must be empty, the default value
|
|
--let $assert_cond= [select VARIABLE_VALUE like "" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_ssl_cert", Value, 1] = 1
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_ssl_cipher must be empty, the default value
|
|
--let $assert_cond= [select VARIABLE_VALUE like "" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_ssl_cipher", Value, 1] = 1
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_ssl_crl must be empty, the default value
|
|
--let $assert_cond= [select VARIABLE_VALUE like "" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_ssl_crl", Value, 1] = 1
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_ssl_crlpath must be empty, the default value
|
|
--let $assert_cond= [select VARIABLE_VALUE like "" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_ssl_crlpath", Value, 1] = 1
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_bind_address must be "*", the default value
|
|
--let $assert_cond= [select VARIABLE_VALUE like "*" as Value from performance_schema.global_variables WHERE VARIABLE_NAME like "Mysqlx_bind_address", Value, 1] = 1
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_port_open_timeout must be 0 seconds, the default value
|
|
--let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_port_open_timeout", Value, 1] = 0
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_document_id_unique_prefix must be 0, the default value
|
|
--let $assert_cond= [SHOW GLOBAL VARIABLES LIKE "Mysqlx_document_id_unique_prefix", Value, 1] = 0
|
|
--source include/assert.inc
|
|
|
|
--let $assert_text= Mysqlx_enable_hello_notice must be 0, the default value
|
|
--let $assert_cond= "[SHOW GLOBAL VARIABLES LIKE "Mysqlx_enable_hello_notice", Value, 1]" = "ON"
|
|
--source include/assert.inc
|