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