1SET @global_start_value = @@global.innodb_flush_log_at_trx_commit; 2SELECT @global_start_value; 3@global_start_value 41 5'#--------------------FN_DYNVARS_046_01------------------------#' 6SET @@global.innodb_flush_log_at_trx_commit = 0; 7SET @@global.innodb_flush_log_at_trx_commit = DEFAULT; 8SELECT @@global.innodb_flush_log_at_trx_commit; 9@@global.innodb_flush_log_at_trx_commit 101 11'#---------------------FN_DYNVARS_046_02-------------------------#' 12SET innodb_flush_log_at_trx_commit = 1; 13SELECT @@innodb_flush_log_at_trx_commit; 14@@innodb_flush_log_at_trx_commit 151 16SELECT local.innodb_flush_log_at_trx_commit; 17ERROR 42S02: Unknown table 'local' in field list 18SET global innodb_flush_log_at_trx_commit = 0; 19SELECT @@global.innodb_flush_log_at_trx_commit; 20@@global.innodb_flush_log_at_trx_commit 210 22'#--------------------FN_DYNVARS_046_03------------------------#' 23SET @@global.innodb_flush_log_at_trx_commit = 0; 24SELECT @@global.innodb_flush_log_at_trx_commit; 25@@global.innodb_flush_log_at_trx_commit 260 27SET @@global.innodb_flush_log_at_trx_commit = 1; 28SELECT @@global.innodb_flush_log_at_trx_commit; 29@@global.innodb_flush_log_at_trx_commit 301 31SET @@global.innodb_flush_log_at_trx_commit = 2; 32SELECT @@global.innodb_flush_log_at_trx_commit; 33@@global.innodb_flush_log_at_trx_commit 342 35'#--------------------FN_DYNVARS_046_04-------------------------#' 36SET @@global.innodb_flush_log_at_trx_commit = -1; 37Warnings: 38Warning 1292 Truncated incorrect innodb_flush_log_at_trx_commit value: '-1' 39SELECT @@global.innodb_flush_log_at_trx_commit; 40@@global.innodb_flush_log_at_trx_commit 410 42SET @@global.innodb_flush_log_at_trx_commit = "T"; 43ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit' 44SELECT @@global.innodb_flush_log_at_trx_commit; 45@@global.innodb_flush_log_at_trx_commit 460 47SET @@global.innodb_flush_log_at_trx_commit = "Y"; 48ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit' 49SELECT @@global.innodb_flush_log_at_trx_commit; 50@@global.innodb_flush_log_at_trx_commit 510 52SET @@global.innodb_flush_log_at_trx_commit = 1001; 53Warnings: 54Warning 1292 Truncated incorrect innodb_flush_log_at_trx_commit value: '1001' 55SELECT @@global.innodb_flush_log_at_trx_commit; 56@@global.innodb_flush_log_at_trx_commit 572 58SET @@global.innodb_flush_log_at_trx_commit = 100156787; 59Warnings: 60Warning 1292 Truncated incorrect innodb_flush_log_at_trx_commit value: '100156787' 61SELECT @@global.innodb_flush_log_at_trx_commit; 62@@global.innodb_flush_log_at_trx_commit 632 64SET @@global.innodb_flush_log_at_trx_commit = " "; 65ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit' 66SELECT @@global.innodb_flush_log_at_trx_commit; 67@@global.innodb_flush_log_at_trx_commit 682 69SET @@global.innodb_flush_log_at_trx_commit = 1.1; 70ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit' 71SELECT @@global.innodb_flush_log_at_trx_commit; 72@@global.innodb_flush_log_at_trx_commit 732 74SET @@global.innodb_flush_log_at_trx_commit = ' '; 75ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit' 76SELECT @@global.innodb_flush_log_at_trx_commit; 77@@global.innodb_flush_log_at_trx_commit 782 79'#----------------------FN_DYNVARS_046_05------------------------#' 80SELECT @@global.innodb_flush_log_at_trx_commit = 81VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 82WHERE VARIABLE_NAME='innodb_flush_log_at_trx_commit'; 83@@global.innodb_flush_log_at_trx_commit = 84VARIABLE_VALUE 851 86SELECT @@global.innodb_flush_log_at_trx_commit; 87@@global.innodb_flush_log_at_trx_commit 882 89SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 90WHERE VARIABLE_NAME='innodb_flush_log_at_trx_commit'; 91VARIABLE_VALUE 922 93'#---------------------FN_DYNVARS_046_06-------------------------#' 94SET @@global.innodb_flush_log_at_trx_commit = OFF; 95ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit' 96SELECT @@global.innodb_flush_log_at_trx_commit; 97@@global.innodb_flush_log_at_trx_commit 982 99SET @@global.innodb_flush_log_at_trx_commit = ON; 100ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit' 101SELECT @@global.innodb_flush_log_at_trx_commit; 102@@global.innodb_flush_log_at_trx_commit 1032 104'#---------------------FN_DYNVARS_046_07----------------------#' 105SET @@global.innodb_flush_log_at_trx_commit = TRUE; 106SELECT @@global.innodb_flush_log_at_trx_commit; 107@@global.innodb_flush_log_at_trx_commit 1081 109SET @@global.innodb_flush_log_at_trx_commit = FALSE; 110SELECT @@global.innodb_flush_log_at_trx_commit; 111@@global.innodb_flush_log_at_trx_commit 1120 113SET @@global.innodb_flush_log_at_trx_commit = @global_start_value; 114SELECT @@global.innodb_flush_log_at_trx_commit; 115@@global.innodb_flush_log_at_trx_commit 1161 117