If table locking is not used, the default USES row - level locks, unless the.
如果未使用表锁定,默认使用行级锁定,除非。
If you know that exclusive access will not cause problems, by all means use table locking.
如果知道独占访问不会导致问题,那么就应该尽量使用表锁。
The first thing every contestant needed to do was change every table to row-level locking.
每位参赛者需要做的第一件事是将每个表更改为行级别锁定。
In other words, we have sequentially scanned this table, locking every row, a lot of times.
换句话说,我们顺序地扫描了此表,锁定了每个行,操作进行了很多次。
We add an extra integer column to the table for which optimistic locking is required; this holds a revision counter.
向要使用乐观锁定的表中添加一个额外的整数列;该列保存修订计数器。
Concurrency control Supports table and row level locking.
并发控制支持表级和行级锁。
When scanning an MDC table, block locking could be deferred for an index scan.
当扫描一个mdc表时,对于索引扫描,块锁可以推迟。
Supports table and row level locking.
支持表级和行级锁。
The LOCK TABLE command can be used to lock a table instead of using the default row locking.
可使用LOCKTABLE命令来锁定一个表,而不是使用缺省的行锁定。
However, the schema of the table also affects the behavior of optimistic locking.
然而,表模式也会影响乐观锁定的行为。
Deferred locking did not occur on a table which was executing an online table reorganization.
被推迟的锁不会发生在正在执行在线表重组的表上。
Alter the locking granularity of a table.
改变表的锁定粒度。
If only a single type of lock can be associated with the given table, then it may make sense to add extra columns to the original table to control the locking.
如果只有单一类型的锁关联到给定表,那么可以添加额外的列到原始表中来控制锁定。
No table-wide locking is needed (or even possible) to provide thread-safety when iterating the collection.
在对集合进行迭代时,不需要表范围的锁就能提供线程安全性。
A pessimistic locking strategy assumes that the probability is high that another user will try to modify the same row in a table that you are changing.
悲观锁定策略的前提是,另一个用户很可能试图修改您正在修改的某个表行。
When having duplicate rows in the lock table (see the Create a DB2 table for resource locking section), concurrent use of the resource is possible.
如果锁表中有重复的行(参见为资源锁定创建一个DB 2表一节),就可以对资源进行并发使用。
Row locking with escalation to table locks.
行锁定,具有到表锁的升级。
Create a DB2 table for resource locking.
为资源锁定创建一个db2表。
Supports table and row level locking and 4 isolation levels, RR (repeatable read), rs (read stability), CS (default - cursor stability) and ur (uncommitted read).
支持表级和行级锁以及4个隔离级别:RR(可重复读)、RS(读可靠)、CS(默认——游标可靠)和UR(未提交读)。
During an export operation, row-level locking is applied to the exporting table, which means that only one lock is held at a time.
在导出操作期间,行级别锁定应用于导出表(exportingtable),这意味着一次只持有一个锁。
Create a DB2 table (hereafter referred to as lock table) to define the resources related to session locking.
创建一个db2表(在下文中称为锁表(locktable)),它定义与会话锁定相关的资源。
The next statement tells Grails that the table does not have a version column. (GORM normally creates one to help facilitate optimistic locking.)
下一条语句通知Grails表没有version列(GORM通常会创建一个 version列来优化乐观锁定)。
If many transactions will be updating individual rows, change to row locking mode for a particular table using the following SQL statement.
如果许多事务将更新一些单独的行,则使用下列sql语句将特定表更改为rowlocking模式。
Our first major problem is that we are scanning the full bills table every time we want a row out of it and locking every row we read.
我们的第一个主要问题是,当我们想要一行的内容时,我们会扫描整个账单表,并锁定我们读取的每一行。
This locking was done for both index scans and table access whether or not the row of data was committed or whether it would have been excluded based on the statement's predicates.
不管数据行是否被提交,以及根据语句的谓词它是否被排除,对于索引扫描和表访问都执行这样的锁定操作。
However, block locking was not be deferred for table scans.
然而,对于表扫描,块锁不会推迟。
Some databases (such as SQL Server) allow you to disable the page-level locking in hopes that it won't escalate from a row-level lock to a table-level lock.
一些数据库(比如sqlServer)允许您禁用页面级锁,以期它不会从行级锁切换到表级锁。
Locking escalation to page-level or table-level locking.
从页面级锁升级到表级锁。
Locking TLB entries can ensure that a memory access to a given region never incurs the penalty of a page table walk.
锁定TLB输入能确保对于给出区域的内存读取绝不会导致页表移动的掉失。
Lock the entire table before saving (pessimistic locking).
保存(悲观锁)之前锁定整个表。
应用推荐