为什么修改数据库隔离级别后没有效果？
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服务就可以生效了。