1SET @pct_lwm_start_value = @@global.innodb_max_dirty_pages_pct_lwm; 2SELECT @pct_lwm_start_value; 3@pct_lwm_start_value 40 5SET @pct_start_value = @@global.innodb_max_dirty_pages_pct; 6SELECT @pct_start_value; 7@pct_start_value 875 9'#--------------------FN_DYNVARS_046_01------------------------#' 10SET @@global.innodb_max_dirty_pages_pct_lwm = 0; 11SET @@global.innodb_max_dirty_pages_pct_lwm = DEFAULT; 12SELECT @@global.innodb_max_dirty_pages_pct_lwm; 13@@global.innodb_max_dirty_pages_pct_lwm 140 15'#---------------------FN_DYNVARS_046_02-------------------------#' 16SET innodb_max_dirty_pages_pct_lwm = 1; 17ERROR HY000: Variable 'innodb_max_dirty_pages_pct_lwm' is a GLOBAL variable and should be set with SET GLOBAL 18SELECT @@innodb_max_dirty_pages_pct_lwm; 19@@innodb_max_dirty_pages_pct_lwm 200 21SELECT local.innodb_max_dirty_pages_pct_lwm; 22ERROR 42S02: Unknown table 'local' in field list 23SET global innodb_max_dirty_pages_pct_lwm = 0; 24SELECT @@global.innodb_max_dirty_pages_pct_lwm; 25@@global.innodb_max_dirty_pages_pct_lwm 260 27'#--------------------FN_DYNVARS_046_03------------------------#' 28SET @@global.innodb_max_dirty_pages_pct_lwm = 0; 29SELECT @@global.innodb_max_dirty_pages_pct_lwm; 30@@global.innodb_max_dirty_pages_pct_lwm 310 32SET @@global.innodb_max_dirty_pages_pct_lwm = @pct_start_value; 33SELECT @@global.innodb_max_dirty_pages_pct_lwm; 34@@global.innodb_max_dirty_pages_pct_lwm 3575 36'#--------------------FN_DYNVARS_046_04-------------------------#' 37SET @@global.innodb_max_dirty_pages_pct_lwm = -1; 38Warnings: 39Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct_lwm value: '-1' 40SELECT @@global.innodb_max_dirty_pages_pct_lwm; 41@@global.innodb_max_dirty_pages_pct_lwm 420 43SET @@global.innodb_max_dirty_pages_pct_lwm = "T"; 44ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm' 45SELECT @@global.innodb_max_dirty_pages_pct_lwm; 46@@global.innodb_max_dirty_pages_pct_lwm 470 48SET @@global.innodb_max_dirty_pages_pct_lwm = "Y"; 49ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm' 50SELECT @@global.innodb_max_dirty_pages_pct_lwm; 51@@global.innodb_max_dirty_pages_pct_lwm 520 53SET @@global.innodb_max_dirty_pages_pct_lwm = @pct_start_value + 1; 54Warnings: 55Warning 1210 innodb_max_dirty_pages_pct_lwm cannot be set higher than innodb_max_dirty_pages_pct. 56Warning 1210 Setting innodb_max_dirty_page_pct_lwm to 75 57SELECT @@global.innodb_max_dirty_pages_pct_lwm; 58@@global.innodb_max_dirty_pages_pct_lwm 5975 60SET @@global.innodb_max_dirty_pages_pct_lwm = 100; 61Warnings: 62Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct_lwm value: '100' 63Warning 1210 innodb_max_dirty_pages_pct_lwm cannot be set higher than innodb_max_dirty_pages_pct. 64Warning 1210 Setting innodb_max_dirty_page_pct_lwm to 75 65SELECT @@global.innodb_max_dirty_pages_pct_lwm; 66@@global.innodb_max_dirty_pages_pct_lwm 6775 68'#----------------------FN_DYNVARS_046_05------------------------#' 69SELECT @@global.innodb_max_dirty_pages_pct_lwm = 70VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 71WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct_lwm'; 72@@global.innodb_max_dirty_pages_pct_lwm = 73VARIABLE_VALUE 741 75SELECT @@global.innodb_max_dirty_pages_pct_lwm; 76@@global.innodb_max_dirty_pages_pct_lwm 7775 78SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 79WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct_lwm'; 80VARIABLE_VALUE 8175 82'#---------------------FN_DYNVARS_046_06-------------------------#' 83SET @@global.innodb_max_dirty_pages_pct_lwm = OFF; 84ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm' 85SELECT @@global.innodb_max_dirty_pages_pct_lwm; 86@@global.innodb_max_dirty_pages_pct_lwm 8775 88SET @@global.innodb_max_dirty_pages_pct_lwm = ON; 89ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm' 90SELECT @@global.innodb_max_dirty_pages_pct_lwm; 91@@global.innodb_max_dirty_pages_pct_lwm 9275 93'#---------------------FN_DYNVARS_046_07----------------------#' 94SET @@global.innodb_max_dirty_pages_pct_lwm = TRUE; 95SELECT @@global.innodb_max_dirty_pages_pct_lwm; 96@@global.innodb_max_dirty_pages_pct_lwm 971 98SET @@global.innodb_max_dirty_pages_pct_lwm = FALSE; 99SELECT @@global.innodb_max_dirty_pages_pct_lwm; 100@@global.innodb_max_dirty_pages_pct_lwm 1010 102SET @@global.innodb_max_dirty_pages_pct = @pct_start_value; 103SELECT @@global.innodb_max_dirty_pages_pct; 104@@global.innodb_max_dirty_pages_pct 10575 106SET @@global.innodb_max_dirty_pages_pct_lwm = @pct_lwm_start_value; 107SELECT @@global.innodb_max_dirty_pages_pct_lwm; 108@@global.innodb_max_dirty_pages_pct_lwm 1090 110