1select @@global.in_transaction;
2ERROR HY000: Variable 'in_transaction' is a SESSION variable
3select @@session.in_transaction;
4@@session.in_transaction
50
6show global variables like 'in_transaction';
7Variable_name	Value
8show session variables like 'in_transaction';
9Variable_name	Value
10in_transaction	0
11select * from information_schema.global_variables where variable_name='in_transaction';
12VARIABLE_NAME	VARIABLE_VALUE
13select * from information_schema.session_variables where variable_name='in_transaction';
14VARIABLE_NAME	VARIABLE_VALUE
15IN_TRANSACTION	0
16set global in_transaction=1;
17ERROR HY000: Variable 'in_transaction' is a read only variable
18set session in_transaction=1;
19ERROR HY000: Variable 'in_transaction' is a read only variable
20