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