#!/bin/sh
#
cpu=`grep "^cpu " /proc/stat`
load=`cat /proc/loadavg`
#
host=`hostname`
cpu=`expr match "$cpu" 'cpu  *\(.*\)'`
#
/usr/bin/mysql <<EOCOM
SELECT idx FROM admin_inv.viewhosts WHERE id='$host' OR name='$host' INTO @idx;
INSERT INTO admin_stat.systat(idx,type,date,value) VALUES
	(@idx,'load',NOW(),'$load'),
	(@idx,'cpu',NOW(),'$cpu');
EOCOM