0. Read uncommitted (可以读未提交事务数据--脏读)
1.Read committed (只可以读提交事务数据--不可重复读)
2.repeatable Read (只有两个事务都提交,才可以读到新数据--幻读)
3.serializable (只有一个事务可以操作数据,无论读写,其他事务等待)
set session|global transaction isolation level
Read uncommitted | read committed
repeateable read | serializable
select @@tx_isolation 查看当前隔离级别(session)
select @@global.tx_isolation 查看全局隔离级别
http://xm-king.iteye.com/blog/770721
http://orzdba.wordpress.com/2011/03/03/transaction_isolation_levels/