萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> 程式語言綜合

Shell 腳本監控磁碟 I/O 與系統負載,並寫入 MySQL

本文提供三支 Shell 腳本,用於定期蒐集 Linux 系統的負載、CPU 使用率與磁碟 I/O 資訊,並自動匯總寫入 MySQL 資料庫,適合建立效能監控基礎設施。

腳本 1:本機持續蒐集負載與 CPU 資料

#!/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

腳本 2:分發蒐集腳本至多台主機並行執行

#!/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

腳本 3:收集遠端資料、計算忙碌度並匯入 MySQL

#!/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/主機名。
  • 確保主控機器可透過 SSH/RSH 免密碼登入被監控機。
  • MySQL 資料表 t_daily_stats、t_daily_load 需預先建立對應欄位。
  • 可透過 crontab 定時執行腳本 2 與 3,建立自動化監控流程。

此套腳本採用 sar、/proc/loadavg 等標準 Linux 工具,輕量且無需額外代理程式,適合中小型叢集的效能基線建立。

copyright © 萬盛學電腦網 all rights reserved