Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_write_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 --source include/have_innodb.inc
7
8 #
9 # show the global and session values;
10 #
11 select @@global.innodb_write_io_threads;
12 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
13 select @@session.innodb_write_io_threads;
14 show global variables like 'innodb_write_io_threads';
15 show session variables like 'innodb_write_io_threads';
16 --disable_warnings
17 select * from information_schema.global_variables where variable_name='innodb_write_io_threads';
18 select * from information_schema.session_variables where variable_name='innodb_write_io_threads';
19 --enable_warnings
20
21 #
22 # show that it's not read-only
23 #
24 --disable_cursor_protocol
25 select @@innodb_write_io_threads into @n;
26 --enable_cursor_protocol
27 --disable_warnings
28 set global innodb_write_io_threads=1;
29 --enable_warnings
30 select @@innodb_write_io_threads;
31 --disable_warnings
32 set global innodb_write_io_threads=64;
33 --enable_warnings
34 select @@innodb_write_io_threads;
35 --disable_warnings
36 set global innodb_write_io_threads=@n;
37 --enable_warnings
38