row lock 中文意思是什麼
row lock
解釋
槳架-
Lock hints rowlock, updlock, and xlock that acquire row - level locks may place locks on index keys rather than the actual data rows
獲取行級別鎖的鎖提示rowlock 、 updlock和xlock ,則可能對索引鍵而不是實際的數據行採用鎖。 -
Serrated lock washers. double row of teeth. plain form
雙排齒鎖緊墊圈.普通型 -
Cumulative number of times the database engine waited on a row lock
數據庫引擎等待行鎖的累積次數。 -
For example, before a sql server database engine task applies shared or exclusive row locks within a table, it places an intent lock on the table
其他用戶可以同時讀取數據,但在釋放所有共享鎖之前,任何事務都不能獲取對該數據的排他鎖。 -
In addition, the system should require all users to change passwords every month or so and should lock out prospective users if they fail to enter the correct password three times in a row
此外,系統也應該要求所有用戶每月上下改變口令,如果用戶連續三次沒有輸入正確的口令,系統應把他們排除在預期的用戶之外。 -
Rid lock on a single row in a table identified by a row identifier
Rid =表中單個行的鎖,由行標識符( rid )標識。 -
Total number of milliseconds the database engine waited on a row lock
數據庫引擎等待行鎖的總毫秒數。 -
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
鎖升級就是將大量較細粒度的鎖(例如行)轉換為少量較粗粒度的鎖(例如表) 。 -
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鎖) 。 -
You can deduce that because the inserted row is the one with an x lock on it - newly inserted rows are locked exclusively until the insert is committed
可以推斷由於插入的行上有x鎖新插入的行獨占性地鎖定,直到插入被提交。 -
After acquiring the stronger lock, all page - and row - level locks held by the transaction on the table are released
得到更強的鎖后,事務在表上所持有的所有頁級及行級鎖都將予以釋放。 -
Blocks until the exclusive lock on the row is freed
在該行上的排他鎖被釋放之前阻塞其他事務。 -
If all is specified when the row or page lock options are set, the settings are applied to all indexes
設置行鎖或頁鎖選項時,如果指定all ,這些設置將應用於所有索引。 -
Specifies that a bulk update table - level lock is acquired for the duration of the bulk load operation ; otherwise, a row - level lock is acquired
指定在大容量加載操作期間獲取大容量更新表級別的鎖;否則,獲取行級別的鎖。 -
Also, an agent cannot wait on itself ; if an agent requests a share lock on a row it is already holding an exclusive lock on, the request is granted because a lock of sufficient or higher mode is already held
同時,一個代理不能等待它自己,如果一個代理對於它已經擁有獨占( x )鎖的行請求一個共享( ns )鎖,那麼這個請求會被授予,因為已經擁有了一個具有足夠或者更高模式的鎖。 -
The output indicates that you are waiting on the lock on the row from the db2pd output because the sts column, which provides the status of the lock request, shows a
輸出表明等待的是db2pd輸出中的行( 0 ; a )上的鎖,因為提供鎖請求狀態的sts列顯示 -
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
如果無法獲取全鎖,當時不會發生鎖升級,而數據庫引擎將繼續獲取行、鍵或頁鎖。
分享友人