목차

Acid

Internals

Indexing

Normalization

B tree

Partitioning

Concurrency

What is a Transaction?

Collections of queries that is treated as a single unit of work.

Transaction BEGIN, COMMIT, ROLLBACK

ACID

• 코드

Atomicity

• All queries in a transaction must succeed.
• If one query fails, or if the database went down prior to a commit of a transaction, all prior successful queries in the transaction should rollback.

Isolation

https://www.educative.io/answers/what-are-transaction-isolation-levels

Result of having transaction run in complete isolation from other concurrent transactions.

begin transaction isolation level repeatable read;