Debian Codegraph @

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

raw
1 --source include/xplugin_preamble.inc
2 --source include/xplugin_create_user.inc
3
4 SET GLOBAL Mysqlx_min_worker_threads= 50;
5 SET GLOBAL Mysqlx_max_connections= 200;
6 SET GLOBAL Mysqlx_idle_worker_thread_timeout= 2;
7
8 --write_file $MYSQL_TMP_DIR/worker_threads.xpl
9
10 -->repeat 100 %I%
11 -->newsession con %I% x_root
12 -->endrepeat
13 -->abort
14 EOF
15
16 --error 2
17 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/worker_threads.xpl 2>&1
18
19 let $wait_condition=
20 SELECT VARIABLE_VALUE <51 FROM performance_schema.global_status gs where VARIABLE_NAME = 'mysqlx_worker_threads';
21 --source include/wait_condition.inc
22
23 SHOW STATUS like 'mysqlx_worker_threads';
24
25 ## Cleanup
26 SET GLOBAL Mysqlx_min_worker_threads= DEFAULT;
27 SET GLOBAL Mysqlx_max_connections= DEFAULT;
28 SET GLOBAL Mysqlx_idle_worker_thread_timeout= DEFAULT;
29 --source ../include/xplugin_cleanup.inc