Either way, the lock wait was a surprise, and the user did not know how to figure out what was going on.
不管是什么原因,这个锁等待是一个意外,用户不知道如何发现到底发生了什么事情。
As all rows in the EMPLOYEE table are X-locked by the first transaction, the second application goes into lock wait mode.
由于employee表中的所有行都被第一个事务独占锁定,第二个应用程序进入了锁等待模式。
The frequency TAB shows the list of SQL statements with their frequency of execution along with the average response time, lock wait, and wait IO time.
Frequency选项卡按执行频率列出sql语句并显示平均响应时间、锁等待时间和IO等待时间。
Lock wait Time: Time the system waited for locks during SQL statement.
Lock WaitTime:在执行此sql语句期间系统等待锁的时间。
Lock wait Time: Time spent waiting for locks during this SQL statement in seconds.
Lock WaitTime:在执行此sql语句期间等待锁花费的时间(以秒为单位)。
Applications on active members trying to access the locked data on the failing member are briefly in a lock-wait state, and by default they do not receive any errors.
当尝试访问出错成员上被锁定的数据时,活跃成员上的应用会暂时处于锁定等待状态,而且默认情况下他们不会收到任何错误。
Applications on active members trying to access the locked data on the failing member are briefly in a lock-wait state, and by default they do not receive any errors.
当尝试访问出错成员上被锁定的数据时,活跃成员上的应用会暂时处于锁定等待状态,而且默认情况下他们不会收到任何错误。
应用推荐