3
# 2010-01-27 OBN - Added (this variable is also covered in innodb_file_io_threads_basic.test)
6
--source include/have_innodb.inc
9
# show the global and session values;
11
select @@global.innodb_read_io_threads;
12
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
13
select @@session.innodb_read_io_threads;
14
show global variables like 'innodb_read_io_threads';
15
show session variables like 'innodb_read_io_threads';
16
select * from information_schema.global_variables where variable_name='innodb_read_io_threads';
17
select * from information_schema.session_variables where variable_name='innodb_read_io_threads';
20
# show that it's read-only
22
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
23
set global innodb_read_io_threads=1;
24
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
25
set session innodb_read_io_threads=1;