wa_vmstat_20140220_20.db
site type ip|url|referer|uid|session_id created_at ext1(cpu) ext2(mem)
wa vmstat 2014-02-20 14:57:00 15.9% 80.5%
wa vmstat 2014-02-20 14:58:00 20.0% 90.1%
#!/bin/bash
###
# @author LJ <liujin.chen@qq.com>
# @since 2014-02-28
#
mkdir -p /data/rawlog/sorting/vmstat/
if [ -e /opt/rawlog/sh/site.ini ]; then
site=`cat /opt/rawlog/sh/site.ini`
else
site=`hostname`
fi
type=vmstat
created_at=`date '+%Y-%m-%d %H:%M:%S'`
day=`date '+%Y%m%d_%H'`
cpuidle=`vmstat 1 3 | sed -n '$'p | awk '{print $15}'`
cpu=$[100 - cpuidle]
mem_total=`free -m | sed -n '2p' | awk '{print $2}'`
mem_used=`free -m | sed -n '2p' | awk '{print $3}'`
mem=$((mem_used * 100 / mem_total))
echo $site'|'$type'|||||||'$created_at'|'$cpu'|'$mem >> '/data/rawlog/sorting/vmstat/'$site'_'$type'_'$day'.db'