Debian Codegraph @

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

raw
1 SET @save_innodb_max_dirty_pages_pct=@@global.innodb_max_dirty_pages_pct;
2 set @@global.innodb_max_dirty_pages_pct=75;
3 SET @global_start_value = @@global.innodb_max_dirty_pages_pct;
4 SELECT @global_start_value;
5 @global_start_value
6 75
7 SET @global_start_max_dirty_lwm_value = @@global.innodb_max_dirty_pages_pct_lwm;
8 SELECT @global_start_max_dirty_lwm_value;
9 @global_start_max_dirty_lwm_value
10 0
11 SET @@global.innodb_max_dirty_pages_pct_lwm = 0;
12 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
13 @@global.innodb_max_dirty_pages_pct_lwm
14 0.000000
15 '#--------------------FN_DYNVARS_046_01------------------------#'
16 SET @@global.innodb_max_dirty_pages_pct = 0;
17 SET @@global.innodb_max_dirty_pages_pct = DEFAULT;
18 SELECT @@global.innodb_max_dirty_pages_pct;
19 @@global.innodb_max_dirty_pages_pct
20 90.000000
21 '#---------------------FN_DYNVARS_046_02-------------------------#'
22 SET innodb_max_dirty_pages_pct = 1;
23 ERROR HY000: Variable 'innodb_max_dirty_pages_pct' is a GLOBAL variable and should be set with SET GLOBAL
24 SELECT @@innodb_max_dirty_pages_pct;
25 @@innodb_max_dirty_pages_pct
26 90.000000
27 SELECT local.innodb_max_dirty_pages_pct;
28 ERROR 42S02: Unknown table 'local' in SELECT
29 SET global innodb_max_dirty_pages_pct = 0;
30 SELECT @@global.innodb_max_dirty_pages_pct;
31 @@global.innodb_max_dirty_pages_pct
32 0.000000
33 '#--------------------FN_DYNVARS_046_03------------------------#'
34 SET @@global.innodb_max_dirty_pages_pct = 0.0;
35 SELECT @@global.innodb_max_dirty_pages_pct;
36 @@global.innodb_max_dirty_pages_pct
37 0.000000
38 SET @@global.innodb_max_dirty_pages_pct = 1;
39 SELECT @@global.innodb_max_dirty_pages_pct;
40 @@global.innodb_max_dirty_pages_pct
41 1.000000
42 SET @@global.innodb_max_dirty_pages_pct = 99;
43 SELECT @@global.innodb_max_dirty_pages_pct;
44 @@global.innodb_max_dirty_pages_pct
45 99.000000
46 '#--------------------FN_DYNVARS_046_04------------------------#'
47 SET @@global.innodb_max_dirty_pages_pct_lwm = @global_start_value - 1;
48 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
49 @@global.innodb_max_dirty_pages_pct_lwm
50 74.000000
51 SET @@global.innodb_max_dirty_pages_pct = @global_start_value - 2;
52 Warnings:
53 Warning 1210 innodb_max_dirty_pages_pct cannot be set lower than innodb_max_dirty_pages_pct_lwm.
54 Warning 1210 Lowering innodb_max_dirty_page_pct_lwm to 73.000000
55 SELECT @@global.innodb_max_dirty_pages_pct;
56 @@global.innodb_max_dirty_pages_pct
57 73.000000
58 '#--------------------FN_DYNVARS_046_05-------------------------#'
59 SET @@global.innodb_max_dirty_pages_pct = -1;
60 Warnings:
61 Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '-1'
62 Warning 1210 innodb_max_dirty_pages_pct cannot be set lower than innodb_max_dirty_pages_pct_lwm.
63 Warning 1210 Lowering innodb_max_dirty_page_pct_lwm to 0.000000
64 SELECT @@global.innodb_max_dirty_pages_pct;
65 @@global.innodb_max_dirty_pages_pct
66 0.000000
67 SET @@global.innodb_max_dirty_pages_pct = -1024;
68 Warnings:
69 Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '-1024'
70 SELECT @@global.innodb_max_dirty_pages_pct;
71 @@global.innodb_max_dirty_pages_pct
72 0.000000
73 SET @@global.innodb_max_dirty_pages_pct = "T";
74 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct'
75 SELECT @@global.innodb_max_dirty_pages_pct;
76 @@global.innodb_max_dirty_pages_pct
77 0.000000
78 SET @@global.innodb_max_dirty_pages_pct = "Y";
79 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct'
80 SELECT @@global.innodb_max_dirty_pages_pct;
81 @@global.innodb_max_dirty_pages_pct
82 0.000000
83 SET @@global.innodb_max_dirty_pages_pct = 100;
84 Warnings:
85 Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '100'
86 SELECT @@global.innodb_max_dirty_pages_pct;
87 @@global.innodb_max_dirty_pages_pct
88 99.999000
89 SET @@global.innodb_max_dirty_pages_pct = 1001;
90 Warnings:
91 Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '1001'
92 SELECT @@global.innodb_max_dirty_pages_pct;
93 @@global.innodb_max_dirty_pages_pct
94 99.999000
95 SET @@global.innodb_max_dirty_pages_pct = 100000;
96 Warnings:
97 Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '100000'
98 SELECT @@global.innodb_max_dirty_pages_pct;
99 @@global.innodb_max_dirty_pages_pct
100 99.999000
101 SET @@global.innodb_max_dirty_pages_pct = ' ';
102 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct'
103 SELECT @@global.innodb_max_dirty_pages_pct;
104 @@global.innodb_max_dirty_pages_pct
105 99.999000
106 SET @@global.innodb_max_dirty_pages_pct = " ";
107 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct'
108 SELECT @@global.innodb_max_dirty_pages_pct;
109 @@global.innodb_max_dirty_pages_pct
110 99.999000
111 SET @@global.innodb_max_dirty_pages_pct = 1.1;
112 SELECT @@global.innodb_max_dirty_pages_pct;
113 @@global.innodb_max_dirty_pages_pct
114 1.100000
115 set global innodb_max_dirty_pages_pct = 0.1;
116 SELECT @@global.innodb_max_dirty_pages_pct;
117 @@global.innodb_max_dirty_pages_pct
118 0.100000
119 set global innodb_max_dirty_pages_pct = 31.34;
120 SELECT @@global.innodb_max_dirty_pages_pct;
121 @@global.innodb_max_dirty_pages_pct
122 31.340000
123 set global innodb_max_dirty_pages_pct = 100;
124 Warnings:
125 Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '100'
126 SELECT @@global.innodb_max_dirty_pages_pct;
127 @@global.innodb_max_dirty_pages_pct
128 99.999000
129 set global innodb_max_dirty_pages_pct = 99.999;
130 SELECT @@global.innodb_max_dirty_pages_pct;
131 @@global.innodb_max_dirty_pages_pct
132 99.999000
133 '#----------------------FN_DYNVARS_046_06------------------------#'
134 SELECT @@global.innodb_max_dirty_pages_pct =
135 VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
136 WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct';
137 @@global.innodb_max_dirty_pages_pct =
138 VARIABLE_VALUE
139 1
140 SELECT @@global.innodb_max_dirty_pages_pct;
141 @@global.innodb_max_dirty_pages_pct
142 99.999000
143 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
144 WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct';
145 VARIABLE_VALUE
146 99.999000
147 '#---------------------FN_DYNVARS_046_07-------------------------#'
148 SET @@global.innodb_max_dirty_pages_pct = OFF;
149 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct'
150 SELECT @@global.innodb_max_dirty_pages_pct;
151 @@global.innodb_max_dirty_pages_pct
152 99.999000
153 SET @@global.innodb_max_dirty_pages_pct = ON;
154 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct'
155 SELECT @@global.innodb_max_dirty_pages_pct;
156 @@global.innodb_max_dirty_pages_pct
157 99.999000
158 '#---------------------FN_DYNVARS_046_08----------------------#'
159 SET @@global.innodb_max_dirty_pages_pct = TRUE;
160 SELECT @@global.innodb_max_dirty_pages_pct;
161 @@global.innodb_max_dirty_pages_pct
162 1.000000
163 SET @@global.innodb_max_dirty_pages_pct = FALSE;
164 SELECT @@global.innodb_max_dirty_pages_pct;
165 @@global.innodb_max_dirty_pages_pct
166 0.000000
167 SET @@global.innodb_max_dirty_pages_pct = @global_start_value;
168 SELECT @@global.innodb_max_dirty_pages_pct;
169 @@global.innodb_max_dirty_pages_pct
170 75.000000
171 SET @@global.innodb_max_dirty_pages_pct_lwm = @global_start_max_dirty_lwm_value;
172 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
173 @@global.innodb_max_dirty_pages_pct_lwm
174 0.000000
175 SET @@global.innodb_max_dirty_pages_pct=@save_innodb_max_dirty_pages_pct;