yugabyte/yugabyte-db

[Docs] Change ordering of transaction isolation levels

Open

#11,774 建立於 2022年3月16日

在 GitHub 查看
 (3 留言) (0 反應) (1 負責人)C (1,003 fork)batch import
area/documentationgood first issuepriority/lowtemp/docs-migration

倉庫指標

Star
 (8,229 star)
PR 合併指標
 (平均合併 17天 21小時) (30 天內合併 92 個 PR)

描述

Description

source: https://docs.yugabyte.com/latest/architecture/transactions/isolation-levels/#root

We begin the section by listing out 4 transaction isolation levels in decreasing order of strictness. Where possible, subsequent sections should follow this order to make it easier for readers to follow. For example, rewrite the second paragraph to read:

YugabyteDB supports three transaction isolation levels - Serializable, Snapshot (which maps to the SQL isolation level REPEATABLE READ), and Read Committed. Thus, YugabyteDB supports the three strictest of the above four isolation levels. These isolation levels are described below:

Serializable Isolation guarantees that transactions run in a way equivalent to a serial (sequential) schedule.

Snapshot Isolation guarantees that all reads made in a transaction will see a consistent snapshot of the database, and the transaction itself will successfully commit only if no updates it has made conflict with any concurrent updates made by transactions that committed since that snapshot.

Read Committed Isolation guarantees that each statement will see all data that has been committed before it is issued (note that this implicitly also means that the statement will see a consistent snapshot). Also, this isolation level internally handles read restart and conflict errors. In other words, the client doesn't see read restart and conflict errors (barring an exception). Details are in the READ COMMITTED isolation level section.

貢獻者指南