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