Binlog分析工具-binlog_analysis
shell> chmod 755 binlog_analysis
用途：高峰期排查哪些表TPS比较高
代码语言：javascript复制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.000003shell> ./binlog_analysis -H 192.168.188.197 -u admin -p '123456' -d test -s mysql-bin.049622 -e mysql-bin.049628
或
shell> ./binlog_analysis -H 192.168.188.197 -u admin -p '123456' -d test -s mysql-bin.049622
输出结果：
代码语言：javascript复制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}
