Debian Codegraph @

mysql-test/suite/special/r/innodb_dedicated_server.result

raw
1
2 ###########################################
3 # INITIAL START #
4 # innodb_dedicated_server = OFF #
5 # innodb_buffer_pool_size = default #
6 # innodb_redo_log_capacity = default #
7 # innodb_flush_method = default #
8 ###########################################
9 INNODB_DEDICATED_SERVER
10 OFF
11 BUFFER_POOL_SIZE_IN_MB
12 128
13 LOG_CAPACITY_IN_MB
14 100
15 INNODB_FLUSH_METHOD
16 fsync
17
18 ###########################################
19 # RESTART 1 #
20 # innodb_dedicated_server = ON #
21 # innodb_buffer_pool_size = autoscaled #
22 # innodb_redo_log_capacity = autoscaled #
23 # innodb_flush_method = autoscaled #
24 ###########################################
25 # restart: --innodb_dedicated_server=ON
26 INNODB_DEDICATED_SERVER
27 ON
28 1 expected
29 @final_pool_size_result
30 1
31 1 expected
32 @final_log_capacity_result
33 1
34 INNODB_FLUSH_METHOD
35 O_DIRECT_NO_FSYNC
36
37 ###########################################
38 # RESTART 2 #
39 # innodb_dedicated_server = ON #
40 # innodb_buffer_pool_size = explicit #
41 # innodb_redo_log_capacity = autoscaled #
42 # innodb_flush_method = autoscaled #
43 ###########################################
44 # restart: --innodb_dedicated_server=ON --innodb_buffer_pool_size=256M
45 INNODB_DEDICATED_SERVER
46 ON
47 BUFFER_POOL_SIZE_IN_MB
48 256
49 1 expected
50 @final_log_capacity_result
51 1
52 INNODB_FLUSH_METHOD
53 O_DIRECT_NO_FSYNC
54 # Make sure that the warnings are present in server log.
55 Pattern "\[Warning\] .*MY-\d+.* Option innodb_dedicated_server is ignored for innodb_buffer_pool_size" found
56
57 ###########################################
58 # RESTART 3 #
59 # innodb_dedicated_server = ON #
60 # innodb_buffer_pool_size = autoscaled #
61 # innodb_redo_log_capacity = explicit #
62 # innodb_flush_method = autoscaled #
63 ###########################################
64 # restart: --innodb_dedicated_server=ON --innodb_redo_log_capacity=50M
65 INNODB_DEDICATED_SERVER
66 ON
67 1 expected
68 @final_pool_size_result
69 1
70 LOG_CAPACITY_IN_MB
71 50
72 INNODB_FLUSH_METHOD
73 O_DIRECT_NO_FSYNC
74 # Make sure that the warnings are present in server log.
75 Pattern "\[Warning\] .*MY-\d+.* Option innodb_dedicated_server is ignored for innodb_redo_log_capacity" found
76
77 ###########################################
78 # RESTART 4 #
79 # innodb_dedicated_server = ON #
80 # innodb_buffer_pool_size = autoscaled #
81 # innodb_redo_log_capacity = autoscaled #
82 # innodb_flush_method = explicit #
83 ###########################################
84 # restart: --innodb_dedicated_server=ON --innodb_flush_method=nosync
85 INNODB_DEDICATED_SERVER
86 ON
87 1 expected
88 @final_pool_size_result
89 1
90 1 expected
91 @final_log_capacity_result
92 1
93 INNODB_FLUSH_METHOD
94 nosync
95 # Make sure that the warnings are present in server log.
96 Pattern "\[Warning\] .*MY-\d+.* Option innodb_dedicated_server is ignored for innodb_flush_method" found
97
98 ###########################################
99 # RESTART 5 #
100 # innodb_dedicated_server = ON #
101 # innodb_buffer_pool_size = explicit #
102 # innodb_redo_log_capacity = explicit #
103 # innodb_flush_method = explicit #
104 ###########################################
105 # restart: --innodb_dedicated_server=ON --innodb_buffer_pool_size=256M --innodb_redo_log_capacity=50M --innodb_flush_method=nosync
106 INNODB_DEDICATED_SERVER
107 ON
108 BUFFER_POOL_SIZE_IN_MB
109 256
110 LOG_CAPACITY_IN_MB
111 50
112 INNODB_FLUSH_METHOD
113 nosync
114 # Make sure that the warnings are present in server log.
115 Pattern "\[Warning\] .*MY-\d+.* Option innodb_dedicated_server is ignored for innodb_buffer_pool_size" found
116 Pattern "\[Warning\] .*MY-\d+.* Option innodb_dedicated_server is ignored for innodb_redo_log_capacity" found
117 Pattern "\[Warning\] .*MY-\d+.* Option innodb_dedicated_server is ignored for innodb_flush_method" found
118
119 ###########################################
120 # RESTART 6 #
121 # innodb_dedicated_server = ON #
122 # innodb_buffer_pool_size = autoscaled #
123 # innodb_redo_log_capacity = explicit #
124 # innodb_flush_method = explicit #
125 ###########################################
126 # restart: --innodb_dedicated_server=ON --innodb_redo_log_capacity=50M --innodb_flush_method=nosync
127 INNODB_DEDICATED_SERVER
128 ON
129 1 expected
130 @final_pool_size_result
131 1
132 LOG_CAPACITY_IN_MB
133 50
134 INNODB_FLUSH_METHOD
135 nosync
136 # Make sure that the warnings are present in server log.
137 Pattern "\[Warning\] .*MY-\d+.* Option innodb_dedicated_server is ignored for innodb_redo_log_capacity" found
138 Pattern "\[Warning\] .*MY-\d+.* Option innodb_dedicated_server is ignored for innodb_flush_method" found
139 SET innodb_dedicated_server = 0;
140 ERROR HY000: Variable 'innodb_dedicated_server' is a read only variable
141 SELECT @@innodb_dedicated_server;
142 @@innodb_dedicated_server
143 1
144 SELECT local.innodb_dedicated_server;
145 ERROR 42S02: Unknown table 'local' in field list
146 SET global innodb_dedicated_server = 0;
147 ERROR HY000: Variable 'innodb_dedicated_server' is a read only variable
148 SELECT @@global.innodb_dedicated_server;
149 @@global.innodb_dedicated_server
150 1
151 set session innodb_dedicated_server=1;
152 ERROR HY000: Variable 'innodb_dedicated_server' is a read only variable
153 SELECT @@innodb_dedicated_server;
154 @@innodb_dedicated_server
155 1
156 show global variables like 'innodb_dedicated_server';
157 Variable_name Value
158 innodb_dedicated_server ON
159 show session variables like 'innodb_dedicated_server';
160 Variable_name Value
161 innodb_dedicated_server ON
162 1 Expected
163 SELECT @@global.innodb_dedicated_server;
164 @@global.innodb_dedicated_server
165 1
166 select * from performance_schema.global_variables where variable_name='innodb_dedicated_server';
167 VARIABLE_NAME VARIABLE_VALUE
168 innodb_dedicated_server ON
169 select * from performance_schema.session_variables where variable_name='innodb_dedicated_server';
170 VARIABLE_NAME VARIABLE_VALUE
171 innodb_dedicated_server ON
172 set persist_only innodb_dedicated_server=off;
173 ERROR HY000: Variable 'innodb_dedicated_server' is a non persistent read only variable