为什么修改数据库隔离级别后没有效果？
mysql5.5:
mysql> select @@tx_isolation;
+-----------------+
| @@tx_isolation |
+-----------------+
| REPEATABLE-READ |
+-----------------+
1 row in set (0.00 sec)
mysql> set transaction isolation level read uncommitted;
Query OK, 0 rows affected (0.00 sec)
mysql> select @@tx_isolation;
+-----------------+
| @@tx_isolation |
+-----------------+
| REPEATABLE-READ |
+-----------------+
1 row in set (0.00 sec)
明明修改为 read uncommitted 了，为什么还是 repeatable read 呢?
[解决办法]
退出mysql重进
[解决办法]
重新启动mysql服务就可以生效了。
