Debian Codegraph @

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

raw
1 select @@global.innodb_write_io_threads;
2 @@global.innodb_write_io_threads
3 2
4 select @@session.innodb_write_io_threads;
5 ERROR HY000: Variable 'innodb_write_io_threads' is a GLOBAL variable
6 show global variables like 'innodb_write_io_threads';
7 Variable_name Value
8 innodb_write_io_threads 2
9 show session variables like 'innodb_write_io_threads';
10 Variable_name Value
11 innodb_write_io_threads 2
12 select * from information_schema.global_variables where variable_name='innodb_write_io_threads';
13 VARIABLE_NAME VARIABLE_VALUE
14 INNODB_WRITE_IO_THREADS 2
15 select * from information_schema.session_variables where variable_name='innodb_write_io_threads';
16 VARIABLE_NAME VARIABLE_VALUE
17 INNODB_WRITE_IO_THREADS 2
18 select @@innodb_write_io_threads into @n;
19 set global innodb_write_io_threads=1;
20 select @@innodb_write_io_threads;
21 @@innodb_write_io_threads
22 2
23 set global innodb_write_io_threads=64;
24 select @@innodb_write_io_threads;
25 @@innodb_write_io_threads
26 64
27 set global innodb_write_io_threads=@n;