#!/bin/bash
dateT=`date +"%Y-%m-%d" -d "-1 days"`
dateN=`date +"%Y%m%d" -d "-1 days"`
DB=count
U=user
P=password
port=63305
H=ip
MYSQL="mysql --skip-column-names --default-character-set=utf8 -u$U -p$P -h $H -P$port $DB"
while read line
do
id=$line
rm -rf /data/test2/temp
cat /data/prod1/*/*/*/$id/*$dateT* >>/data/test2/temp
size=`du -k /data/test2/temp |awk '{print $1}'`
leng=`cat /data/test2/temp |wc -l`
val=$(echo $size $leng | awk '{ printf "%0.2f\n" ,$1/$2}')
$MYSQL <<E1
insert into count_vip (app_id,created,size) VALUES($id,$dateN,$val); ;
E1
done < /usr/messageQuery/appKey
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29754888/viewspace-2121896/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29754888/viewspace-2121896/