1SET @start_global_value = @@session.transaction_allow_batching; 2SELECT @start_global_value as "Should be off by default"; 3Should be off by default 40 5select @@global.transaction_allow_batching; 6ERROR HY000: Variable 'transaction_allow_batching' is a SESSION variable 7select @@session.transaction_allow_batching; 8@@session.transaction_allow_batching 90 10show global variables like 'transaction_allow_batching'; 11Variable_name Value 12show session variables like 'transaction_allow_batching'; 13Variable_name Value 14transaction_allow_batching OFF 15select * from information_schema.global_variables where variable_name='transaction_allow_batching'; 16VARIABLE_NAME VARIABLE_VALUE 17select * from information_schema.session_variables where variable_name='transaction_allow_batching'; 18VARIABLE_NAME VARIABLE_VALUE 19TRANSACTION_ALLOW_BATCHING OFF 20set global transaction_allow_batching = 1; 21ERROR HY000: Variable 'transaction_allow_batching' is a SESSION variable and can't be used with SET GLOBAL 22set session transaction_allow_batching = TRUE; 23select @@session.transaction_allow_batching; 24@@session.transaction_allow_batching 251 26set transaction_allow_batching=1.1; 27ERROR 42000: Incorrect argument type to variable 'transaction_allow_batching' 28set transaction_allow_batching=1e1; 29ERROR 42000: Incorrect argument type to variable 'transaction_allow_batching' 30set transaction_allow_batching="foobar"; 31ERROR 42000: Variable 'transaction_allow_batching' can't be set to the value of 'foobar' 32set session transaction_allow_batching = @start_global_value; 33select @@session.transaction_allow_batching; 34@@session.transaction_allow_batching 350 36