查看和修改MySQL数据库的事物隔离级别

最新推荐文章于 2025-08-12 10:25:08 发布

转载最新推荐文章于 2025-08-12 10:25:08 发布 · 2.1k 阅读

数据库专栏收录该内容

32 篇文章

订阅专栏

本文介绍了如何查看MySQL数据库的事务隔离级别，默认为可重复读(REPEATABLE-READ)。此外，还提供了修改事务隔离级别的方法，包括READ-UNCOMMITTED、READ-COMMITTED、REPEATABLE-READ和SERIALIZABLE等不同级别。

查看MySQL的事物隔离级别

mysql> show variables like '%isolation%';
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| tx_isolation  | REPEATABLE-READ |
+---------------+-----------------+
1 row in set (0.00 sec)

mysql> select @@global.tx_isolation, @@tx_isolation;
+-----------------------+-----------------+
| @@global.tx_isolation | @@tx_isolation  |
+-----------------------+-----------------+
| REPEATABLE-READ       | REPEATABLE-READ |
+-----------------------+-----------------+
1 row in set (0.00 sec)

修改MySQL数据库的事物隔离级别

mysql> help ISOLATION
Name: 'ISOLATION'
Description:
Syntax:
SET [GLOBAL | SESSION] TRANSACTION ISOLATION LEVEL
  {
       REPEATABLE READ
     | READ COMMITTED
     | READ UNCOMMITTED
     | SERIALIZABLE
   }

转至：https://blog.youkuaiyun.com/zhu4674548/article/details/75195253