请问如何加快shell处理日志文件的速度
我想请问大家一下,如何加快处理脚本文件的速度,脚本代码如下,感激!
insert_nat(){
echo $1 $2
v=""
sed 's/DF//g'
for((i=1; i<=$2; ++i))
do
((row=$i+$1))
values=($(awk -F '[= ]' 'NR=='$row' {print $3, $12, $14, $16, $26, $28, $30}' /var/log/natLog-$YESTERDAY))
src_ip=${values[1]}
dst_ip=${values[2]}
len=${values[3]}
proto=${values[4]}
src_port=${values[5]}
dst_port=${values[6]}
record_time=$(date -d "YESTERDAY ${values[0]}" +%s)
v="(inet_aton("\"$src_ip\""),
cast("\"$src_port\"" as signed),
inet_aton("\"$dst_ip\""),
cast("\"$dst_port\"" as signed),
"\"$proto\"",
cast("\"$len\"" as signed),
cast("\"$record_time\"" as unsigned)), "${v}
done
mysql -u$DBUSER -p$DBPASSWD tzw -e "insert into tzw_nat_log(src_ip, src_port, dst_ip, dst_port, proto, len, record_time)
values${v%,*}"
}