awk mysql

mysqlbinlog --no-defaults --base64-output=decode-rows -v -v mysql-bin.000002 |awk '/###/{if($0~/UPDATE|INSERT|DELETE/)count[$2" "$NF]++}END{for(i in count)print i,"\t",count[i]}'|column -t|sort -k3nr|more

posted @ 2019-01-04 15:43  滴滴滴  阅读(201)  评论(0编辑  收藏  举报