binlog解析方法和示例

mysqlbinlog -v -v --base64-output=decode-rows
–start-datetime=‘2018-04-03 02:47:22’ --stop-datetime=‘2018-04-03 02:48:26’ /data/mysql/mysql-bin.003446 | awk
‘/###/{if($0~/UPDATE|INSERT|DELETE/)count[$2""$NF]++}END{for(i in
count)print i,"\t",count[i]}’ | column -t | sort -k3nr | more
DELETEa_xxx.xxx_acct_flow 565330
DELETEa_xxx.xxx_bfj_flow 23595
DELETEa_xxx.xxx_loan_detail 24156
DELETEa_xxx.xxx_pay_log 18475
INSERTa_xxx.xxx_acct_flow_his 576265
INSERTa_xxx.xxx_bfj_flow_his 23829
INSERTa_xxx.xxx_loan_detail_his 24539
INSERTa_xxx.xxx_pay_log_his 18709