Debian Codegraph @

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

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