Debian Codegraph @

mysql-test/suite/sys_vars/r/slave_parallel_threads_basic.result

raw
1 SET @save_slave_parallel_threads= @@GLOBAL.slave_parallel_threads;
2 SELECT IF(COUNT(*) < 20, "OK", CONCAT("Found too many system user processes: ", COUNT(*))) AS ProcessCheck FROM information_schema.processlist WHERE user = "system user";
3 ProcessCheck
4 OK
5 SELECT @@GLOBAL.slave_parallel_threads as 'must be 20 because of .cnf';
6 must be 20 because of .cnf
7 20
8 SELECT @@SESSION.slave_parallel_threads as 'no session var';
9 ERROR HY000: Variable 'slave_parallel_threads' is a GLOBAL variable
10 SET GLOBAL slave_parallel_threads= 0;
11 SET GLOBAL slave_parallel_threads= DEFAULT;
12 SELECT @@GLOBAL.slave_parallel_threads as 'must be 0 because of default';
13 must be 0 because of default
14 0
15 SET GLOBAL slave_parallel_threads= 10;
16 SELECT @@GLOBAL.slave_parallel_threads;
17 @@GLOBAL.slave_parallel_threads
18 10
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 ProcessCheck
21 OK
22 SET GLOBAL slave_parallel_threads = @save_slave_parallel_threads;