mysql隔离级别：ERROR 1193 (HY000): Unknown system variable ‘tx_isolation‘

查看事务隔离级别

查看事务的隔离级别时提示错误’ERROR 1193 (HY000): Unknown system variable ‘tx_isolation’’

# 老版本：select @@global.tx_isolation;
mysql> select @@global.tx_isolation;
ERROR 1193 (HY000): Unknown system variable 'tx_isolation'

# 5.8版本之后使用：select @@global.transaction_isolation;
mysql> select @@global.transaction_isolation;
+--------------------------------+
| @@global.transaction_isolation |
+--------------------------------+
| REPEATABLE-READ                |
+--------------------------------+
1 row in set (0.00 sec)

如果想设置隔离级别使用如下语句

设置隔离级别

演示第1级别：读未提交
		set global transaction isolation level read uncommitted;
演示第2级别：读已提交
		set global transaction isolation level read committed;
演示第3级别：可重复读
		set global transaction isolation level repeatable read;

完！