关于OGG stats 命令的解释

时间:2015-04-13 23:00:10   收藏:0   阅读:910
GGSCI (gg321) 19> stats extqd

Sending STATS request to EXTRACT EXTQD ...

Start of Statistics at 2015-04-18 17:53:06.

Output to /u02/ggs/dirdat/qd:

Extracting from usera.taba to usea.taba:

*** Total statistics since 2015-04-18 17:38:42 ***
        Total inserts                                0.00
        Total updates                                2.00
        Total befores                                1.00
        Total deletes                                5.00---->此处的5表示:5条受到delete影响的记录 或者说被delete 掉的5条记录。而被delete 掉的这5条记录,可以是由一个delete语句造成的。
        Total discards                               0.00
        Total operations                             8.00

*** Daily statistics since 2015-04-18 17:38:42 ***
        Total inserts                                0.00
        Total updates                                2.00
        Total befores                                1.00
        Total deletes                                5.00
        Total discards                               0.00
        Total operations                             8.00

*** Hourly statistics since 2015-04-18 17:38:42 ***
        Total inserts                                0.00
        Total updates                                2.00
        Total befores                                1.00
        Total deletes                                5.00
        Total discards                               0.00
        Total operations                             8.00

*** Latest statistics since 2015-04-18 17:38:42 ***
        Total inserts                                0.00
        Total updates                                2.00
        Total befores                                1.00
        Total deletes                                5.00
        Total discards                               0.00
        Total operations                             8.00

End of Statistics.


 

原文:http://blog.csdn.net/msdnchina/article/details/45031801

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!