1SET @global_start_value = @@global.innodb_max_dirty_pages_pct; 2SELECT @global_start_value; 3@global_start_value 475 5SET @global_start_max_dirty_lwm_value = @@global.innodb_max_dirty_pages_pct_lwm; 6SELECT @global_start_max_dirty_lwm_value; 7@global_start_max_dirty_lwm_value 80 9SET @@global.innodb_max_dirty_pages_pct_lwm = 0; 10SELECT @@global.innodb_max_dirty_pages_pct_lwm; 11@@global.innodb_max_dirty_pages_pct_lwm 120.000000 13'#--------------------FN_DYNVARS_046_01------------------------#' 14SET @@global.innodb_max_dirty_pages_pct = 0; 15SET @@global.innodb_max_dirty_pages_pct = DEFAULT; 16SELECT @@global.innodb_max_dirty_pages_pct; 17@@global.innodb_max_dirty_pages_pct 1875.000000 19'#---------------------FN_DYNVARS_046_02-------------------------#' 20SET innodb_max_dirty_pages_pct = 1; 21ERROR HY000: Variable 'innodb_max_dirty_pages_pct' is a GLOBAL variable and should be set with SET GLOBAL 22SELECT @@innodb_max_dirty_pages_pct; 23@@innodb_max_dirty_pages_pct 2475.000000 25SELECT local.innodb_max_dirty_pages_pct; 26ERROR 42S02: Unknown table 'local' in field list 27SET global innodb_max_dirty_pages_pct = 0; 28SELECT @@global.innodb_max_dirty_pages_pct; 29@@global.innodb_max_dirty_pages_pct 300.000000 31'#--------------------FN_DYNVARS_046_03------------------------#' 32SET @@global.innodb_max_dirty_pages_pct = 0.0; 33SELECT @@global.innodb_max_dirty_pages_pct; 34@@global.innodb_max_dirty_pages_pct 350.000000 36SET @@global.innodb_max_dirty_pages_pct = 1; 37SELECT @@global.innodb_max_dirty_pages_pct; 38@@global.innodb_max_dirty_pages_pct 391.000000 40SET @@global.innodb_max_dirty_pages_pct = 99; 41SELECT @@global.innodb_max_dirty_pages_pct; 42@@global.innodb_max_dirty_pages_pct 4399.000000 44'#--------------------FN_DYNVARS_046_04------------------------#' 45SET @@global.innodb_max_dirty_pages_pct_lwm = @global_start_value - 1; 46SELECT @@global.innodb_max_dirty_pages_pct_lwm; 47@@global.innodb_max_dirty_pages_pct_lwm 4874.000000 49SET @@global.innodb_max_dirty_pages_pct = @global_start_value - 2; 50Warnings: 51Warning 1210 innodb_max_dirty_pages_pct cannot be set lower than innodb_max_dirty_pages_pct_lwm. 52Warning 1210 Lowering innodb_max_dirty_page_pct_lwm to 73.000000 53SELECT @@global.innodb_max_dirty_pages_pct; 54@@global.innodb_max_dirty_pages_pct 5573.000000 56'#--------------------FN_DYNVARS_046_05-------------------------#' 57SET @@global.innodb_max_dirty_pages_pct = -1; 58Warnings: 59Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '-1' 60Warning 1210 innodb_max_dirty_pages_pct cannot be set lower than innodb_max_dirty_pages_pct_lwm. 61Warning 1210 Lowering innodb_max_dirty_page_pct_lwm to 0.000000 62SELECT @@global.innodb_max_dirty_pages_pct; 63@@global.innodb_max_dirty_pages_pct 640.000000 65SET @@global.innodb_max_dirty_pages_pct = -1024; 66Warnings: 67Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '-1024' 68SELECT @@global.innodb_max_dirty_pages_pct; 69@@global.innodb_max_dirty_pages_pct 700.000000 71SET @@global.innodb_max_dirty_pages_pct = "T"; 72ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' 73SELECT @@global.innodb_max_dirty_pages_pct; 74@@global.innodb_max_dirty_pages_pct 750.000000 76SET @@global.innodb_max_dirty_pages_pct = "Y"; 77ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' 78SELECT @@global.innodb_max_dirty_pages_pct; 79@@global.innodb_max_dirty_pages_pct 800.000000 81SET @@global.innodb_max_dirty_pages_pct = 100; 82Warnings: 83Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '100' 84SELECT @@global.innodb_max_dirty_pages_pct; 85@@global.innodb_max_dirty_pages_pct 8699.999000 87SET @@global.innodb_max_dirty_pages_pct = 1001; 88Warnings: 89Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '1001' 90SELECT @@global.innodb_max_dirty_pages_pct; 91@@global.innodb_max_dirty_pages_pct 9299.999000 93SET @@global.innodb_max_dirty_pages_pct = 100000; 94Warnings: 95Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '100000' 96SELECT @@global.innodb_max_dirty_pages_pct; 97@@global.innodb_max_dirty_pages_pct 9899.999000 99SET @@global.innodb_max_dirty_pages_pct = ' '; 100ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' 101SELECT @@global.innodb_max_dirty_pages_pct; 102@@global.innodb_max_dirty_pages_pct 10399.999000 104SET @@global.innodb_max_dirty_pages_pct = " "; 105ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' 106SELECT @@global.innodb_max_dirty_pages_pct; 107@@global.innodb_max_dirty_pages_pct 10899.999000 109SET @@global.innodb_max_dirty_pages_pct = 1.1; 110SELECT @@global.innodb_max_dirty_pages_pct; 111@@global.innodb_max_dirty_pages_pct 1121.100000 113set global innodb_max_dirty_pages_pct = 0.1; 114SELECT @@global.innodb_max_dirty_pages_pct; 115@@global.innodb_max_dirty_pages_pct 1160.100000 117set global innodb_max_dirty_pages_pct = 31.34; 118SELECT @@global.innodb_max_dirty_pages_pct; 119@@global.innodb_max_dirty_pages_pct 12031.340000 121set global innodb_max_dirty_pages_pct = 100; 122Warnings: 123Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '100' 124SELECT @@global.innodb_max_dirty_pages_pct; 125@@global.innodb_max_dirty_pages_pct 12699.999000 127set global innodb_max_dirty_pages_pct = 99.999; 128SELECT @@global.innodb_max_dirty_pages_pct; 129@@global.innodb_max_dirty_pages_pct 13099.999000 131'#----------------------FN_DYNVARS_046_06------------------------#' 132SELECT @@global.innodb_max_dirty_pages_pct = 133VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 134WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct'; 135@@global.innodb_max_dirty_pages_pct = 136VARIABLE_VALUE 1371 138SELECT @@global.innodb_max_dirty_pages_pct; 139@@global.innodb_max_dirty_pages_pct 14099.999000 141SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 142WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct'; 143VARIABLE_VALUE 14499.999000 145'#---------------------FN_DYNVARS_046_07-------------------------#' 146SET @@global.innodb_max_dirty_pages_pct = OFF; 147ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' 148SELECT @@global.innodb_max_dirty_pages_pct; 149@@global.innodb_max_dirty_pages_pct 15099.999000 151SET @@global.innodb_max_dirty_pages_pct = ON; 152ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' 153SELECT @@global.innodb_max_dirty_pages_pct; 154@@global.innodb_max_dirty_pages_pct 15599.999000 156'#---------------------FN_DYNVARS_046_08----------------------#' 157SET @@global.innodb_max_dirty_pages_pct = TRUE; 158SELECT @@global.innodb_max_dirty_pages_pct; 159@@global.innodb_max_dirty_pages_pct 1601.000000 161SET @@global.innodb_max_dirty_pages_pct = FALSE; 162SELECT @@global.innodb_max_dirty_pages_pct; 163@@global.innodb_max_dirty_pages_pct 1640.000000 165SET @@global.innodb_max_dirty_pages_pct = @global_start_value; 166SELECT @@global.innodb_max_dirty_pages_pct; 167@@global.innodb_max_dirty_pages_pct 16875.000000 169SET @@global.innodb_max_dirty_pages_pct_lwm = @global_start_max_dirty_lwm_value; 170SELECT @@global.innodb_max_dirty_pages_pct_lwm; 171@@global.innodb_max_dirty_pages_pct_lwm 1720.000000 173