What is a transaction
A transaction is a collection of operations that either all succeed or all fail and roll back.
ACID four major characteristics
Atomicity, consistency, isolation, and persistence.
Four isolation levels
Read not submitted, read submitted, repeatable, serialized.
Locking mechanism
Shared lock, exclusive lock, row lock, watch lock, gap lock.
Disclaimer: Articles on this site come from original content, reposts, AI generation, and other sources. If there are copyright or other issues, pleaseclick here to feedback, and our company will verify and handle it promptly.