How do I set the isolation level of MySQL 5.1 InnoDB?
如何设置MySQL 5.1 InnoDB的隔离级别？
By entering:
输入：
mysql> show variables like '%isola%';
mysql>显示'％isola％'等变量;
The default level set for InnoDB is repeatable read.
How do I change the isolation level?
InnoDB的默认级别是可重复读取。如何更改隔离级别？
1 个解决方案
#1
28
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SESSION is optional, just limits the setting to the current session.READ UNCOMMITTED is to be replaced with your desired level.
SESSION是可选的，只是将设置限制为当前会话。 READ UNCOMMITTED将替换为您所需的级别。
#1
28
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SESSION is optional, just limits the setting to the current session.READ UNCOMMITTED is to be replaced with your desired level.
SESSION是可选的，只是将设置限制为当前会话。 READ UNCOMMITTED将替换为您所需的级别。