Binlog分析工具-binlog_analysis

usage: binlog_analysis [-h] -H <host> [-P <port>] -u <user> -p <password> -d <database> [-c <charset>] -s <start_index> [-e <end_index>]

Binlog Analysis Tool

options:
  -h, --help            show this help message and exit
  -H <host>, --host <host>
                        the MySQL server host (default: 127.0.0.1)
  -P <port>, --port <port>
                        the MySQL server port (default: 3306)
  -u <user>, --user <user>
                        the MySQL user name
  -p <password>, --password <password>
                        the MySQL password
  -d <database>, --database <database>
                        the database schema name
  -c <charset>, --charset <charset>
                        the MySQL connection character set (default: utf8)
  -s <start_index>, --start <start_index>
                        the start index of binlog files, e.g. mysql-bin.000001
  -e <end_index>, --end <end_index>
                        the end index of binlog files, e.g. mysql-bin.000003

new_qrtz_schedule_job: {'insert': 0, 'update': 82652, 'delete': 0}

withdraw_close_send: {'insert': 185, 'update': 456, 'delete': 0}

api_channel_check_record: {'insert': 306, 'update': 0, 'delete': 0}

user_contract: {'insert': 140, 'update': 140, 'delete': 0}

user_limit_change_log: {'insert': 96, 'update': 96, 'delete': 0}

user_limit_record_log: {'insert': 187, 'update': 0, 'delete': 0}

user_coupon_task: {'insert': 0, 'update': 123, 'delete': 0}