Saturday, January 24, 2009

How to Set Isolation level and View


To set Isolation level, Say Read Uncommitted.

mysql>SET GLOBAL TRANSACTION ISOLATION ;
LEVEL READ UNCOMMITTED;
The default Isolation level is Repeatable Read.
To view current Isolation Level
mysql>select @@tx_isolation;

No comments:

Post a Comment