84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
更改数据库默认隔离级别。在网上查了下可以使用这句:set global transaction isolation level read committed;更改mysql数据库的默认隔离级别,请问,这种隔离级别的设置是全部数据库(或者叫schema)吗?比如我有两个数据库,一个test1,一个test2,我是否可以设置test1的默认隔离级别为Read Commited,而设置test2的默认隔离级别为Repeatable Read?如何实现?
set global transaction isolation level read committed;
mysql
schema
test1
test2
Read Commited
Repeatable Read
认证0级讲师
从官方文档看,建议在mysql的参数文件中设置事务隔离级别,这样的设置方法应该是全局性的,和哪个数据库无关。
To set the default isolation level to REPEATABLE READ, use these lines in the [mysqld] section of an option file:[mysqld]transaction-isolation = REPEATABLE-READ
从官方文档看,建议在mysql的参数文件中设置事务隔离级别,这样的设置方法应该是全局性的,和哪个数据库无关。
To set the default isolation level to REPEATABLE READ, use these lines in the [mysqld] section of an option file:
[mysqld]
transaction-isolation = REPEATABLE-READ