locking table 中文意思是什麼
locking table
解釋
聯鎖表-
The only locking mechanism used in myisam is the table level locking, which translates that it is not suitable for high - usage environments
Myisam中只有一種鎖定機制,即表級鎖定,因此不適用於訪問比較頻繁的環境。 -
Three - freedom attitude adjusting and locking mechanism of spacecraft docking test table
航天器對接試驗臺三軸姿態調整鎖定機構研究 -
If table locking is specified, the default setting for the table set with
使用表級鎖定如果指定了表鎖定,則使用 -
If table locking is not used, the default uses row - level locks, unless the
如果未使用表鎖定,默認使用行級鎖定,除非 -
Table locking behavior
表鎖定行為 -
Locking table hints to specify the level of locking for an individual reference of a table in a from clause
鎖定表提示用於指定在from子句中表的單個引用的鎖定級別。 -
Specifies that the query optimizer use a table scan, one or more indexes, or a locking method with this table or view and for this select, insert, update, or delete statement
指定查詢優化器使用一個表掃描、一個或多個索引,或為當前表或視圖以及當前的select 、 insert 、 pdate或delete語句使用鎖定方法。 -
When used with the openrowset bulk rowset provider to import data into a table without indexes, tablock enables multiple clients to concurrently load data into the target table with optimized logging and locking
如果與openrowset大容量行集提供程序一起用於將數據導入無索引的表,則tablock將啟用多個客戶端,同時將數據加載到包含優化日誌記錄和鎖定的目標表中。 -
Using tablock causes a table - level lock to be taken for the duration of the bulk operation and eliminates the overhead of locking individual rows
使用tablock會導致在大容量操作期間進行表級鎖定,並消除按行鎖定的開銷。 -
No table - wide locking is needed or even possible to provide thread - safety when iterating the collection
在對集合進行迭代時,不需要表范圍的鎖就能提供線程安全性。 -
Readpast is primarily used to reduce locking contention when implementing a work queue that uses a sql server table
使用sql server表實現工作隊列時, readpast主要用於減少鎖定爭用。 -
By default, locking behavior is determined by the table option
默認情況下,鎖定行為由表選項 -
Returns current low - level i o, locking, latching, and access method activity for each partition of a table or index in the database
返回數據庫中表或索引的每個分區的當前低級i / o 、鎖定、閂鎖和訪問方法活動。 -
Importing data in parallel with table level locking
>使用表級鎖定并行導入數據 -
Table - level locking hints can be used when a finer control of the types of locks acquired on an object is required
當需要對對象所獲得鎖類型進行更精細控制時,可以使用表級鎖提示。
分享友人