MySQL Knowledge points

I. Characteristics of a transaction

Atomicity, consistency, isolation, persistence

Second, the isolation level of the transaction

1. Non-submitted reading (read uncommitpeatableted)

Infamous dirty read, other transactions uncommitted, still readable to

2, submit read RC (Committed)

2.1. The transaction will establish a read View each time the read operation is done.

2.2. Only read committed transactions are allowed, but multiple queries in one transaction may result in different results, which are also known as non-repeatable reads.

3. REPEATABLE Read RR (Repeat read)

3.1. During the first read operation, the transaction will establish a read View

3.2, mysq the InnoDB default isolation level, in the same transaction, continuous same read reads to the same result set

4, serialization (Serializable)

Table lock

Third, MVCC (multi-version concurrency control)

Cond.....

Resources:

MySQL Lock

Isolation level

B + Tree

MySQL Knowledge points