Seconds in wait
原创maclean_007 ©著作权
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
The term "seconds in wait" means the number of seconds that a SQL Statement, Database User, etc. was waiting on an event. It is possible that the total number of "seconds in wait" exceeds the total amount of time in the period. The following example will illustrate how this occurs.
Example: Assume that one session locks a row that is needed by ten other sessions. All ten sessions will wait for the lock. Also assume that the session holds the lock for one hour. Since each of the ten sessions waited for one hour, Ignite will show total wait time of ten hours during the one hour period.
The maximum theoretical wait time during a period is the number of session multiplied by the length of the period.

提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
聊聊TCP中的TIME_WAIT
TIME_WAIT 的产生、作用以及优化
TIME_WAIT -
TIME_WAIT过多不自行释放问题
Windows操作系统TIME_WAIT过多不自行释放引发了服务异常!
TIME_WAIT TIME_WAIT不自动释放 netstat -
Seconds习题
【代码】Seconds习题。
java 开发语言 System -
seconds_behind_master
seconds_behind_master参数表示的是本地sql线程和io线程之间的差距时间!这个时间的具体计算方法是根据复制过来的binlog(从机叫做中继日志)里面的timestamp进行对比,每个position都带有timestamp,利用当前sql线程当前pos的timestamp和io线程的timestamp进行对比,得出时间差,就是second_behind_master显示的值。需
seconds_behind_maste 主从复制seconds_behind_m mysql seconds_behind