【转载】数据库事宜的属性－ACID

【转载】数据库事务的属性－ACID

4、事务隔离级别的设置：

1）服务启动选项--transaction-isolation或在配置文件中设置：

[mysqld]

transaction-isolation = {READ-UNCOMMITTED | READ-COMMITTED

???????????????????????? | REPEATABLE-READ | SERIALIZABLE}

2）服务启动后的设置：

SET [GLOBAL | SESSION] TRANSACTION ISOLATION LEVEL

{ READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SERIALIZABLE }

?