stat_hour.sh

shell脚本包

#!/bin/sh
HOST="61.13.19.20"
TZ=GMT-7
export TZ
QUERYTIME=`date +"%F:%H"`
LOGFILE="/usr/local/ndms/logs/httpd/access_log.$QUERYTIME"
awk -F"GET" '{print $2}' $LOGFILE |awk '{print $1}'|grep '/*.html'|awk -F"?" '{print $1}'|sort|uniq -c>/tmp/stat_hour_num.tmp  
while read NUM URL 
do
        #echo  $URL $NUM
      /usr/local/mysql4024/bin/mysql -h 6.16.7.1 -u username -ppassword mydatabase -e "insert into advacct values ('$QUERYTIME','$HOST','$URL','$NUM');"
done  </tmp/stat_hour_num.tmp