ISUCONでのレポート用シェル。

report.sh

#!/bin/sh
SEC=`date --iso-8601=seconds`
DATE=`date +'%Y%m%d-%H%M%S'`


## NGINX
echo NGINX REPORT

# LTSVなログ前提
LOG_BASE=/home/isucon/tmp

# stat url
URL_STAT=`cat $LOG_BASE/access.log | perl -F"\t" -anle '{($key = $F[3]) =~ s/(req:|HTTP\/1\.1)//g;$key =~ s/[0-9]//g;$key =~ s/ //g;$key =~ s/\//\//g;$c{$key}++;$t{$key}+=substr($F[8],6,5)}END{for(keys %t){print int($t{$_})." ".int($t{$_}/$c{$_}*1000)." ".$c{$_}. " $_";}}' | sort -nr | tee tmp/nginx-repo.txt.${DATE}`
echo "sum sec	ave msec	count	URL"
echo "$URL_STAT" | while read timesum timeave count url; do
    echo "$timesum	$timeave	$count	$url"
done

echo

# count status
STATUS_COUNT=`cat $LOG_BASE/access.log | grep -E '^host' | awk -F '\t' '{gsub(/status:/, "", $5);print $5}' | sort | uniq -c | tee -a tmp/nginx-repo.txt.${DATE}`
echo "count	status code"
echo "$STATUS_COUNT" | while read num status; do
    echo $num	$status
done

# date
mv $LOG_BASE/access.log $LOG_BASE/access.log.${DATE}
touch $LOG_BASE/access.log

# restart
sudo supervisorctl restart nginx &

## MySQL

sudo mv /tmp/mysql-slow.log ~/tmp/mysql-slow.log
sudo chown isucon.isucon ~/tmp/mysql-slow.log
pt-query-digest ~/tmp/mysql-slow.log --explain h=localhost,u=isucon --database=isucon > tmp/ptqd.log.${DATE}
sudo mv ~/tmp/mysql-slow.log ~/tmp/mysql-slow.log.${DATE}

# restart
sudo /etc/init.d/mysql restart &