Debian Codegraph @

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

raw
1
2 SET @start_global_value = @@global.innodb_parallel_read_threads;
3 SELECT @start_global_value;
4
5 #
6 # exists as global and session
7 #
8 select @@global.innodb_parallel_read_threads in (2, 64);
9 select @@global.innodb_parallel_read_threads;
10 select @@session.innodb_parallel_read_threads;
11 show global variables like 'innodb_parallel_read_threads';
12 show session variables like 'innodb_parallel_read_threads';
13 --disable_warnings
14 select * from performance_schema.global_variables where variable_name='innodb_parallel_read_threads';
15 select * from performance_schema.session_variables where variable_name='innodb_parallel_read_threads';
16 --enable_warnings
17
18 #
19 # show that it's writable
20 #
21 set global innodb_parallel_read_threads=3;
22 select @@global.innodb_parallel_read_threads;
23 --disable_warnings
24 select * from performance_schema.global_variables where variable_name='innodb_parallel_read_threads';
25 select * from performance_schema.session_variables where variable_name='innodb_parallel_read_threads';
26 --enable_warnings
27 set @@global.innodb_parallel_read_threads=2;
28 select @@global.innodb_parallel_read_threads;
29 --disable_warnings
30 select * from performance_schema.global_variables where variable_name='innodb_parallel_read_threads';
31 select * from performance_schema.session_variables where variable_name='innodb_parallel_read_threads';
32 --enable_warnings
33 set global innodb_parallel_read_threads=0;
34 select @@global.innodb_parallel_read_threads;
35 --disable_warnings
36 select * from performance_schema.global_variables where variable_name='innodb_parallel_read_threads';
37 select * from performance_schema.session_variables where variable_name='innodb_parallel_read_threads';
38 --enable_warnings
39 set @@global.innodb_parallel_read_threads=3;
40 select @@global.innodb_parallel_read_threads;
41 --disable_warnings
42 select * from performance_schema.global_variables where variable_name='innodb_parallel_read_threads';
43 select * from performance_schema.session_variables where variable_name='innodb_parallel_read_threads';
44 --enable_warnings
45 set session innodb_parallel_read_threads=2;
46 set @@session.innodb_parallel_read_threads=3;
47
48 #
49 # incorrect types
50 #
51 --error ER_WRONG_TYPE_FOR_VAR
52 set global innodb_parallel_read_threads=1.1;
53 --error ER_WRONG_TYPE_FOR_VAR
54 set global innodb_parallel_read_threads=1e1;
55 --echo NOTE: The following should fail with ER_WRONG_VALUE_FOR_VAR (BUG#50643)
56 set global innodb_parallel_read_threads=-3;
57 select @@global.innodb_parallel_read_threads;
58 --disable_warnings
59 select * from performance_schema.global_variables where variable_name='innodb_parallel_read_threads';
60 select * from performance_schema.session_variables where variable_name='innodb_parallel_read_threads';
61 --enable_warnings
62 --error ER_WRONG_TYPE_FOR_VAR
63 set global innodb_parallel_read_threads='AUTO';
64
65 #
66 # Cleanup
67 #
68
69 SET @@global.innodb_parallel_read_threads = @start_global_value;
70 SELECT @@global.innodb_parallel_read_threads;