Mysql View and set things isolation level

1. View

SELECT @ @tx_isolation

2. Settings

2.1 All Levels

　　

1 Read UNCOMMITTED: Reads data that has not yet been committed: no problem is solved 2) Read Committed: Reads the data that has been submitted: can resolve dirty read---- oracle default 3) repeatable READ: Reread read: Can resolve dirty read and non-repeatable READ--- the MySQL default 4) Serializable: Serialization: Can resolve dirty read non-repeatable read and virtual read---equivalent to the lock table

2.2 Settings

　　

Set the isolation level for MySQL : Set Session transaction ISOLATION level setting transaction isolation Levels

　　

Mysql View and set things isolation level