Debian Codegraph @

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

raw
1
2 #
3 # 2010-01-27 OBN - Added (this variable is also covered in innodb_file_io_threads_basic.test)
4 #
5
6
7 #
8 # show the global and session values;
9 #
10 select @@global.innodb_read_io_threads;
11 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
12 select @@session.innodb_read_io_threads;
13 show global variables like 'innodb_read_io_threads';
14 show session variables like 'innodb_read_io_threads';
15 --disable_warnings
16 select * from performance_schema.global_variables where variable_name='innodb_read_io_threads';
17 select * from performance_schema.session_variables where variable_name='innodb_read_io_threads';
18 --enable_warnings
19
20 #
21 # show that it's read-only
22 #
23 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
24 set global innodb_read_io_threads=1;
25 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
26 set session innodb_read_io_threads=1;
27