统计Mysql的Binlog语句执行次数
mysqlbinlog --no-defaults --base64-output=decode-rows -v -v 4299-binlog.002039 | awk '/###/ {if($0~/UPDATE|INSERT|DELETE/)count[$2" "$NF]++}END{for(i in count) print i,"\t",count[i]}' | column -t | sort -k3nr
统计Mysql的Binlog语句执行次数
mysqlbinlog --no-defaults --base64-output=decode-rows -v -v 4299-binlog.002039 | awk '/###/ {if($0~/UPDATE|INSERT|DELETE/)count[$2" "$NF]++}END{for(i in count) print i,"\t",count[i]}' | column -t | sort -k3nr