按小时统计unix机器内存和cpu使用率
给脚本赋权限
chmod 755 *.sh
后台执行该脚本
nohup sum_capa.sh &
x=0
totMem=`vmstat | grep 'mem=' | awk -F\= '{ print $3 }' | awk -F\M '{print $1 }'`
totMem1=` echo "$totMem * 200 " | bc `
while true
do
strDate=`date +"%Y%m%d"`
strTime=`date +"%Y%m%d%H"`
strRun=`vmstat 1 4 | tail -1 | awk '{ print " "$3" "$14" "$15 }' `
echo $strTime" "$totMem1$strRun >> capa_$strDate.txt
sleep 56
x=`expr $x + 1`
if [ $x -gt 3000 ]
then
break
fi
done
三天后得到统计数据,执行该脚本 get_capa.sh
if [ "$#" -ne 1 ]
then
echo "Usage:get_capa.sh yyyymmdd"
exit 1
fi
echo "Hour Mem(%) Cpu(%) " > capa_hour_$1.txt
hh="00"
x=0
while true
do
if [ x -lt 10 ]
then
hh="0"$x
else
hh=$x
fi
strTmp=`grep $1$hh capa_$1.txt | awk 'BEGIN{allMem=0;useMem=0;memRate=0;cpuRate=0;num=0;allCpu=0;} { allMem=allMem+$2;useMem=useMem+$3;num=num+1;allCpu=allCpu+$4+$5;} END{ if (allMem>0) { memRate=useMem*100/allMem;cpuRate=allCpu/num;} print memRate" "cpuRate}'`
echo $hh" "$strTmp >> capa_hour_$1.txt
x=`expr $x + 1`
if [ $x -gt 23 ]
then
break
fi
done
cat capa_hour_$1.txt
统计交易量 sum_tran.sh
if [ "$#" -ne 3 ]
then
echo "Usage:sum_tran.sh yyyy mm dd"
exit 1
fi
echo "Hour Trans" > tran_hour_$1$2$3.txt
hh="00"
x=0
while true
do
if [ x -lt 10 ]
then
hh="0"$x
else
hh=$x
fi
num=`grep TxRunAction /usr/IBM/HTTPServer/logs/access.$1.$2.$3.log|grep $1":"$hh |wc -l`
echo $hh" "$num >> tran_hour_$1$2$3.txt
x=`expr $x + 1`
if [ $x -gt 23 ]
then
break
fi
done
cat tran_hour_$1$2$3.txt
num=`cat /usr/IBM/HTTPServer/logs/access.$1.$2.$3.log | wc -l`
echo "TotTrans="$num
num=`grep TxRunAction /usr/IBM/HTTPServer/logs/access.$1.$2.$3.log|wc -l`
echo "TxRunTrans="$num
num=`grep LinkageTX /usr/IBM/HTTPServer/logs/access.$1.$2.$3.log|wc -l`
echo "LinkTrans="$num
统计20w数据表 db_20w.sh
if [ "$#" -ne 1 ]
then
echo "Usage:db_20w.sh ddmmyyyy"
exit 1
fi
db2 "connect to ecap "
db2 "select count(*) from ecapdb.t_tran_log where HEAD_DATE='"$1"' "