HVR日志分析简单应用
来源:程序员人生 发布时间:2016-06-08 17:44:50 阅读次数:3219次
从其他地方拿到数据库的同步日志,如: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.
生活不易,码农辛苦
如果您觉得本网站对您的学习有所帮助,可以手机扫描二维码进行捐赠