鎖升級 的英文怎麼說
中文拼音 [suǒshēngjí]
鎖升級
英文
lock escalation-
Lock escalation is triggered at either of these times
將在下列時間觸發鎖升級：Locks option also affects when lock escalation occurs
選項也會影響何時進行鎖升級。Upgrades a reader lock to the writer lock, using a
超時值將讀線程鎖升級為寫線程鎖。While only the locks the session acquired in
由於決定是否應進行鎖升級時只考慮會話在Using lock escalation reduces system overhead
利用鎖升級可以減少系統開銷。Disables lock escalation based on the number of locks
基於鎖數禁用鎖升級。Upgrades a reader lock to the writer lock, using an
超時值將讀線程鎖升級為寫線程鎖。Upgrades a reader lock to the writer lock
將讀線程鎖升級為寫線程鎖。However, memory pressure can still activate lock escalation
但是，內存不足仍可激活鎖升級。If lock escalation succeeds, only the locks held by the session on
如果鎖升級成功，只有會話在The database engine might do both row and page locking for the same statement to minimize the number of locks and reduce the likelihood that lock escalation will be necessary
數據庫引擎可以為同一語句執行行鎖定和頁鎖定，以最大程度地減少鎖的數量，並降低需要進行鎖升級的可能性。Lock escalation is the process of converting many fine - grain locks, such as a row, into fewer coarse - grain locks, such as a table
鎖升級就是將大量較細粒度的鎖（例如行）轉換為少量較粗粒度的鎖（例如表） 。Lock escalation is the process of converting many fine - grain locks into fewer coarse - grain locks, reducing system overhead while increasing the probability of concurrency contention
鎖升級是將許多較細粒度的鎖轉換成數量更少的較粗粒度的鎖的過程，這樣可以減少系統開銷，但卻增加了並發爭用的可能性。The database engine does not escalate row or key - range locks to page locks, but escalates them directly to table locks
數據庫引擎不會將行鎖或鍵范圍鎖升級到頁鎖，而是將它們直接升級到表鎖。If the lock escalation attempt succeeds and the full table lock is acquired, then all heap or b - tree, page page, key - range, or row - level locks held by the transaction on the heap or index are released
如果鎖升級嘗試成功並獲取全表鎖，將釋放事務在堆或索引上所持有的所有堆或b樹鎖、頁鎖（ page鎖） 、鍵范圍鎖（ key鎖）或行級鎖（ rid鎖） 。Similarly, lock escalation is not triggered if a statement has a self join on a table, and each reference to the table only acquires 3, 000 locks in the table
同樣，如果語句中含有表的自聯接，並且表的每一個引用僅在表中獲取3 ， 000個鎖，則不會觸發鎖升級。If locks cannot be escalated because of lock conflicts, the database engine periodically triggers lock escalation at every 1, 250 new locks acquired
如果由於鎖沖突導致無法升級鎖，則數據庫引擎每當獲取1 ， 250個新鎖時便會觸發鎖升級。If a lock escalation attempt fails because of conflicting locks held by concurrent transactions, the database engine will retry the lock escalation for each additional 1, 250 locks acquired by the transaction
如果由於並發事務所持有的鎖沖突而導致鎖升級嘗試失敗，則數據庫引擎將對事務獲取的其他1 ， 250個鎖重試鎖升級。Locks option is a value other than 0, then the lock escalation threshold is 40 percent or less if there is a memory pressure of the value of the locks option
選項設置為非0值，則鎖升級閾值是locks選項的值的40 % （或者更低，如果存在內存不足的壓力） 。Erez recommends upgrading your locks to a bump - proof design, but cautions against relying entirely on any type of lock
愛爾茲推薦把你的鎖升級成防撞設計的鎖，但是告誡不要完全依賴哪一種鎖。分享友人