MySQL transaction isolation level)

Original article: http://xm-king.iteye.com/blog/770721

Read Uncommitted (Read Uncommitted content)

Read Committed (Read submitted content)

Repeatable Read (repeable)

Serializable (Serializable)
This is the highest isolation level. It forces transaction sorting to make it impossible to conflict with each other, thus solving the phantom read problem. In short, it adds a shared lock to each read data row. At this level, there may be a lot of timeout and lock competition.

In MySQL, these four isolation levels are implemented, which may cause the following problems:

(1) set the isolation level of A to read uncommitted (uncommitted read)

(3) set the isolation level of A to repeatable read (repeatable read)

(4) set the isolation level of

.