Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.