lock escalation 中文意思是什麼

lock escalation 解釋
鎖升級
  • lock : n 1 鎖，閂，栓。2 （運河等的）船閘。3 制輪楔。4 【機械工程】氣閘，氣塞，鎖氣室。5 【軍事】槍機。6...
  • escalation : 擴大
  1. Lock escalation is triggered at either of these times

    將在下列時間觸發鎖升級：
  2. Locks option also affects when lock escalation occurs

    選項也會影響何時進行鎖升級。
  3. Using lock escalation reduces system overhead

    利用鎖升級可以減少系統開銷。
  4. Disables lock escalation based on the number of locks

    基於鎖數禁用鎖升級。
  5. However, memory pressure can still activate lock escalation

    但是，內存不足仍可激活鎖升級。
  6. If lock escalation succeeds, only the locks held by the session on

    如果鎖升級成功，只有會話在
  7. When the escalation occurs at the table level, no requests can be made for any lock lower than a table

    在表級別上升級時，不能請求低於表的鎖。
  8. 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

    數據庫引擎可以為同一語句執行行鎖定和頁鎖定，以最大程度地減少鎖的數量，並降低需要進行鎖升級的可能性。
  9. Lock escalation is the process of converting many fine - grain locks, such as a row, into fewer coarse - grain locks, such as a table

    鎖升級就是將大量較細粒度的鎖（例如行）轉換為少量較粗粒度的鎖（例如表） 。
  10. 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

    鎖升級是將許多較細粒度的鎖轉換成數量更少的較粗粒度的鎖的過程，這樣可以減少系統開銷，但卻增加了並發爭用的可能性。
  11. 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鎖） 。
  12. 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個鎖，則不會觸發鎖升級。
  13. 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個新鎖時便會觸發鎖升級。
  14. 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個鎖重試鎖升級。
  15. 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 % （或者更低，如果存在內存不足的壓力） 。
  16. Lock escalation database engine

    鎖升級（數據庫引擎）
  17. No lock escalation is attempted for

    但它不會嘗試在
  18. Disables lock escalation based on memory pressure, or based on number of locks

    基於內存不足或基於鎖數禁用鎖升級。
  19. Lock escalation thresholds

    鎖升級閾值
  20. If the full lock cannot be acquired, no lock escalation happens at that time and the database engine will continue to acquire row, key, or page locks

    如果無法獲取全鎖，當時不會發生鎖升級，而數據庫引擎將繼續獲取行、鍵或頁鎖。
分享友人
分享到 Line

分享到臉書