国内最全IT社区平台 联系我们 | 收藏本站
华晨云阿里云优惠2
您当前位置:首页 > 数据库 > 数据库应用 > HVR日志分析简单应用

HVR日志分析简单应用

来源:程序员人生   发布时间:2016-06-08 17:44:50 阅读次数:3167次

从其他地方拿到数据库的同步日志,如:123.out,如果想知道同步的大体信息,比犹如步了多少DML等,那末可使用命令:hvrstatustics弄定。

示例:

hvrstatistics -f e:\123.out

示例输出:

Captured Inserts : 11437 Captured Updates : 146390 Captured Deletes : 7449 Captured Rows : 311666 Integrated Inserts : 6926 Integrated Updates : 101502 Integrated Deletes : 7122 Integrated Changes : 115550 DBMS Log Rows : 623332 Captured Transactions : 72327 Integrated Transactions : 30426 Transactions Logged in DBMS : 144654 Maximum Capture Change Speed : 1 Average Integrate Change Speed: 146 Total Capture Duration : 304933 Maximum Capture Duration : 31 Total Integrate Duration : 789 Maximum Integrate Duration : 235 Average Integrate Duration : 0 Capture Cycles : 43251 Integrate Cycles : 34559 Routed Bytes : 31947549 Routed Bytes (uncompressed) : 443118651 Capture Log Bytes Read : 18994689392 DBMS Log Bytes Written : 37989378784 Maximum Compression Ratio : 99 Average Compression Ratio : 92 Minimum Capture Latency : 0 Maximum Capture Latency : 158760 Minimum Integrate Latency : ⑴682 Maximum Integrate Latency : 5256 Number of Errors : 822 Last Error : 2016-04-05 18:04:22: u_by-cap-by: F_JG2111: Connect to host '172.15.0.6' and port 4343 for coprocess 'u_by-cap-by' failed. Error: WSAECONNREFUSED: Connection refused.


生活不易,码农辛苦
如果您觉得本网站对您的学习有所帮助,可以手机扫描二维码进行捐赠
程序员人生
------分隔线----------------------------
分享到:
------分隔线----------------------------
关闭
程序员人生