1SET @global_start_value = @@global.innodb_flush_log_at_timeout; 2SELECT @global_start_value; 3@global_start_value 41 5'#--------------------FN_DYNVARS_046_01------------------------#' 6SET @@global.innodb_flush_log_at_timeout = 0; 7SET @@global.innodb_flush_log_at_timeout = DEFAULT; 8SELECT @@global.innodb_flush_log_at_timeout; 9@@global.innodb_flush_log_at_timeout 101 11'#---------------------FN_DYNVARS_046_02-------------------------#' 12SET innodb_flush_log_at_timeout = 1; 13ERROR HY000: Variable 'innodb_flush_log_at_timeout' is a GLOBAL variable and should be set with SET GLOBAL 14SELECT @@innodb_flush_log_at_timeout; 15@@innodb_flush_log_at_timeout 161 17SELECT local.innodb_flush_log_at_timeout; 18ERROR 42S02: Unknown table 'local' in field list 19SET global innodb_flush_log_at_timeout = 0; 20SELECT @@global.innodb_flush_log_at_timeout; 21@@global.innodb_flush_log_at_timeout 220 23'#--------------------FN_DYNVARS_046_03------------------------#' 24SET @@global.innodb_flush_log_at_timeout = 0; 25SELECT @@global.innodb_flush_log_at_timeout; 26@@global.innodb_flush_log_at_timeout 270 28SET @@global.innodb_flush_log_at_timeout = 10; 29SELECT @@global.innodb_flush_log_at_timeout; 30@@global.innodb_flush_log_at_timeout 3110 32SET @@global.innodb_flush_log_at_timeout = 2700; 33SELECT @@global.innodb_flush_log_at_timeout; 34@@global.innodb_flush_log_at_timeout 352700 36'#--------------------FN_DYNVARS_046_04-------------------------#' 37SET @@global.innodb_flush_log_at_timeout = -1; 38Warnings: 39Warning 1292 Truncated incorrect innodb_flush_log_at_timeout value: '-1' 40SELECT @@global.innodb_flush_log_at_timeout; 41@@global.innodb_flush_log_at_timeout 420 43SET @@global.innodb_flush_log_at_timeout = "T"; 44ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_timeout' 45SELECT @@global.innodb_flush_log_at_timeout; 46@@global.innodb_flush_log_at_timeout 470 48SET @@global.innodb_flush_log_at_timeout = "Y"; 49ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_timeout' 50SELECT @@global.innodb_flush_log_at_timeout; 51@@global.innodb_flush_log_at_timeout 520 53SET @@global.innodb_flush_log_at_timeout = 2701; 54Warnings: 55Warning 1292 Truncated incorrect innodb_flush_log_at_timeout value: '2701' 56SELECT @@global.innodb_flush_log_at_timeout; 57@@global.innodb_flush_log_at_timeout 582700 59SET @@global.innodb_flush_log_at_timeout = ' '; 60ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_timeout' 61SELECT @@global.innodb_flush_log_at_timeout; 62@@global.innodb_flush_log_at_timeout 632700 64SET @@global.innodb_flush_log_at_timeout = " "; 65ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_timeout' 66SELECT @@global.innodb_flush_log_at_timeout; 67@@global.innodb_flush_log_at_timeout 682700 69SET @@global.innodb_flush_log_at_timeout = 1.1; 70ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_timeout' 71SELECT @@global.innodb_flush_log_at_timeout; 72@@global.innodb_flush_log_at_timeout 732700 74'#----------------------FN_DYNVARS_046_05------------------------#' 75SELECT @@global.innodb_flush_log_at_timeout = 76VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 77WHERE VARIABLE_NAME='innodb_flush_log_at_timeout'; 78@@global.innodb_flush_log_at_timeout = 79VARIABLE_VALUE 801 81SELECT @@global.innodb_flush_log_at_timeout; 82@@global.innodb_flush_log_at_timeout 832700 84SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 85WHERE VARIABLE_NAME='innodb_flush_log_at_timeout'; 86VARIABLE_VALUE 872700 88'#---------------------FN_DYNVARS_046_06-------------------------#' 89SET @@global.innodb_flush_log_at_timeout = OFF; 90ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_timeout' 91SELECT @@global.innodb_flush_log_at_timeout; 92@@global.innodb_flush_log_at_timeout 932700 94SET @@global.innodb_flush_log_at_timeout = ON; 95ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_timeout' 96SELECT @@global.innodb_flush_log_at_timeout; 97@@global.innodb_flush_log_at_timeout 982700 99'#---------------------FN_DYNVARS_046_07----------------------#' 100SET @@global.innodb_flush_log_at_timeout = TRUE; 101SELECT @@global.innodb_flush_log_at_timeout; 102@@global.innodb_flush_log_at_timeout 1031 104SET @@global.innodb_flush_log_at_timeout = FALSE; 105SELECT @@global.innodb_flush_log_at_timeout; 106@@global.innodb_flush_log_at_timeout 1070 108SET @@global.innodb_flush_log_at_timeout = @global_start_value; 109SELECT @@global.innodb_flush_log_at_timeout; 110@@global.innodb_flush_log_at_timeout 1111 112