Debian Codegraph @

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

raw
1 '#---------------------BS_STVARS_027_01----------------------#'
2 SELECT COUNT(@@GLOBAL.innodb_read_io_threads);
3 COUNT(@@GLOBAL.innodb_read_io_threads)
4 1
5 1 Expected
6 SELECT COUNT(@@GLOBAL.innodb_write_io_threads);
7 COUNT(@@GLOBAL.innodb_write_io_threads)
8 1
9 1 Expected
10 '#---------------------BS_STVARS_027_02----------------------#'
11 SET @@GLOBAL.innodb_read_io_threads=1;
12 ERROR HY000: Variable 'innodb_read_io_threads' is a read only variable
13 Expected error 'Read only variable'
14 SELECT COUNT(@@GLOBAL.innodb_read_io_threads);
15 COUNT(@@GLOBAL.innodb_read_io_threads)
16 1
17 1 Expected
18 SET @@GLOBAL.innodb_write_io_threads=1;
19 ERROR HY000: Variable 'innodb_write_io_threads' is a read only variable
20 Expected error 'Read only variable'
21 SELECT COUNT(@@GLOBAL.innodb_write_io_threads);
22 COUNT(@@GLOBAL.innodb_write_io_threads)
23 1
24 1 Expected
25 '#---------------------BS_STVARS_027_03----------------------#'
26 SELECT @@GLOBAL.innodb_read_io_threads = VARIABLE_VALUE
27 FROM performance_schema.global_variables
28 WHERE VARIABLE_NAME='innodb_read_io_threads';
29 @@GLOBAL.innodb_read_io_threads = VARIABLE_VALUE
30 1
31 1 Expected
32 SELECT COUNT(@@GLOBAL.innodb_read_io_threads);
33 COUNT(@@GLOBAL.innodb_read_io_threads)
34 1
35 1 Expected
36 SELECT COUNT(VARIABLE_VALUE)
37 FROM performance_schema.global_variables
38 WHERE VARIABLE_NAME='innodb_read_io_threads';
39 COUNT(VARIABLE_VALUE)
40 1
41 1 Expected
42 SELECT @@GLOBAL.innodb_write_io_threads = VARIABLE_VALUE
43 FROM performance_schema.global_variables
44 WHERE VARIABLE_NAME='innodb_write_io_threads';
45 @@GLOBAL.innodb_write_io_threads = VARIABLE_VALUE
46 1
47 1 Expected
48 SELECT COUNT(@@GLOBAL.innodb_write_io_threads);
49 COUNT(@@GLOBAL.innodb_write_io_threads)
50 1
51 1 Expected
52 SELECT COUNT(VARIABLE_VALUE)
53 FROM performance_schema.global_variables
54 WHERE VARIABLE_NAME='innodb_write_io_threads';
55 COUNT(VARIABLE_VALUE)
56 1
57 1 Expected
58 '#---------------------BS_STVARS_027_04----------------------#'
59 SELECT @@innodb_read_io_threads = @@GLOBAL.innodb_read_io_threads;
60 @@innodb_read_io_threads = @@GLOBAL.innodb_read_io_threads
61 1
62 1 Expected
63 SELECT @@innodb_write_io_threads = @@GLOBAL.innodb_write_io_threads;
64 @@innodb_write_io_threads = @@GLOBAL.innodb_write_io_threads
65 1
66 1 Expected
67 '#---------------------BS_STVARS_027_05----------------------#'
68 SELECT COUNT(@@innodb_read_io_threads);
69 COUNT(@@innodb_read_io_threads)
70 1
71 1 Expected
72 SELECT COUNT(@@local.innodb_read_io_threads);
73 ERROR HY000: Variable 'innodb_read_io_threads' is a GLOBAL variable
74 Expected error 'Variable is a GLOBAL variable'
75 SELECT COUNT(@@SESSION.innodb_read_io_threads);
76 ERROR HY000: Variable 'innodb_read_io_threads' is a GLOBAL variable
77 Expected error 'Variable is a GLOBAL variable'
78 SELECT COUNT(@@GLOBAL.innodb_read_io_threads);
79 COUNT(@@GLOBAL.innodb_read_io_threads)
80 1
81 1 Expected
82 SELECT innodb_read_io_threads;
83 ERROR 42S22: Unknown column 'innodb_read_io_threads' in 'field list'
84 Expected error 'Unknown column'
85 SELECT COUNT(@@innodb_write_io_threads);
86 COUNT(@@innodb_write_io_threads)
87 1
88 1 Expected
89 SELECT COUNT(@@local.innodb_write_io_threads);
90 ERROR HY000: Variable 'innodb_write_io_threads' is a GLOBAL variable
91 Expected error 'Variable is a GLOBAL variable'
92 SELECT COUNT(@@SESSION.innodb_write_io_threads);
93 ERROR HY000: Variable 'innodb_write_io_threads' is a GLOBAL variable
94 Expected error 'Variable is a GLOBAL variable'
95 SELECT COUNT(@@GLOBAL.innodb_write_io_threads);
96 COUNT(@@GLOBAL.innodb_write_io_threads)
97 1
98 1 Expected
99 SELECT innodb_write_io_threads;
100 ERROR 42S22: Unknown column 'innodb_write_io_threads' in 'field list'
101 Expected error 'Unknown column'