1SET @save_innodb_max_dirty_pages_pct=@@global.innodb_max_dirty_pages_pct; 2set @@global.innodb_max_dirty_pages_pct=75; 3SET @global_start_value = @@global.innodb_max_dirty_pages_pct; 4SELECT @global_start_value; 5@global_start_value 675 7SET @global_start_max_dirty_lwm_value = @@global.innodb_max_dirty_pages_pct_lwm; 8SELECT @global_start_max_dirty_lwm_value; 9@global_start_max_dirty_lwm_value 100 11SET @@global.innodb_max_dirty_pages_pct_lwm = 0; 12SELECT @@global.innodb_max_dirty_pages_pct_lwm; 13@@global.innodb_max_dirty_pages_pct_lwm 140.000000 15'#--------------------FN_DYNVARS_046_01------------------------#' 16SET @@global.innodb_max_dirty_pages_pct = 0; 17SET @@global.innodb_max_dirty_pages_pct = DEFAULT; 18SELECT @@global.innodb_max_dirty_pages_pct; 19@@global.innodb_max_dirty_pages_pct 2075.000000 21'#---------------------FN_DYNVARS_046_02-------------------------#' 22SET innodb_max_dirty_pages_pct = 1; 23ERROR HY000: Variable 'innodb_max_dirty_pages_pct' is a GLOBAL variable and should be set with SET GLOBAL 24SELECT @@innodb_max_dirty_pages_pct; 25@@innodb_max_dirty_pages_pct 2675.000000 27SELECT local.innodb_max_dirty_pages_pct; 28ERROR 42S02: Unknown table 'local' in field list 29SET global innodb_max_dirty_pages_pct = 0; 30SELECT @@global.innodb_max_dirty_pages_pct; 31@@global.innodb_max_dirty_pages_pct 320.000000 33'#--------------------FN_DYNVARS_046_03------------------------#' 34SET @@global.innodb_max_dirty_pages_pct = 0.0; 35SELECT @@global.innodb_max_dirty_pages_pct; 36@@global.innodb_max_dirty_pages_pct 370.000000 38SET @@global.innodb_max_dirty_pages_pct = 1; 39SELECT @@global.innodb_max_dirty_pages_pct; 40@@global.innodb_max_dirty_pages_pct 411.000000 42SET @@global.innodb_max_dirty_pages_pct = 99; 43SELECT @@global.innodb_max_dirty_pages_pct; 44@@global.innodb_max_dirty_pages_pct 4599.000000 46'#--------------------FN_DYNVARS_046_04------------------------#' 47SET @@global.innodb_max_dirty_pages_pct_lwm = @global_start_value - 1; 48SELECT @@global.innodb_max_dirty_pages_pct_lwm; 49@@global.innodb_max_dirty_pages_pct_lwm 5074.000000 51SET @@global.innodb_max_dirty_pages_pct = @global_start_value - 2; 52Warnings: 53Warning 1210 innodb_max_dirty_pages_pct cannot be set lower than innodb_max_dirty_pages_pct_lwm. 54Warning 1210 Lowering innodb_max_dirty_page_pct_lwm to 73.000000 55SELECT @@global.innodb_max_dirty_pages_pct; 56@@global.innodb_max_dirty_pages_pct 5773.000000 58'#--------------------FN_DYNVARS_046_05-------------------------#' 59SET @@global.innodb_max_dirty_pages_pct = -1; 60Warnings: 61Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '-1' 62Warning 1210 innodb_max_dirty_pages_pct cannot be set lower than innodb_max_dirty_pages_pct_lwm. 63Warning 1210 Lowering innodb_max_dirty_page_pct_lwm to 0.000000 64SELECT @@global.innodb_max_dirty_pages_pct; 65@@global.innodb_max_dirty_pages_pct 660.000000 67SET @@global.innodb_max_dirty_pages_pct = -1024; 68Warnings: 69Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '-1024' 70SELECT @@global.innodb_max_dirty_pages_pct; 71@@global.innodb_max_dirty_pages_pct 720.000000 73SET @@global.innodb_max_dirty_pages_pct = "T"; 74ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' 75SELECT @@global.innodb_max_dirty_pages_pct; 76@@global.innodb_max_dirty_pages_pct 770.000000 78SET @@global.innodb_max_dirty_pages_pct = "Y"; 79ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' 80SELECT @@global.innodb_max_dirty_pages_pct; 81@@global.innodb_max_dirty_pages_pct 820.000000 83SET @@global.innodb_max_dirty_pages_pct = 100; 84Warnings: 85Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '100' 86SELECT @@global.innodb_max_dirty_pages_pct; 87@@global.innodb_max_dirty_pages_pct 8899.999000 89SET @@global.innodb_max_dirty_pages_pct = 1001; 90Warnings: 91Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '1001' 92SELECT @@global.innodb_max_dirty_pages_pct; 93@@global.innodb_max_dirty_pages_pct 9499.999000 95SET @@global.innodb_max_dirty_pages_pct = 100000; 96Warnings: 97Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '100000' 98SELECT @@global.innodb_max_dirty_pages_pct; 99@@global.innodb_max_dirty_pages_pct 10099.999000 101SET @@global.innodb_max_dirty_pages_pct = ' '; 102ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' 103SELECT @@global.innodb_max_dirty_pages_pct; 104@@global.innodb_max_dirty_pages_pct 10599.999000 106SET @@global.innodb_max_dirty_pages_pct = " "; 107ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' 108SELECT @@global.innodb_max_dirty_pages_pct; 109@@global.innodb_max_dirty_pages_pct 11099.999000 111SET @@global.innodb_max_dirty_pages_pct = 1.1; 112SELECT @@global.innodb_max_dirty_pages_pct; 113@@global.innodb_max_dirty_pages_pct 1141.100000 115set global innodb_max_dirty_pages_pct = 0.1; 116SELECT @@global.innodb_max_dirty_pages_pct; 117@@global.innodb_max_dirty_pages_pct 1180.100000 119set global innodb_max_dirty_pages_pct = 31.34; 120SELECT @@global.innodb_max_dirty_pages_pct; 121@@global.innodb_max_dirty_pages_pct 12231.340000 123set global innodb_max_dirty_pages_pct = 100; 124Warnings: 125Warning 1292 Truncated incorrect innodb_max_dirty_pages_pct value: '100' 126SELECT @@global.innodb_max_dirty_pages_pct; 127@@global.innodb_max_dirty_pages_pct 12899.999000 129set global innodb_max_dirty_pages_pct = 99.999; 130SELECT @@global.innodb_max_dirty_pages_pct; 131@@global.innodb_max_dirty_pages_pct 13299.999000 133'#----------------------FN_DYNVARS_046_06------------------------#' 134SELECT @@global.innodb_max_dirty_pages_pct = 135VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 136WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct'; 137@@global.innodb_max_dirty_pages_pct = 138VARIABLE_VALUE 1391 140SELECT @@global.innodb_max_dirty_pages_pct; 141@@global.innodb_max_dirty_pages_pct 14299.999000 143SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 144WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct'; 145VARIABLE_VALUE 14699.999000 147'#---------------------FN_DYNVARS_046_07-------------------------#' 148SET @@global.innodb_max_dirty_pages_pct = OFF; 149ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' 150SELECT @@global.innodb_max_dirty_pages_pct; 151@@global.innodb_max_dirty_pages_pct 15299.999000 153SET @@global.innodb_max_dirty_pages_pct = ON; 154ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' 155SELECT @@global.innodb_max_dirty_pages_pct; 156@@global.innodb_max_dirty_pages_pct 15799.999000 158'#---------------------FN_DYNVARS_046_08----------------------#' 159SET @@global.innodb_max_dirty_pages_pct = TRUE; 160SELECT @@global.innodb_max_dirty_pages_pct; 161@@global.innodb_max_dirty_pages_pct 1621.000000 163SET @@global.innodb_max_dirty_pages_pct = FALSE; 164SELECT @@global.innodb_max_dirty_pages_pct; 165@@global.innodb_max_dirty_pages_pct 1660.000000 167SET @@global.innodb_max_dirty_pages_pct = @global_start_value; 168SELECT @@global.innodb_max_dirty_pages_pct; 169@@global.innodb_max_dirty_pages_pct 17075.000000 171SET @@global.innodb_max_dirty_pages_pct_lwm = @global_start_max_dirty_lwm_value; 172SELECT @@global.innodb_max_dirty_pages_pct_lwm; 173@@global.innodb_max_dirty_pages_pct_lwm 1740.000000 175SET @@global.innodb_max_dirty_pages_pct=@save_innodb_max_dirty_pages_pct; 176