查看隔离级别
SELECT @@GLOBAL.transaction_isolation;
SELECT @@SESSION.transaction_isolation;
show variables like '%iso%';
事务的4个隔离级别
READ UNCOMMITTED
READ COMMITTED
(个人推荐使用这个)REPEATABLE READ
(这个是mysql默认的事务隔离级别)SERIALIZABLE
设置全局隔离级别
set global transaction isolation level READ COMMITTED;
设置会话隔离级别
set session transaction isolation level READ COMMITTED;
通过配置文件设置隔离级别
直接设置/etc/mysql/my.cnf
或者设置/etc/mysql/conf.d/
下的文件夹,要注意的是,文件夹的权限不能过高或过低,否则会出现忽略conf.d
下的文件夹
[mysqld]
transaction-isolation = REPEATABLE-READ
transaction-isolation = READ-COMMITTED
transaction-isolation = READ-UNCOMMITTED
transaction-isolation = SERIALIZABLE