程序员人生 网站导航

HVR日志分析简单应用

栏目:数据库应用时间:2016-06-08 17:44:50

从其他地方拿到数据库的同步日志,如: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.


------分隔线----------------------------
------分隔线----------------------------

最新技术推荐