Debian Codegraph @

mysql-test/suite/sys_vars/t/mysqlx_min_worker_threads_basic.test

raw
1 # Variable: mysqlx_min_worker_threads
2 # Default : 10
3 # Scope : GLOBAL
4 # Dynamic : Yes
5
6 SET @mysqlx_min_worker_threads_sav= @@global.mysqlx_min_worker_threads;
7
8 ## Valid cases
9 #minimum number of worker threads the X plugin will use for handling client requests.
10 #The maximum is limited implicitly by Mysqlx_max_connections.
11 # Truncated incorrect mysqlx_min_worker_threads value: '150'
12 SET GLOBAL mysqlx_min_worker_threads=150;
13 SET @@global.mysqlx_min_worker_threads=15;
14 show variables like 'mysqlx_min_worker_threads';
15
16 ## Invalid cases
17 --error ER_GLOBAL_VARIABLE
18 SET mysqlx_min_worker_threads=15;
19 --error ER_GLOBAL_VARIABLE
20 SET @@local.mysqlx_min_worker_threads=15;
21 --error ER_GLOBAL_VARIABLE
22 SET @@mysqlx_min_worker_threads=15;
23 --error ER_GLOBAL_VARIABLE
24 SET @@session.mysqlx_min_worker_threads=15;
25 --error ER_GLOBAL_VARIABLE
26 SET SESSION mysqlx_min_worker_threads=15;
27
28 SET @@global.mysqlx_min_worker_threads=0;
29 SET @@global.mysqlx_min_worker_threads=-4324;
30
31 # It will set value to 100
32 SET GLOBAL mysqlx_min_worker_threads=+23766;
33 --error ER_WRONG_TYPE_FOR_VAR
34 SET GLOBAL mysqlx_min_worker_threads='USDSI75u';
35
36 show variables like 'mysqlx_min_worker_threads';
37 SET GLOBAL mysqlx_min_worker_threads=10;
38
39 SET @@global.mysqlx_min_worker_threads= @mysqlx_min_worker_threads_sav;