Debian Codegraph @

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

raw
1 SET @pct_lwm_start_value = @@global.innodb_max_dirty_pages_pct_lwm;
2 SELECT @pct_lwm_start_value;
3 @pct_lwm_start_value
4 10
5 SET @pct_start_value = @@global.innodb_max_dirty_pages_pct;
6 SELECT @pct_start_value;
7 @pct_start_value
8 90
9 '#--------------------FN_DYNVARS_046_01------------------------#'
10 SET @@global.innodb_max_dirty_pages_pct_lwm = 0;
11 SET @@global.innodb_max_dirty_pages_pct_lwm = DEFAULT;
12 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
13 @@global.innodb_max_dirty_pages_pct_lwm
14 10.000000
15 '#---------------------FN_DYNVARS_046_02-------------------------#'
16 SET innodb_max_dirty_pages_pct_lwm = 1;
17 ERROR HY000: Variable 'innodb_max_dirty_pages_pct_lwm' is a GLOBAL variable and should be set with SET GLOBAL
18 SELECT @@innodb_max_dirty_pages_pct_lwm;
19 @@innodb_max_dirty_pages_pct_lwm
20 10.000000
21 SELECT local.innodb_max_dirty_pages_pct_lwm;
22 ERROR 42S02: Unknown table 'local' in field list
23 SET global innodb_max_dirty_pages_pct_lwm = 0;
24 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
25 @@global.innodb_max_dirty_pages_pct_lwm
26 0.000000
27 '#--------------------FN_DYNVARS_046_03------------------------#'
28 SET @@global.innodb_max_dirty_pages_pct_lwm = 0;
29 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
30 @@global.innodb_max_dirty_pages_pct_lwm
31 0.000000
32 SET @@global.innodb_max_dirty_pages_pct_lwm = @pct_start_value;
33 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
34 @@global.innodb_max_dirty_pages_pct_lwm
35 90.000000
36 '#--------------------FN_DYNVARS_046_04-------------------------#'
37 SET @@global.innodb_max_dirty_pages_pct_lwm = -1;
38 Warnings:
39 Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct_lwm value: '-1'
40 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
41 @@global.innodb_max_dirty_pages_pct_lwm
42 0.000000
43 SET @@global.innodb_max_dirty_pages_pct_lwm = "T";
44 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm'
45 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
46 @@global.innodb_max_dirty_pages_pct_lwm
47 0.000000
48 SET @@global.innodb_max_dirty_pages_pct_lwm = "Y";
49 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm'
50 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
51 @@global.innodb_max_dirty_pages_pct_lwm
52 0.000000
53 SET @@global.innodb_max_dirty_pages_pct_lwm = @pct_start_value + 1;
54 Warnings:
55 Warning 1210 innodb_max_dirty_pages_pct_lwm cannot be set higher than innodb_max_dirty_pages_pct.
56 Warning 1210 Setting innodb_max_dirty_page_pct_lwm to 90.000000
57 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
58 @@global.innodb_max_dirty_pages_pct_lwm
59 90.000000
60 SET @@global.innodb_max_dirty_pages_pct_lwm = 0.0;
61 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
62 @@global.innodb_max_dirty_pages_pct_lwm
63 0.000000
64 SET @@global.innodb_max_dirty_pages_pct_lwm = 1.1;
65 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
66 @@global.innodb_max_dirty_pages_pct_lwm
67 1.100000
68 SET @@global.innodb_max_dirty_pages_pct_lwm = 51.12;
69 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
70 @@global.innodb_max_dirty_pages_pct_lwm
71 51.120000
72 SET @@global.innodb_max_dirty_pages_pct_lwm = 100;
73 Warnings:
74 Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct_lwm value: '100'
75 Warning 1210 innodb_max_dirty_pages_pct_lwm cannot be set higher than innodb_max_dirty_pages_pct.
76 Warning 1210 Setting innodb_max_dirty_page_pct_lwm to 90.000000
77 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
78 @@global.innodb_max_dirty_pages_pct_lwm
79 90.000000
80 SET @@global.innodb_max_dirty_pages_pct_lwm = " ";
81 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm'
82 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
83 @@global.innodb_max_dirty_pages_pct_lwm
84 90.000000
85 SET @@global.innodb_max_dirty_pages_pct_lwm = ' ';
86 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm'
87 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
88 @@global.innodb_max_dirty_pages_pct_lwm
89 90.000000
90 '#----------------------FN_DYNVARS_046_05------------------------#'
91 SELECT @@global.innodb_max_dirty_pages_pct_lwm =
92 VARIABLE_VALUE FROM performance_schema.global_variables
93 WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct_lwm';
94 @@global.innodb_max_dirty_pages_pct_lwm =
95 VARIABLE_VALUE
96 1
97 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
98 @@global.innodb_max_dirty_pages_pct_lwm
99 90.000000
100 SELECT VARIABLE_VALUE FROM performance_schema.global_variables
101 WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct_lwm';
102 VARIABLE_VALUE
103 90.000000
104 '#---------------------FN_DYNVARS_046_06-------------------------#'
105 SET @@global.innodb_max_dirty_pages_pct_lwm = OFF;
106 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm'
107 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
108 @@global.innodb_max_dirty_pages_pct_lwm
109 90.000000
110 SET @@global.innodb_max_dirty_pages_pct_lwm = ON;
111 ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm'
112 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
113 @@global.innodb_max_dirty_pages_pct_lwm
114 90.000000
115 '#---------------------FN_DYNVARS_046_07----------------------#'
116 SET @@global.innodb_max_dirty_pages_pct_lwm = TRUE;
117 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
118 @@global.innodb_max_dirty_pages_pct_lwm
119 1.000000
120 SET @@global.innodb_max_dirty_pages_pct_lwm = FALSE;
121 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
122 @@global.innodb_max_dirty_pages_pct_lwm
123 0.000000
124 SET @@global.innodb_max_dirty_pages_pct = @pct_start_value;
125 SELECT @@global.innodb_max_dirty_pages_pct;
126 @@global.innodb_max_dirty_pages_pct
127 90.000000
128 SET @@global.innodb_max_dirty_pages_pct_lwm = @pct_lwm_start_value;
129 SELECT @@global.innodb_max_dirty_pages_pct_lwm;
130 @@global.innodb_max_dirty_pages_pct_lwm
131 10.000000