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 SELECT COUNT(@@GLOBAL.innodb_read_io_threads);
12 COUNT(@@GLOBAL.innodb_read_io_threads)
13 1
14 1 Expected
15 SELECT COUNT(@@GLOBAL.innodb_write_io_threads);
16 COUNT(@@GLOBAL.innodb_write_io_threads)
17 1
18 1 Expected
19 '#---------------------BS_STVARS_027_03----------------------#'
20 SELECT @@GLOBAL.innodb_read_io_threads = VARIABLE_VALUE
21 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
22 WHERE VARIABLE_NAME='innodb_read_io_threads';
23 @@GLOBAL.innodb_read_io_threads = VARIABLE_VALUE
24 1
25 1 Expected
26 SELECT COUNT(@@GLOBAL.innodb_read_io_threads);
27 COUNT(@@GLOBAL.innodb_read_io_threads)
28 1
29 1 Expected
30 SELECT COUNT(VARIABLE_VALUE)
31 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
32 WHERE VARIABLE_NAME='innodb_read_io_threads';
33 COUNT(VARIABLE_VALUE)
34 1
35 1 Expected
36 SELECT @@GLOBAL.innodb_write_io_threads = VARIABLE_VALUE
37 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
38 WHERE VARIABLE_NAME='innodb_write_io_threads';
39 @@GLOBAL.innodb_write_io_threads = VARIABLE_VALUE
40 1
41 1 Expected
42 SELECT COUNT(@@GLOBAL.innodb_write_io_threads);
43 COUNT(@@GLOBAL.innodb_write_io_threads)
44 1
45 1 Expected
46 SELECT COUNT(VARIABLE_VALUE)
47 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
48 WHERE VARIABLE_NAME='innodb_write_io_threads';
49 COUNT(VARIABLE_VALUE)
50 1
51 1 Expected
52 '#---------------------BS_STVARS_027_04----------------------#'
53 SELECT @@innodb_read_io_threads = @@GLOBAL.innodb_read_io_threads;
54 @@innodb_read_io_threads = @@GLOBAL.innodb_read_io_threads
55 1
56 1 Expected
57 SELECT @@innodb_write_io_threads = @@GLOBAL.innodb_write_io_threads;
58 @@innodb_write_io_threads = @@GLOBAL.innodb_write_io_threads
59 1
60 1 Expected
61 '#---------------------BS_STVARS_027_05----------------------#'
62 SELECT COUNT(@@innodb_read_io_threads);
63 COUNT(@@innodb_read_io_threads)
64 1
65 1 Expected
66 SELECT COUNT(@@local.innodb_read_io_threads);
67 ERROR HY000: Variable 'innodb_read_io_threads' is a GLOBAL variable
68 Expected error 'Variable is a GLOBAL variable'
69 SELECT COUNT(@@SESSION.innodb_read_io_threads);
70 ERROR HY000: Variable 'innodb_read_io_threads' is a GLOBAL variable
71 Expected error 'Variable is a GLOBAL variable'
72 SELECT COUNT(@@GLOBAL.innodb_read_io_threads);
73 COUNT(@@GLOBAL.innodb_read_io_threads)
74 1
75 1 Expected
76 SELECT innodb_read_io_threads = @@SESSION.innodb_read_io_threads;
77 ERROR 42S22: Unknown column 'innodb_read_io_threads' in 'SELECT'
78 Expected error 'Readonly variable'
79 SELECT COUNT(@@innodb_write_io_threads);
80 COUNT(@@innodb_write_io_threads)
81 1
82 1 Expected
83 SELECT COUNT(@@local.innodb_write_io_threads);
84 ERROR HY000: Variable 'innodb_write_io_threads' is a GLOBAL variable
85 Expected error 'Variable is a GLOBAL variable'
86 SELECT COUNT(@@SESSION.innodb_write_io_threads);
87 ERROR HY000: Variable 'innodb_write_io_threads' is a GLOBAL variable
88 Expected error 'Variable is a GLOBAL variable'
89 SELECT COUNT(@@GLOBAL.innodb_write_io_threads);
90 COUNT(@@GLOBAL.innodb_write_io_threads)
91 1
92 1 Expected
93 SELECT innodb_write_io_threads = @@SESSION.innodb_write_io_threads;
94 ERROR 42S22: Unknown column 'innodb_write_io_threads' in 'SELECT'
95 Expected error 'Readonly variable'