日志分析

# 生成SQL语句
cat stat.log | grep -v 'grep' | grep 'shareobject=' | sed 's/.*shareobject=//g' | sed 's/;usecond.*,sec=/@/g' | awk -F\@ '{printf "INSERT INTO STAT_LOG(METHOD_NAME, SEC) values(\047%s\047,%s};\n",$1,$2}'

// 初始统计
cat stat.log | grep -v 'grep' | grep 'shareobject=' | sed 's/.*shareobject=//g' | sed 's/;usecond.*,sec=/@/g' > huwl.log

// 按耗时从高到低排序
cat huwl.log | sort -t @ -k 2