我同时开了两个cmd窗口,都连接了MySQL,先查看窗口a的隔离级别
select @@transaction_isolation;
输出
+-------------------------+
| @@transaction_isolation |
+-------------------------+
| READ-UNCOMMITTED |
+-------------------------+
另一个cmd窗口b输入
set global transaction isolation level repeatable read;
再次查看窗口a的隔离级别
select @@transaction_isolation;
输出
+-------------------------+
| @@transaction_isolation |
+-------------------------+
| READ-UNCOMMITTED |
+-------------------------+
为什么窗口a的隔离级别不变呢,在窗口b中修改的不是全局的隔离级别吗?
已解决:设置全局隔离级别要重启,设置会话隔离级别则不用重启