1SET @global_start_value = @@global.innodb_commit_concurrency; 2SELECT @global_start_value; 3@global_start_value 40 5'#--------------------FN_DYNVARS_046_01------------------------#' 6SET @@global.innodb_commit_concurrency = 0; 7SET @@global.innodb_commit_concurrency = DEFAULT; 8SELECT @@global.innodb_commit_concurrency; 9@@global.innodb_commit_concurrency 100 11'#---------------------FN_DYNVARS_046_02-------------------------#' 12SET innodb_commit_concurrency = 1; 13ERROR HY000: Variable 'innodb_commit_concurrency' is a GLOBAL variable and should be set with SET GLOBAL 14SELECT @@innodb_commit_concurrency; 15@@innodb_commit_concurrency 160 17SELECT local.innodb_commit_concurrency; 18ERROR 42S02: Unknown table 'local' in field list 19SET global innodb_commit_concurrency = 0; 20SELECT @@global.innodb_commit_concurrency; 21@@global.innodb_commit_concurrency 220 23'#--------------------FN_DYNVARS_046_03------------------------#' 24SET @@global.innodb_commit_concurrency = 0; 25SELECT @@global.innodb_commit_concurrency; 26@@global.innodb_commit_concurrency 270 28'#--------------------FN_DYNVARS_046_04-------------------------#' 29SET @@global.innodb_commit_concurrency = 1; 30ERROR 42000: Variable 'innodb_commit_concurrency' can't be set to the value of '1' 31SELECT @@global.innodb_commit_concurrency; 32@@global.innodb_commit_concurrency 330 34SET @@global.innodb_commit_concurrency = -1; 35ERROR 42000: Variable 'innodb_commit_concurrency' can't be set to the value of '-1' 36SELECT @@global.innodb_commit_concurrency; 37@@global.innodb_commit_concurrency 380 39SET @@global.innodb_commit_concurrency = "T"; 40ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency' 41SELECT @@global.innodb_commit_concurrency; 42@@global.innodb_commit_concurrency 430 44SET @@global.innodb_commit_concurrency = "Y"; 45ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency' 46SELECT @@global.innodb_commit_concurrency; 47@@global.innodb_commit_concurrency 480 49SET @@global.innodb_commit_concurrency = 1.1; 50ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency' 51SELECT @@global.innodb_commit_concurrency; 52@@global.innodb_commit_concurrency 530 54SET @@global.innodb_commit_concurrency = 1001; 55ERROR 42000: Variable 'innodb_commit_concurrency' can't be set to the value of '1001' 56SELECT @@global.innodb_commit_concurrency; 57@@global.innodb_commit_concurrency 580 59'#----------------------FN_DYNVARS_046_05------------------------#' 60SELECT @@global.innodb_commit_concurrency = 61VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 62WHERE VARIABLE_NAME='innodb_commit_concurrency'; 63@@global.innodb_commit_concurrency = 64VARIABLE_VALUE 651 66SELECT @@global.innodb_commit_concurrency; 67@@global.innodb_commit_concurrency 680 69SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 70WHERE VARIABLE_NAME='innodb_commit_concurrency'; 71VARIABLE_VALUE 720 73'#---------------------FN_DYNVARS_046_06-------------------------#' 74SET @@global.innodb_commit_concurrency = OFF; 75ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency' 76SELECT @@global.innodb_commit_concurrency; 77@@global.innodb_commit_concurrency 780 79SET @@global.innodb_commit_concurrency = ON; 80ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency' 81SELECT @@global.innodb_commit_concurrency; 82@@global.innodb_commit_concurrency 830 84SET @@global.innodb_commit_concurrency = @global_start_value; 85SELECT @@global.innodb_commit_concurrency; 86@@global.innodb_commit_concurrency 870 88