日志统计程序代码,Shell代码库,德仔网

代码语言

代码分类

【Shell】日志统计程序

作者:Foyon / 发布于2012/11/13/ 667

日志统计程序

1 #!/bin/sh
 2 
 3 mday=$(date +%Y%m%d -d "1 day ago")
 4 fday=$(date +%m%d -d "1 day ago")  #filename
 5 filedir=/home/fanhy
 6 
 7 #echo $mday
 8 #cur_dir=$(pwd)
 9 #arg=$1
10 #echo $arg
11 #echo $mday
12 #grep ' unsign' $filedir 
13 #cat $filedir/*.txt|grep 'unsign' > $filedir/test.log
14 grep ' unsign' $filedir/*_$fday.txt | awk -F "total): " '{print $2}'| awk '{a[$1]+=$2}END{for(i in a) if(i>0 && a[i]>0) print "INSERT INTO match_signret_stat(`ma
   tch_id`,`day`,`state`,`num`)VALUES(" i,"," m,"," 2,"," a[i] ");"}' RS=" " FS=":" m=$mday > $filedir/$mday.unsign.sql
15 
16 grep ' sign' $filedir/*_$fday.txt | awk -F "total): " '{print $2}'| awk '{a[$1]+=$2}END{for(i in a) if(i>0 && a[i]>0) print "INSERT INTO match_signret_stat(`matc
   h_id`,`day`,`state`,`num`)VALUES(" i,"," m,"," 1,"," a[i] ");"}' RS=" " FS=":" m=$mday > $filedir/$mday.sign.sql
17 
18 
19 ##mysql insert
20 /usr/bin/mysql -uroot jjstat < $filedir/$mday.unsign.sql;
21 /usr/bin/mysql -uroot jjstat < $filedir/$mday.sign.sql;

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　日志统计　

同语言下

可能有用的

Foyon贡献的其它代码(3)