鎖粒度 的英文怎麼說
中文拼音 [suǒlìdù]
鎖粒度
英文
lock granularity-
If specified with rowlock, paglock, or tablock, the exclusive locks apply to the appropriate level of granularity
如果同時指定了rowlock , paglock或tablock ,則排他鎖將應用於相應的粒度級別。Some operations require placing locks at multiple levels of granularity, forming a hierarchy of locks
某些操作需要在多個粒度級別放置鎖,以形成鎖的層次結構。To improve the efficiency of the database engine in detecting lock conflicts at the higher level of granularity
提高數據庫引擎在較高的粒度級別檢測鎖沖突的效率。Used to constrain the considered lock granularities for an index
用於約束經過考慮的索引鎖粒度。Lock granularity and hierarchies
鎖粒度和層次結構The database engine can dynamically choose the level of lock granularity based on the optimizer s estimate of the number of rows a transact - sql statement will reference
數據庫引擎可以根據優化器估計的transact - sql語句可能引用的行數,動態地選擇鎖粒度級別。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 reduced localizations can be understood by the effects that grain boundaries promote rotation of grains in shear bands, while the accommodating role of grain boundaries to deformation can be understood by restraining rotation of grains in non - shear bands. from the view of overcoming interlocking between neighboring grains, increasing grain boundaries relative thickness implied grains mutual motion more easily
結果顯示:晶界通過促進剪切帶晶粒轉動而使局部變形不均勻性降低,而通過抑制非剪切帶晶粒轉動使晶界協調變形的作用增大;從克服晶粒互鎖角度看,增大晶界相對厚度使晶粒相對運動更容易。Innodb uses a finer grain of locking mechanism, row - level locking
Innodb使用更小粒度的鎖定機制行級別的鎖定。You can choose to change the locking granularity for some operations
您可以選擇更改某些操作的鎖定粒度。Index locking granularity
索引鎖定粒度For more information about configuring the locking granularity for an index, see
有關為索引配置鎖定粒度的詳細信息,請參閱Use caution, because changing locking granularity can have adverse effects on concurrency
請慎用此操作,因為更改鎖定粒度可能對並發性有負面影響。分享友人