Debian Codegraph @

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