1SET @global_start_value = @@global.innodb_flushing_avg_loops; 2SELECT @global_start_value; 3@global_start_value 430 5'#--------------------FN_DYNVARS_046_01------------------------#' 6SET @@global.innodb_flushing_avg_loops = 1; 7SET @@global.innodb_flushing_avg_loops = DEFAULT; 8SELECT @@global.innodb_flushing_avg_loops; 9@@global.innodb_flushing_avg_loops 1030 11'#---------------------FN_DYNVARS_046_02-------------------------#' 12SET innodb_flushing_avg_loops = 1; 13ERROR HY000: Variable 'innodb_flushing_avg_loops' is a GLOBAL variable and should be set with SET GLOBAL 14SELECT @@innodb_flushing_avg_loops; 15@@innodb_flushing_avg_loops 1630 17SELECT local.innodb_flushing_avg_loops; 18ERROR 42S02: Unknown table 'local' in field list 19SET global innodb_flushing_avg_loops = 1; 20SELECT @@global.innodb_flushing_avg_loops; 21@@global.innodb_flushing_avg_loops 221 23'#--------------------FN_DYNVARS_046_03------------------------#' 24SET @@global.innodb_flushing_avg_loops = 1; 25SELECT @@global.innodb_flushing_avg_loops; 26@@global.innodb_flushing_avg_loops 271 28SET @@global.innodb_flushing_avg_loops = 60; 29SELECT @@global.innodb_flushing_avg_loops; 30@@global.innodb_flushing_avg_loops 3160 32SET @@global.innodb_flushing_avg_loops = 1000; 33SELECT @@global.innodb_flushing_avg_loops; 34@@global.innodb_flushing_avg_loops 351000 36'#--------------------FN_DYNVARS_046_04-------------------------#' 37SET @@global.innodb_flushing_avg_loops = -1; 38Warnings: 39Warning 1292 Truncated incorrect innodb_flushing_avg_loops value: '-1' 40SELECT @@global.innodb_flushing_avg_loops; 41@@global.innodb_flushing_avg_loops 421 43SET @@global.innodb_flushing_avg_loops = "T"; 44ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops' 45SELECT @@global.innodb_flushing_avg_loops; 46@@global.innodb_flushing_avg_loops 471 48SET @@global.innodb_flushing_avg_loops = "Y"; 49ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops' 50SELECT @@global.innodb_flushing_avg_loops; 51@@global.innodb_flushing_avg_loops 521 53SET @@global.innodb_flushing_avg_loops = 1001; 54Warnings: 55Warning 1292 Truncated incorrect innodb_flushing_avg_loops value: '1001' 56SELECT @@global.innodb_flushing_avg_loops; 57@@global.innodb_flushing_avg_loops 581000 59SET @@global.innodb_flushing_avg_loops = ' '; 60ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops' 61SELECT @@global.innodb_flushing_avg_loops; 62@@global.innodb_flushing_avg_loops 631000 64SET @@global.innodb_flushing_avg_loops = " "; 65ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops' 66SELECT @@global.innodb_flushing_avg_loops; 67@@global.innodb_flushing_avg_loops 681000 69'#----------------------FN_DYNVARS_046_05------------------------#' 70SELECT @@global.innodb_flushing_avg_loops = 71VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 72WHERE VARIABLE_NAME='innodb_flushing_avg_loops'; 73@@global.innodb_flushing_avg_loops = 74VARIABLE_VALUE 751 76SELECT @@global.innodb_flushing_avg_loops; 77@@global.innodb_flushing_avg_loops 781000 79SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 80WHERE VARIABLE_NAME='innodb_flushing_avg_loops'; 81VARIABLE_VALUE 821000 83'#---------------------FN_DYNVARS_046_06-------------------------#' 84SET @@global.innodb_flushing_avg_loops = OFF; 85ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops' 86SELECT @@global.innodb_flushing_avg_loops; 87@@global.innodb_flushing_avg_loops 881000 89SET @@global.innodb_flushing_avg_loops = ON; 90ERROR 42000: Incorrect argument type to variable 'innodb_flushing_avg_loops' 91SELECT @@global.innodb_flushing_avg_loops; 92@@global.innodb_flushing_avg_loops 931000 94'#---------------------FN_DYNVARS_046_07----------------------#' 95SET @@global.innodb_flushing_avg_loops = TRUE; 96SELECT @@global.innodb_flushing_avg_loops; 97@@global.innodb_flushing_avg_loops 981 99SET @@global.innodb_flushing_avg_loops = FALSE; 100Warnings: 101Warning 1292 Truncated incorrect innodb_flushing_avg_loops value: '0' 102SELECT @@global.innodb_flushing_avg_loops; 103@@global.innodb_flushing_avg_loops 1041 105SET @@global.innodb_flushing_avg_loops = @global_start_value; 106SELECT @@global.innodb_flushing_avg_loops; 107@@global.innodb_flushing_avg_loops 10830 109