Debian Codegraph @

mysql-test/suite/special/r/innodb_dedicated_server_no_o_direct_no_fsync.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 ##########################################
8 INNODB_DEDICATED_SERVER
9 OFF
10 BUFFER_POOL_SIZE_IN_MB
11 128
12 LOG_CAPACITY_IN_MB
13 100
14
15 ###########################################
16 # RESTART 1 #
17 # innodb_dedicated_server = ON #
18 # innodb_buffer_pool_size = autoscaled #
19 # innodb_redo_log_capacity = autoscaled #
20 ###########################################
21 # restart: --innodb_dedicated_server=ON
22 INNODB_DEDICATED_SERVER
23 ON
24 1 expected
25 @final_pool_size_result
26 1
27 1 expected
28 @final_log_capacity_result
29 1
30
31 ###########################################
32 # RESTART 2 #
33 # innodb_dedicated_server = ON #
34 # innodb_buffer_pool_size = explicit #
35 # innodb_redo_log_capacity = autoscaled #
36 ###########################################
37 # restart: --innodb_dedicated_server=ON --innodb_buffer_pool_size=256M
38 INNODB_DEDICATED_SERVER
39 ON
40 BUFFER_POOL_SIZE_IN_MB
41 256
42 1 expected
43 @final_log_capacity_result
44 1
45 # Make sure that the warnings are present in server log.
46 Pattern "\[Warning\] .*MY-\d+.* Option innodb_dedicated_server is ignored for innodb_buffer_pool_size" found
47
48 ###########################################
49 # RESTART 3 #
50 # innodb_dedicated_server = ON #
51 # innodb_buffer_pool_size = autoscaled #
52 # innodb_redo_log_capacity = explicit #
53 ###########################################
54 # restart: --innodb_dedicated_server=ON --innodb_redo_log_capacity=50M
55 INNODB_DEDICATED_SERVER
56 ON
57 1 expected
58 @final_pool_size_result
59 1
60 LOG_CAPACITY_IN_MB
61 50
62 # Make sure that the warnings are present in server log.
63 Pattern "\[Warning\] .*MY-\d+.* Option innodb_dedicated_server is ignored for innodb_redo_log_capacity" found
64
65 ###########################################
66 # RESTART 4 #
67 # innodb_dedicated_server = ON #
68 # innodb_buffer_pool_size = explicit #
69 # innodb_redo_log_capacity = explicit #
70 ###########################################
71 # restart: --innodb_dedicated_server=ON --innodb_buffer_pool_size=256M --innodb_redo_log_capacity=50M
72 INNODB_DEDICATED_SERVER
73 ON
74 INNODB_DEDICATED_SERVER
75 ON
76 BUFFER_POOL_SIZE_IN_MB
77 256
78 LOG_CAPACITY_IN_MB
79 50
80 # Make sure that the warnings are present in server log.
81 Pattern "\[Warning\] .*MY-\d+.* Option innodb_dedicated_server is ignored for innodb_buffer_pool_size" found
82 Pattern "\[Warning\] .*MY-\d+.* Option innodb_dedicated_server is ignored for innodb_redo_log_capacity" found
83 SET innodb_dedicated_server = 0;
84 ERROR HY000: Variable 'innodb_dedicated_server' is a read only variable
85 SELECT @@innodb_dedicated_server;
86 @@innodb_dedicated_server
87 1
88 SELECT local.innodb_dedicated_server;
89 ERROR 42S02: Unknown table 'local' in field list
90 SET global innodb_dedicated_server = 0;
91 ERROR HY000: Variable 'innodb_dedicated_server' is a read only variable
92 SELECT @@global.innodb_dedicated_server;
93 @@global.innodb_dedicated_server
94 1
95 set session innodb_dedicated_server=1;
96 ERROR HY000: Variable 'innodb_dedicated_server' is a read only variable
97 SELECT @@innodb_dedicated_server;
98 @@innodb_dedicated_server
99 1
100 show global variables like 'innodb_dedicated_server';
101 Variable_name Value
102 innodb_dedicated_server ON
103 show session variables like 'innodb_dedicated_server';
104 Variable_name Value
105 innodb_dedicated_server ON
106 1 Expected
107 SELECT @@global.innodb_dedicated_server;
108 @@global.innodb_dedicated_server
109 1
110 select * from performance_schema.global_variables where variable_name='innodb_dedicated_server';
111 VARIABLE_NAME VARIABLE_VALUE
112 innodb_dedicated_server ON
113 select * from performance_schema.session_variables where variable_name='innodb_dedicated_server';
114 VARIABLE_NAME VARIABLE_VALUE
115 innodb_dedicated_server ON
116 set persist_only innodb_dedicated_server=off;
117 ERROR HY000: Variable 'innodb_dedicated_server' is a non persistent read only variable