Minimizing persistence binding in order to avoid database lock.
最小化持久化绑定,避免数据库依赖。
For example, a lock snapshot captures and returns database lock information.
例如,锁快照捕获并返回数据库锁信息。
Whether or not the acquisition of next triggers to fire should occur within an explicit database lock.
是否明年触发器内发生火灾,应明确数据库锁的收购。
Be sure to verify that no JVMs are running on the database machine before manually removing a database lock file.
在手动删除数据库锁文件之前,请务必确认在数据库机器上没有JVM在运行。
We are now ready to export the data from the NEWSTAFF table, and to simultaneously capture a database lock snapshot.
现在我们已经准备就绪,可以从newstaff表导出数据,并同步捕获数据库锁快照了。
When a database is not properly shutdown (for example, a crash or an abort) an 'orphan' database lock file will be left.
当数据库没有被正确关闭(例如,崩溃或中止)时,就会留下一个“孤立的”数据库锁文件。
In this case, a logical lock (not a physical database lock) is used to flag that a row is in use for a long-term duration.
在本方案中,通过逻辑锁(而不是物理锁)来对在较长时间中使用的数据行进行标记。
What makes operations slow is the fact that the database engine needs to create and delete the database lock file too often.
是什么使操作速度慢是数据库引擎需要创建和删除数据库锁定文件过于频繁的事实。
When mapping regular pages, OS does it on demand and hence will have to acquire both working set and PFN database lock for every page.
当映射常规也的时候,OS按需求,并且会请求工作集锁和PF N数据库锁。
The second property - taking both working set and PFN's database lock only ones enables applications to perform faster and better scalable ramp up.
第二个属性——只要获取工作集锁和PF N数据库锁一个,可以让应用程序运行的更快并且有更好的扩展性。
Caveat 2: Since you use BEGIN rather than BEGIN IMMEDIATE the database lock is not actually taken until the first statement of the transaction is stepped.
注意2:因为你使用BEGIN而不是BEGINIMMEDIATE数据库锁实际上并不是到的第一个语句的事务了。
As described above locked pages have two major properties - they are not considered for paging by OS and during allocation they acquire both working set and PFN database lock only ones.
页锁定有2个主要的属性——他们不会被OS分页并且在分配的时候只会请求工作集锁和PF N锁的一个。
The first section provides information about the date and time of the lock timeout occurrence and about the corresponding instance and database.
第一部分提供与锁定超时发生的日期和时间,以及相应的实例和数据库相关的信息。
There is one lock list per database, and it contains the locks held by all applications concurrently connected to the database.
每个数据库都有一个锁列表,锁列表包含了并发连接到该数据库的所有应用程序所持有的锁。
Another special case of locking is the need to lock something where currently no database row exists.
锁定的另一个特例是需要锁定当前数据库行中不存在的项目。
The database manager determines which locks to escalate by looking through the lock list for the application and finding the table with the most row locks.
数据库管理器通过查看应用程序的锁列表并查找行锁最多的表,来决定对哪些锁进行升级。
Thus, the lock contention is significantly reduced in your database, and your application server has shorter and more discrete units of work, which reduces CPU and JVM memory overhead.
因此,您数据库中的锁争用将明显降低,并且您的应用程序服务器具有更短且更分散的工作单元,这将降低CPU和JVM的内存开销。
The container will load the data with the weakest lock available for the targeted database.
容器将用能被目标数据库接受的最低级锁定来装载数据。
This parameter defines a percentage of the lock list held by an application that must be filled before the database manager performs escalation.
该参数定义数据库管理器执行升级之前必须填入的应用程序所占有锁列表的百分比。
MAXLOCKS defines a percentage of the lock list held by an application that must be filled before the database manager performs lock escalation.
MAXLOCKS定义了应用程序持有的锁列表的百分比,在数据库管理器执行锁升级之前必须填充该锁列表。
The related database parameters for the space where the database maintains the lock information might need to be adjusted.
数据库用于在其中维护锁信息的空间的相关数据库参数可能需要调整。
Optimistic locking is an extremely efficient concurrency control method that guarantees data integrity without placing any physical lock in the database.
乐观锁是一个极其有效的并发性控制方法,它可以确保数据完整性而又无需在数据库中放置任何物理锁。
The result of the messaging engine holding an exclusive lock was that the database maintenance utilities could not be run in the preferred manner, which was to do so for all tables in the database.
消息引擎持有独占锁的结果在于,数据库维护实用工具无法以首选的方式运行,该方式旨在对数据库中的所有表进行维护。
Within Figure 4, the database service is a "backbone" and is experiencing some sort of latency, such as lock contention in the database or network issues.
在图4中,数据库服务是“中枢”,其中存在某种类型的延迟,如数据库中的锁定争用或网络问题。
If the MDB locks resources transactionally (for example, it may lock a database row), these resources will not become unlocked until the end of the batch.
如果MD b以事务的方式锁定资源(例如,它可以锁定数据库行),则在批结束之前,这些资源将保持锁定。
For example, if the database parameter LOCKWAIT is set to 20 seconds, a transaction waiting for a lock is rolled back after 20 seconds of wait time.
例如,如果数据库参数LOCKWAIT 被设置为20秒,一个等待锁的事务在过了 20 秒的等待时间后被回滚。
A soft lock is just a special cache value invalidation representation that stops other transactions from reading or writing to the cache before it gets the new database value.
软锁只是一种特定的缓存值失效表述方式,在它获得新数据库值前阻止其他事务读写缓存。
The normal behaviour of a database access is to get a read lock on the queried data, which gets transformed into an update lock if data is updated.
数据库访问通常会对被查询的数据进行读锁定,在数据更新后会变成更新锁定。
If the "LOCK list memory in use (Bytes)" exceeds 50 percent of the defined LOCKLIST size, then increase the number of 4kb pages in the LOCKLIST database configuration parameter.
如果“LOCKlistmemoryinuse (Bytes)”超过定义的LOCKLIST大小的50%,那么就增加LOCKLIST数据库配置参数中的4k b页的数量。
When the Derby instance connects to a database, a lock is created that helps to enforce these rules.
当Derby实例连接到一个数据库时,就会创建一个锁,以帮助强制实施这些规则。
应用推荐