repeatable read 中文意思是什麼
repeatable read
解釋
可重讀- repeatable : 可重復的
- read : vt 1 閱讀，朗讀，誦讀；【議會】宣讀（議案）；照譜唱[奏] （aloud out off）。2 辨讀，辨認（暗號等）...
-
For example, reading from a read - only look up table doesn t require repeatable read, and uncommitted read is sufficient
比如，讀取只讀的查找表不需要可重復讀級別，未提交讀級別就足夠了。 -
This leaves you a choice between read committed and repeatable read
剩下的也就是在「授權讀取」和「可重復讀取」之間選擇了。 -
Repeatable read - rr
可重復讀rr -
Non repeatable read
不可重復讀 -
By default, mysql uses the repeatable read isolation level for all transactions
默認情況下， mysql對所有事務使用repeatable read隔離級別。 -
This is an important issue, but using repeatable read isn ' t the only way to resolve it
這是一個非常重要的問題，但是使用可重復讀取並不是解決問題的唯一途徑。 -
Readpast can only be specified in transactions operating at the read committed or repeatable read isolation levels
僅可在運行於read committed或repeatable read隔離級別的事務中指定readpast 。 -
Specifies that a scan is performed with the same locking semantics as a transaction running at repeatable read isolation level
指定事務在repeatable read隔離級別運行時，使用相同的鎖定語義執行一次掃描。 -
Transactions must be run at an isolation level of at least repeatable read to prevent lost updates that can occur when two transactions each retrieve the same row, and then later update the row based on the originally retrieved values
當兩個事務中的每個事務都要檢索相同的行，然後又根據最初的檢索值更新行時，可能發生更新丟失。此時，事務必須至少以的可重復讀的隔離級別運行，以防止更新丟失。 -
If the transaction isolation mode is repeatable read, then the optimizer would base its choice purely on the estimated costs
如果事務隔離模式是可重復讀（ repeatable read ） ，那麼優化器會將其選擇完全基於估算成本。
分享友人