Debian Codegraph @

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

raw
1 --source include/not_embedded.inc
2
3 SET @save_slave_parallel_threads= @@GLOBAL.slave_parallel_threads;
4
5 # Check that we don't spawn worker threads at server startup, when no
6 # slave is configured (MDEV-5289).
7 SELECT IF(COUNT(*) < 20, "OK", CONCAT("Found too many system user processes: ", COUNT(*))) AS ProcessCheck FROM information_schema.processlist WHERE user = "system user";
8
9 SELECT @@GLOBAL.slave_parallel_threads as 'must be 20 because of .cnf';
10 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
11 SELECT @@SESSION.slave_parallel_threads as 'no session var';
12
13 SET GLOBAL slave_parallel_threads= 0;
14 SET GLOBAL slave_parallel_threads= DEFAULT;
15 SELECT @@GLOBAL.slave_parallel_threads as 'must be 0 because of default';
16 SET GLOBAL slave_parallel_threads= 10;
17 SELECT @@GLOBAL.slave_parallel_threads;
18 # Check that we don't spawn worker threads when no slave is started.
19 SELECT IF(COUNT(*) < 10, "OK", CONCAT("Found too many system user processes: ", COUNT(*))) AS ProcessCheck FROM information_schema.processlist WHERE user = "system user";
20
21 SET GLOBAL slave_parallel_threads = @save_slave_parallel_threads;