本文提供三支 Shell 腳本,用於定期蒐集 Linux 系統的負載、CPU 使用率與磁碟 I/O 資訊,並自動匯總寫入 MySQL 資料庫,適合建立效能監控基礎設施。
#!/bin/sh
host=$(hostname)
channel=$(hostname | sed 's/[0-9]//g')
runday=$(date +%Y-%m-%d)
IPhost=$(/sbin/ifconfig | grep 'inet addr:' | grep -v '127.0.0.1' | cut -d: -f2 | awk '{print $1}')
i=1
while [ $i -le 120 ]; do
rundaytime=$(date "+%Y-%m-%d %H:%M:%S")
# 負載資訊
/bin/cat /proc/loadavg | awk -F " " '{print "'"$rundaytime"'","$1","$2","$3","$4","$5}' >> /tmp/${host}-${runday}load.txt
# CPU 使用率
/usr/bin/sar -u 1 1 | grep -v Average | sed -n '4,$p' | awk -F " " '{print "'"$rundaytime"'","$4","$6","$7","$9}' >> /tmp/${host}-${runday}sar.txt
i=$((i+1))
sleep 59
done
# 整理格式並加入主機資訊
awk -F "," '{print "'"$host"'","'"$channel"'","'"$IPhost"'",$1,$2,$3,$4,$5}' /tmp/${host}-${runday}sar.txt > /tmp/${host}${runday}sar.txt
awk -F "," '{print "'"$host"'","'"$channel"'","'"$IPhost"'",$1,$2,$3,$4,$5,$6}' /tmp/${host}-${runday}load.txt > /tmp/${host}${runday}load.txt
rm -f /tmp/${host}-${runday}sar.txt /tmp/${host}-${runday}load.txt
#!/bin/sh
PDIR=/monitor/nagios/shell/sarlog
runday=$(date +%Y-%m-%d)
TmpDir=/monitor/nagios/tmp
for i in `/bin/cat /monitor/nagios/shell/sarlog/machine.lst`
do
/usr/bin/scp ${PDIR}/sarlog.sh ${i}:/root && /usr/bin/rsh ${i} /root/sarlog.sh &
done
#!/bin/sh
PDIR=/monitor/nagios/shell/sarlog
runday=$(date +%Y-%m-%d)
TmpDir=/monitor/nagios/shell/sarlog/log
Machinelst=/monitor/nagios/shell/sarlog/machine.lst
for i in `/bin/cat $Machinelst`
do
/usr/bin/scp ${i}:/tmp/*${runday}sar.txt ${TmpDir}
/usr/bin/scp ${i}:/tmp/*${runday}load.txt ${TmpDir}
done
/bin/cat ${TmpDir}/*${runday}sar.txt >> ${TmpDir}/Tmp${runday}.txt
/bin/cat ${TmpDir}/*${runday}load.txt >> ${TmpDir}/${runday}loadResult.txt
count=1
Line=$(cat ${TmpDir}/Tmp${runday}.txt | wc -l)
> ${TmpDir}/Result${runday}.txt
while [ "$count" -le "$Line" ]
do
Idle=$(sed -n "${count}p" ${TmpDir}/Tmp${runday}.txt | awk -F "," '{print $8}')
Busy=`echo "scale=2;100-$Idle" | bc`
sed -n "${count}p" ${TmpDir}/Tmp${runday}.txt | sed "s/$/,$Busy/g" >> ${TmpDir}/${runday}sarResult.txt
let count=count+1
done
/usr/local/mysql/bin/mysql -u root -D nagios -pbj7n48dM <
machine.lst 列出所有被監控主機 IP/主機名。t_daily_stats、t_daily_load 需預先建立對應欄位。crontab 定時執行腳本 2 與 3,建立自動化監控流程。此套腳本採用 sar、/proc/loadavg 等標準 Linux 工具,輕量且無需額外代理程式,適合中小型叢集的效能基線建立。