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.000000 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.000000 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.000000 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.000000 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.000000 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.000000 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.000000 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.000000 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.000000 57SELECT @@global.innodb_max_dirty_pages_pct_lwm; 58@@global.innodb_max_dirty_pages_pct_lwm 5975.000000 60SET @@global.innodb_max_dirty_pages_pct_lwm = 0.0; 61SELECT @@global.innodb_max_dirty_pages_pct_lwm; 62@@global.innodb_max_dirty_pages_pct_lwm 630.000000 64SET @@global.innodb_max_dirty_pages_pct_lwm = 1.1; 65SELECT @@global.innodb_max_dirty_pages_pct_lwm; 66@@global.innodb_max_dirty_pages_pct_lwm 671.100000 68SET @@global.innodb_max_dirty_pages_pct_lwm = 51.12; 69SELECT @@global.innodb_max_dirty_pages_pct_lwm; 70@@global.innodb_max_dirty_pages_pct_lwm 7151.120000 72SET @@global.innodb_max_dirty_pages_pct_lwm = 100; 73Warnings: 74Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct_lwm value: '100' 75Warning 1210 innodb_max_dirty_pages_pct_lwm cannot be set higher than innodb_max_dirty_pages_pct. 76Warning 1210 Setting innodb_max_dirty_page_pct_lwm to 75.000000 77SELECT @@global.innodb_max_dirty_pages_pct_lwm; 78@@global.innodb_max_dirty_pages_pct_lwm 7975.000000 80SET @@global.innodb_max_dirty_pages_pct_lwm = " "; 81ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm' 82SELECT @@global.innodb_max_dirty_pages_pct_lwm; 83@@global.innodb_max_dirty_pages_pct_lwm 8475.000000 85SET @@global.innodb_max_dirty_pages_pct_lwm = ' '; 86ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm' 87SELECT @@global.innodb_max_dirty_pages_pct_lwm; 88@@global.innodb_max_dirty_pages_pct_lwm 8975.000000 90'#----------------------FN_DYNVARS_046_05------------------------#' 91SELECT @@global.innodb_max_dirty_pages_pct_lwm = 92VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 93WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct_lwm'; 94@@global.innodb_max_dirty_pages_pct_lwm = 95VARIABLE_VALUE 961 97SELECT @@global.innodb_max_dirty_pages_pct_lwm; 98@@global.innodb_max_dirty_pages_pct_lwm 9975.000000 100SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 101WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct_lwm'; 102VARIABLE_VALUE 10375.000000 104'#---------------------FN_DYNVARS_046_06-------------------------#' 105SET @@global.innodb_max_dirty_pages_pct_lwm = OFF; 106ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm' 107SELECT @@global.innodb_max_dirty_pages_pct_lwm; 108@@global.innodb_max_dirty_pages_pct_lwm 10975.000000 110SET @@global.innodb_max_dirty_pages_pct_lwm = ON; 111ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct_lwm' 112SELECT @@global.innodb_max_dirty_pages_pct_lwm; 113@@global.innodb_max_dirty_pages_pct_lwm 11475.000000 115'#---------------------FN_DYNVARS_046_07----------------------#' 116SET @@global.innodb_max_dirty_pages_pct_lwm = TRUE; 117SELECT @@global.innodb_max_dirty_pages_pct_lwm; 118@@global.innodb_max_dirty_pages_pct_lwm 1191.000000 120SET @@global.innodb_max_dirty_pages_pct_lwm = FALSE; 121SELECT @@global.innodb_max_dirty_pages_pct_lwm; 122@@global.innodb_max_dirty_pages_pct_lwm 1230.000000 124SET @@global.innodb_max_dirty_pages_pct = @pct_start_value; 125SELECT @@global.innodb_max_dirty_pages_pct; 126@@global.innodb_max_dirty_pages_pct 12775.000000 128SET @@global.innodb_max_dirty_pages_pct_lwm = @pct_lwm_start_value; 129SELECT @@global.innodb_max_dirty_pages_pct_lwm; 130@@global.innodb_max_dirty_pages_pct_lwm 1310.000000 132