94 lines
2.4 KiB
Plaintext
94 lines
2.4 KiB
Plaintext
#
|
|
# Tests for setting the global and session value for net_read_timeout
|
|
#
|
|
# Get initial values
|
|
SET @start_global_read_value = @@global.net_read_timeout;
|
|
SELECT @start_global_read_value;
|
|
@start_global_read_value
|
|
30
|
|
SET @start_session_read_value = @@session.net_read_timeout;
|
|
SELECT @start_session_read_value;
|
|
@start_session_read_value
|
|
30
|
|
# Try to change the values
|
|
RUN SET @@global.net_read_timeout = 100
|
|
|
|
0 rows affected
|
|
RUN SET @@session.net_read_timeout = 200
|
|
While executing SET @@session.net_read_timeout = 200:
|
|
Got expected error: Command not supported by pluggable protocols (code 3130)
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
# Get after values
|
|
SELECT @@global.net_read_timeout;
|
|
@@global.net_read_timeout
|
|
100
|
|
SELECT @@session.net_read_timeout;
|
|
@@session.net_read_timeout
|
|
30
|
|
SET @@global.net_read_timeout = @start_global_read_value;
|
|
#
|
|
# Tests for setting the global and session value for net_write_timeout
|
|
#
|
|
# Get initial values
|
|
SET @start_global_write_value = @@global.net_write_timeout;
|
|
SELECT @start_global_write_value;
|
|
@start_global_write_value
|
|
60
|
|
SET @start_session_write_value = @@session.net_write_timeout;
|
|
SELECT @start_session_write_value;
|
|
@start_session_write_value
|
|
60
|
|
# Try to change the values
|
|
RUN SET @@global.net_write_timeout = 100
|
|
|
|
0 rows affected
|
|
RUN SET @@session.net_write_timeout = 200
|
|
While executing SET @@session.net_write_timeout = 200:
|
|
Got expected error: Command not supported by pluggable protocols (code 3130)
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
# Get after values
|
|
SELECT @@global.net_write_timeout;
|
|
@@global.net_write_timeout
|
|
100
|
|
SELECT @@session.net_write_timeout;
|
|
@@session.net_write_timeout
|
|
60
|
|
SET @@global.net_write_timeout = @start_global_write_value;
|
|
#
|
|
# Tests for setting the global and session value for net_retry_count
|
|
#
|
|
# Get initial values
|
|
SET @start_global_retry_value = @@global.net_retry_count;
|
|
SELECT @start_global_retry_value;
|
|
@start_global_retry_value
|
|
10
|
|
SET @start_session_retry_value = @@session.net_retry_count;
|
|
SELECT @start_session_retry_value;
|
|
@start_session_retry_value
|
|
10
|
|
# Try to change the values
|
|
RUN SET @@global.net_retry_count = 100
|
|
|
|
0 rows affected
|
|
RUN SET @@session.net_retry_count = 200
|
|
While executing SET @@session.net_retry_count = 200:
|
|
Got expected error: Command not supported by pluggable protocols (code 3130)
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
# Get after values
|
|
SELECT @@global.net_retry_count;
|
|
@@global.net_retry_count
|
|
100
|
|
SELECT @@session.net_retry_count;
|
|
@@session.net_retry_count
|
|
10
|
|
SET @@global.net_retry_count = @start_global_retry_value;
|