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等待时间。
应用推荐