1SET @save_innodb_max_dirty_pages_pct=@@global.innodb_max_dirty_pages_pct; 2set @@global.innodb_max_dirty_pages_pct=75; 3SET @pct_lwm_start_value = @@global.innodb_max_dirty_pages_pct_lwm; 4SELECT @pct_lwm_start_value; 5@pct_lwm_start_value 60 7SET @pct_start_value = @@global.innodb_max_dirty_pages_pct; 8SELECT @pct_start_value; 9@pct_start_value 1075 11'#--------------------FN_DYNVARS_046_01------------------------#' 12SET @@global.innodb_max_dirty_pages_pct_lwm = 0; 13SET @@global.innodb_max_dirty_pages_pct_lwm = DEFAULT; 14SELECT @@global.innodb_max_dirty_pages_pct_lwm; 15@@global.innodb_max_dirty_pages_pct_lwm 160.000000 17'#---------------------FN_DYNVARS_046_02-------------------------#' 18SET innodb_max_dirty_pages_pct_lwm = 1; 19ERROR HY000: Variable 'innodb_max_dirty_pages_pct_lwm' is a GLOBAL variable and should be set with SET GLOBAL 20SELECT @@innodb_max_dirty_pages_pct_lwm; 21@@innodb_max_dirty_pages_pct_lwm 220.000000 23SELECT local.innodb_max_dirty_pages_pct_lwm; 24ERROR 42S02: Unknown table 'local' in field list 25SET global innodb_max_dirty_pages_pct_lwm = 0; 26SELECT @@global.innodb_max_dirty_pages_pct_lwm; 27@@global.innodb_max_dirty_pages_pct_lwm 280.000000 29'#--------------------FN_DYNVARS_046_03------------------------#' 30SET @@global.innodb_max_dirty_pages_pct_lwm = 0; 31SELECT @@global.innodb_max_dirty_pages_pct_lwm; 32@@global.innodb_max_dirty_pages_pct_lwm 330.000000 34SET @@global.innodb_max_dirty_pages_pct_lwm = @pct_start_value; 35SELECT @@global.innodb_max_dirty_pages_pct_lwm; 36@@global.innodb_max_dirty_pages_pct_lwm 3775.000000 38'#--------------------FN_DYNVARS_046_04-------------------------#' 39SET @@global.innodb_max_dirty_pages_pct_lwm = -1; 40Warnings: 41Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct_lwm value: '-1' 42SELECT @@global.innodb_max_dirty_pages_pct_lwm; 43@@global.innodb_max_dirty_pages_pct_lwm 440.000000 45SET @@global.innodb_max_dirty_pages_pct_lwm = "T"; 46ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm' 47SELECT @@global.innodb_max_dirty_pages_pct_lwm; 48@@global.innodb_max_dirty_pages_pct_lwm 490.000000 50SET @@global.innodb_max_dirty_pages_pct_lwm = "Y"; 51ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm' 52SELECT @@global.innodb_max_dirty_pages_pct_lwm; 53@@global.innodb_max_dirty_pages_pct_lwm 540.000000 55SET @@global.innodb_max_dirty_pages_pct_lwm = @pct_start_value + 1; 56Warnings: 57Warning 1210 innodb_max_dirty_pages_pct_lwm cannot be set higher than innodb_max_dirty_pages_pct. 58Warning 1210 Setting innodb_max_dirty_page_pct_lwm to 75.000000 59SELECT @@global.innodb_max_dirty_pages_pct_lwm; 60@@global.innodb_max_dirty_pages_pct_lwm 6175.000000 62SET @@global.innodb_max_dirty_pages_pct_lwm = 0.0; 63SELECT @@global.innodb_max_dirty_pages_pct_lwm; 64@@global.innodb_max_dirty_pages_pct_lwm 650.000000 66SET @@global.innodb_max_dirty_pages_pct_lwm = 1.1; 67SELECT @@global.innodb_max_dirty_pages_pct_lwm; 68@@global.innodb_max_dirty_pages_pct_lwm 691.100000 70SET @@global.innodb_max_dirty_pages_pct_lwm = 51.12; 71SELECT @@global.innodb_max_dirty_pages_pct_lwm; 72@@global.innodb_max_dirty_pages_pct_lwm 7351.120000 74SET @@global.innodb_max_dirty_pages_pct_lwm = 100; 75Warnings: 76Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct_lwm value: '100' 77Warning 1210 innodb_max_dirty_pages_pct_lwm cannot be set higher than innodb_max_dirty_pages_pct. 78Warning 1210 Setting innodb_max_dirty_page_pct_lwm to 75.000000 79SELECT @@global.innodb_max_dirty_pages_pct_lwm; 80@@global.innodb_max_dirty_pages_pct_lwm 8175.000000 82SET @@global.innodb_max_dirty_pages_pct_lwm = " "; 83ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm' 84SELECT @@global.innodb_max_dirty_pages_pct_lwm; 85@@global.innodb_max_dirty_pages_pct_lwm 8675.000000 87SET @@global.innodb_max_dirty_pages_pct_lwm = ' '; 88ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm' 89SELECT @@global.innodb_max_dirty_pages_pct_lwm; 90@@global.innodb_max_dirty_pages_pct_lwm 9175.000000 92'#----------------------FN_DYNVARS_046_05------------------------#' 93SELECT @@global.innodb_max_dirty_pages_pct_lwm = 94VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 95WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct_lwm'; 96@@global.innodb_max_dirty_pages_pct_lwm = 97VARIABLE_VALUE 981 99SELECT @@global.innodb_max_dirty_pages_pct_lwm; 100@@global.innodb_max_dirty_pages_pct_lwm 10175.000000 102SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 103WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct_lwm'; 104VARIABLE_VALUE 10575.000000 106'#---------------------FN_DYNVARS_046_06-------------------------#' 107SET @@global.innodb_max_dirty_pages_pct_lwm = OFF; 108ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm' 109SELECT @@global.innodb_max_dirty_pages_pct_lwm; 110@@global.innodb_max_dirty_pages_pct_lwm 11175.000000 112SET @@global.innodb_max_dirty_pages_pct_lwm = ON; 113ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm' 114SELECT @@global.innodb_max_dirty_pages_pct_lwm; 115@@global.innodb_max_dirty_pages_pct_lwm 11675.000000 117'#---------------------FN_DYNVARS_046_07----------------------#' 118SET @@global.innodb_max_dirty_pages_pct_lwm = TRUE; 119SELECT @@global.innodb_max_dirty_pages_pct_lwm; 120@@global.innodb_max_dirty_pages_pct_lwm 1211.000000 122SET @@global.innodb_max_dirty_pages_pct_lwm = FALSE; 123SELECT @@global.innodb_max_dirty_pages_pct_lwm; 124@@global.innodb_max_dirty_pages_pct_lwm 1250.000000 126SET @@global.innodb_max_dirty_pages_pct = @pct_start_value; 127SELECT @@global.innodb_max_dirty_pages_pct; 128@@global.innodb_max_dirty_pages_pct 12975.000000 130SET @@global.innodb_max_dirty_pages_pct_lwm = @pct_lwm_start_value; 131SELECT @@global.innodb_max_dirty_pages_pct_lwm; 132@@global.innodb_max_dirty_pages_pct_lwm 1330.000000 134SET @@global.innodb_max_dirty_pages_pct=@save_innodb_max_dirty_pages_pct; 135