The beginning of mysql 5.5 innodb transaction isolation level

Summary:

1. The transaction isolation level belongs to the I of rdbms's acid, that is, isolation

2. Different transaction isolation levels lead to different behaviors of consistent reads.

3The default transaction isolation level of repeatable read MySQL 5.5 innodb is

4 uncommitted read will cause dirty reading, corresponding to read committed

5. The order of transaction isolation level from loose to most stringent is: read uncommitted,read committed,repeatable read,serialisable

6. The transaction isolation level is related to the specific mysql lock type.

7, you can configure the transaction isolation level at the MYSQL SERVER and database layer or session layer through statements

8, transaction isolation level it is actually the best tradeoff between performance and MVCC and data reliability, data consistency