HVR Log Analysis Simple application

Source: Internet
Author: User

From other places to get the database synchronization log, such as: 123.out, if you want to know the general information of synchronization, such as how many DML synchronization, then you can use the command: Hvrstatustics.

Example:

Hvrstatistics-f E:\123.out

Example output:

Captured Inserts:11437captured updates:146390captured deletes : 7449Captured rows:311666integrated Inserts:6926inte            Grated updates:101502integrated deletes:7122integrated Changes : 115550DBMS Log rows:623332captured Transactions:72327integrat                Ed Transactions:30426transactions logged in Dbms:144654maximum Capture change speed: 1Average Integrate change speed:146total Capture duration:304933maximum Capt              Ure duration:31total integrate duration:789maximum integrate Duration:               235Average Integrate Duration:0capture cycles:43251integrate Cycles         :   34559Routed bytes:31947549routed Bytes (uncompressed): 443118651Capture Log Bytes               Read:18994689392dbms Log Bytes written:37989378784maximum Compression Ratio: 99Average Compression ratio:92minimum capture Latency:0maximum capture Latenc Y:158760minimum integrate Latency: -1682maximum integrate latency:5256 Number of Errors:822last 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.


HVR Log Analysis Simple application

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.