1.切换到performance_schema database下
List-1 查看当前用的是哪个database
mysql> select database();
+--------------------+
| database() |
+--------------------+
| performance_schema |
+--------------------+
1 row in set (0.01 sec)
2.用如下命令
List-2
mysql> select * from global_variables where variable_name like "%tx%";
+---------------+-----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+---------------+-----------------+
| tx_isolation | REPEATABLE-READ |
| tx_read_only | OFF |
+---------------+-----------------+
2 rows in set (0.01 sec)
List-2中可以看出事物隔离级别是repeatable-read;事物的read-only是被关闭的,这个tx_read_only在Spring的注解上可以通过@Transactional来修改。