cat /opt/shell/serviceStatus.sh

#!/bin/bash
HOSTNAME="10.23.119.16" 
PORT="3306"
USERNAME="monitorpico"
PASSWORD="4F8821D6385A532D@ggaq"
DBNAME="nagios" 
TABLENAME="lion_service_status" 
MENUSED=`free -m | awk 'NR==3' | awk '{print $3}'`
MENFULL=`free -m | awk 'NR==2' | awk '{print $2}'`
MENALL="all ${MENFULL} , used ${MENUSED}"
SERVICEIP="10.23.119.30"
CPUUSED=`top -b -n 1 |grep 'Cpu(s)'|awk '{print $2}'|awk -F '%' '{print $1}'`
CPUFREE=`top -b -n 1 |grep 'Cpu(s)'|awk '{print $5}'|awk -F '%' '{print $1}'`
LOADSTATUS=`uptime |awk '{print $6,$7,$10,$11,$12}'`
DISKALL=`df -lh|awk '{print $1,$2,$3,$4,$5}'`
CPUALL="used ${CPUUSED}% ,free ${CPUFREE}%"
insert_sql="insert into ${TABLENAME} (ip,cpu,men,disk,showtime,loadavg) values('${SERVICEIP}','${CPUALL}','${MENALL}','${DISKALL}',NOW(),'$LOADSTATUS')"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${insert_sql}"