1SET @global_start_value = @@global.innodb_adaptive_flushing_lwm; 2SELECT @global_start_value; 3@global_start_value 410 5'#--------------------FN_DYNVARS_046_01------------------------#' 6SET @@global.innodb_adaptive_flushing_lwm = 1; 7SET @@global.innodb_adaptive_flushing_lwm = DEFAULT; 8SELECT @@global.innodb_adaptive_flushing_lwm; 9@@global.innodb_adaptive_flushing_lwm 1010.000000 11'#---------------------FN_DYNVARS_046_02-------------------------#' 12SET innodb_adaptive_flushing_lwm = 1; 13ERROR HY000: Variable 'innodb_adaptive_flushing_lwm' is a GLOBAL variable and should be set with SET GLOBAL 14SELECT @@innodb_adaptive_flushing_lwm; 15@@innodb_adaptive_flushing_lwm 1610.000000 17SELECT local.innodb_adaptive_flushing_lwm; 18ERROR 42S02: Unknown table 'local' in field list 19SET global innodb_adaptive_flushing_lwm = 1; 20SELECT @@global.innodb_adaptive_flushing_lwm; 21@@global.innodb_adaptive_flushing_lwm 221.000000 23'#--------------------FN_DYNVARS_046_03------------------------#' 24SET @@global.innodb_adaptive_flushing_lwm = 1; 25SELECT @@global.innodb_adaptive_flushing_lwm; 26@@global.innodb_adaptive_flushing_lwm 271.000000 28SET @@global.innodb_adaptive_flushing_lwm = 60; 29SELECT @@global.innodb_adaptive_flushing_lwm; 30@@global.innodb_adaptive_flushing_lwm 3160.000000 32SET @@global.innodb_adaptive_flushing_lwm = 70; 33SELECT @@global.innodb_adaptive_flushing_lwm; 34@@global.innodb_adaptive_flushing_lwm 3570.000000 36'#--------------------FN_DYNVARS_046_04-------------------------#' 37SET @@global.innodb_adaptive_flushing_lwm = -1; 38Warnings: 39Warning 1292 Truncated incorrect innodb_adaptive_flushing_lwm value: '-1' 40SELECT @@global.innodb_adaptive_flushing_lwm; 41@@global.innodb_adaptive_flushing_lwm 420.000000 43SET @@global.innodb_adaptive_flushing_lwm = "T"; 44ERROR 42000: Incorrect argument type to variable 'innodb_adaptive_flushing_lwm' 45SELECT @@global.innodb_adaptive_flushing_lwm; 46@@global.innodb_adaptive_flushing_lwm 470.000000 48SET @@global.innodb_adaptive_flushing_lwm = "Y"; 49ERROR 42000: Incorrect argument type to variable 'innodb_adaptive_flushing_lwm' 50SELECT @@global.innodb_adaptive_flushing_lwm; 51@@global.innodb_adaptive_flushing_lwm 520.000000 53SET @@global.innodb_adaptive_flushing_lwm = 71; 54Warnings: 55Warning 1292 Truncated incorrect innodb_adaptive_flushing_lwm value: '71' 56SELECT @@global.innodb_adaptive_flushing_lwm; 57@@global.innodb_adaptive_flushing_lwm 5870.000000 59'#----------------------FN_DYNVARS_046_05------------------------#' 60SELECT @@global.innodb_adaptive_flushing_lwm = 61VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 62WHERE VARIABLE_NAME='innodb_adaptive_flushing_lwm'; 63@@global.innodb_adaptive_flushing_lwm = 64VARIABLE_VALUE 651 66SELECT @@global.innodb_adaptive_flushing_lwm; 67@@global.innodb_adaptive_flushing_lwm 6870.000000 69SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 70WHERE VARIABLE_NAME='innodb_adaptive_flushing_lwm'; 71VARIABLE_VALUE 7270.000000 73'#---------------------FN_DYNVARS_046_06-------------------------#' 74SET @@global.innodb_adaptive_flushing_lwm = OFF; 75ERROR 42000: Incorrect argument type to variable 'innodb_adaptive_flushing_lwm' 76SELECT @@global.innodb_adaptive_flushing_lwm; 77@@global.innodb_adaptive_flushing_lwm 7870.000000 79SET @@global.innodb_adaptive_flushing_lwm = ON; 80ERROR 42000: Incorrect argument type to variable 'innodb_adaptive_flushing_lwm' 81SELECT @@global.innodb_adaptive_flushing_lwm; 82@@global.innodb_adaptive_flushing_lwm 8370.000000 84'#---------------------FN_DYNVARS_046_07----------------------#' 85SET @@global.innodb_adaptive_flushing_lwm = TRUE; 86SELECT @@global.innodb_adaptive_flushing_lwm; 87@@global.innodb_adaptive_flushing_lwm 881.000000 89SET @@global.innodb_adaptive_flushing_lwm = FALSE; 90SELECT @@global.innodb_adaptive_flushing_lwm; 91@@global.innodb_adaptive_flushing_lwm 920.000000 93SET @@global.innodb_adaptive_flushing_lwm = @global_start_value; 94SELECT @@global.innodb_adaptive_flushing_lwm; 95@@global.innodb_adaptive_flushing_lwm 9610.000000 97