High-performance MySQL affairs (3)

High-performance MySQL transaction:

Concept: A transaction is a set of atomic SQL queries, a separate unit of work. Statements within a transaction either execute successfully or all fail.

Bank Transfer is a classic example of how important it is to explain business. For example: Customer A to transfer 200 yuan to Customer B, requires three steps:

1, check whether a account is enough 200 yuan.

2,a account minus 200 yuan.

3,b account increased 200 yuan.

These three steps must be packaged in one transaction, and any one step fails, you must roll back all the steps.

The concept of an empty-talk business is not enough, and the business must have four standard characteristics of acid.

Atomic Nature (atomicity), consistency (consistency), isolation (isolation), persistence (durability)

High-performance MySQL affairs (3)