binglog日志分析工具

xyaxlz

脚本名字：binlog_analysis.sh

 

脚本做用:统计update,insert,delete,replacealter，每个语句执行的次数

代码:

1. #!/bin/sh
   
2. 
   
3. LOGFILE=$1
   
4. [ -z "{$LOGFILE}" ] && echo "ERROR: Specify Binary Log to analyze" && exit 1
   
5. 
   
6. mysqlbinlog $LOGFILE | grep -i -e "^update" -e "^insert" -e "^delete" -e "^replace" -e "^alter" | \
   
7.    cut -c1-100 | tr '[A-Z]' '[a-z]' | \
   
8.    sed -e "s/\t/ /g;s/\`//g;s/(.*$//;s/ set .*$//;s/ as .*$//" | sed -e "s/ where .*$//" | \
   
9.    sort | uniq -c | sort -nr
   
10. 
    
11. #awk 'BEGIN {total=0}{total=total+ $1}END{print total}' file
    
12. exit 0