1SET @global_start_value = @@global.innodb_purge_batch_size; 2SELECT @global_start_value; 3@global_start_value 4300 5'#--------------------FN_DYNVARS_046_01------------------------#' 6SET @@global.innodb_purge_batch_size = 1; 7SET @@global.innodb_purge_batch_size = DEFAULT; 8SELECT @@global.innodb_purge_batch_size; 9@@global.innodb_purge_batch_size 10300 11'#---------------------FN_DYNVARS_046_02-------------------------#' 12SET innodb_purge_batch_size = 1; 13ERROR HY000: Variable 'innodb_purge_batch_size' is a GLOBAL variable and should be set with SET GLOBAL 14SELECT @@innodb_purge_batch_size; 15@@innodb_purge_batch_size 16300 17SELECT local.innodb_purge_batch_size; 18ERROR 42S02: Unknown table 'local' in field list 19SET global innodb_purge_batch_size = 1; 20SELECT @@global.innodb_purge_batch_size; 21@@global.innodb_purge_batch_size 221 23'#--------------------FN_DYNVARS_046_03------------------------#' 24SET @@global.innodb_purge_batch_size = 1; 25SELECT @@global.innodb_purge_batch_size; 26@@global.innodb_purge_batch_size 271 28SET @@global.innodb_purge_batch_size = 5000; 29SELECT @@global.innodb_purge_batch_size; 30@@global.innodb_purge_batch_size 315000 32SET @@global.innodb_purge_batch_size = 4294967295; 33Warnings: 34Warning 1292 Truncated incorrect innodb_purge_batch_size value: '4294967295' 35SELECT @@global.innodb_purge_batch_size; 36@@global.innodb_purge_batch_size 375000 38'#--------------------FN_DYNVARS_046_04-------------------------#' 39SET @@global.innodb_purge_batch_size = 0; 40Warnings: 41Warning 1292 Truncated incorrect innodb_purge_batch_size value: '0' 42SELECT @@global.innodb_purge_batch_size; 43@@global.innodb_purge_batch_size 441 45SET @@global.innodb_purge_batch_size = "T"; 46ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size' 47SELECT @@global.innodb_purge_batch_size; 48@@global.innodb_purge_batch_size 491 50SET @@global.innodb_purge_batch_size = "Y"; 51ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size' 52SELECT @@global.innodb_purge_batch_size; 53@@global.innodb_purge_batch_size 541 55SET @@global.innodb_purge_batch_size = ' '; 56ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size' 57SELECT @@global.innodb_purge_batch_size; 58@@global.innodb_purge_batch_size 591 60SET @@global.innodb_purge_batch_size = " "; 61ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size' 62SELECT @@global.innodb_purge_batch_size; 63@@global.innodb_purge_batch_size 641 65SET @@global.innodb_purge_batch_size = 1.1; 66ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size' 67SELECT @@global.innodb_purge_batch_size; 68@@global.innodb_purge_batch_size 691 70SET @@global.innodb_purge_batch_size = 4294967297; 71Warnings: 72Warning 1292 Truncated incorrect innodb_purge_batch_size value: '4294967297' 73SELECT @@global.innodb_purge_batch_size; 74@@global.innodb_purge_batch_size 755000 76'#----------------------FN_DYNVARS_046_05------------------------#' 77SELECT @@global.innodb_purge_batch_size = 78VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 79WHERE VARIABLE_NAME='innodb_purge_batch_size'; 80@@global.innodb_purge_batch_size = 81VARIABLE_VALUE 821 83SELECT @@global.innodb_purge_batch_size; 84@@global.innodb_purge_batch_size 855000 86SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 87WHERE VARIABLE_NAME='innodb_purge_batch_size'; 88VARIABLE_VALUE 895000 90'#---------------------FN_DYNVARS_046_06-------------------------#' 91SET @@global.innodb_purge_batch_size = OFF; 92ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size' 93SELECT @@global.innodb_purge_batch_size; 94@@global.innodb_purge_batch_size 955000 96SET @@global.innodb_purge_batch_size = ON; 97ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size' 98SELECT @@global.innodb_purge_batch_size; 99@@global.innodb_purge_batch_size 1005000 101'#---------------------FN_DYNVARS_046_07----------------------#' 102SET @@global.innodb_purge_batch_size = TRUE; 103SELECT @@global.innodb_purge_batch_size; 104@@global.innodb_purge_batch_size 1051 106SET @@global.innodb_purge_batch_size = FALSE; 107Warnings: 108Warning 1292 Truncated incorrect innodb_purge_batch_size value: '0' 109SELECT @@global.innodb_purge_batch_size; 110@@global.innodb_purge_batch_size 1111 112SET @@global.innodb_purge_batch_size = @global_start_value; 113SELECT @@global.innodb_purge_batch_size; 114@@global.innodb_purge_batch_size 115300 116