-
이제 .rrd파일에 저장된 데이터를 가지고 그래프를 그릴 차례다. 아래와 같이 실행해보자.
windy@wl ~ $ rrdtool graphv load-day.png \
--title "Load Average" \
--vertical-label "# of procs in run q" \
--start -1d \
--width 400 \
--height 100 \
--lower-limit 0 \
--units-exponent 0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
--zoom=2 \
"DEF:1min=load.rrd:1min:AVERAGE" \
"DEF:5min=load.rrd:5min:AVERAGE" \
"DEF:15min=load.rrd:15min:AVERAGE" \
"CDEF:c1min=1min" \
"CDEF:c5min=5min" \
"CDEF:c15min=15min" \
"AREA:c1min#54EC48:1 MIN" \
"LINE:c5min#4D18E4:5 MIN" \
"LINE:c15min#DE48EC:15 MIN"
graph_left = 67
graph_top = 28
graph_width = 400
graph_height = 100
image_width = 482
image_height = 168
graph_start = 1551061612
graph_end = 1551148012
value_min = 0.0000000000e+00
value_max = 2.3145188000e+00
legend[0] = " 1 MIN"
coords[0] = "16,148,65,161"
legend[1] = " 5 MIN"
coords[1] = "213,148,262,161"
legend[2] = " 15 MIN"
coords[2] = "410,148,466,161"
아래와 유사한 그래프가 그려질 것이다.
그래프를 그릴 때 몇가지 유용한 옵션에 대해 설명한다.
--title: 제목을 정의한다.--vertical-label: 세로로 된 레이블을 정의한다.--start: 그래프의 시작 위치를 정의한다. -1d는 1일 전을 의미한다. 이외는 별개로 --end를 지정해 그래프의 종료 위치를 정의할 수 있다.--width, --height: 그래프의 너비와 높이를 지정한다. 생성되는 이미지는 그래프 외에 타이틀과 범례를 포함하기 때문이 이보다 크며, 실제 이미지 크기는 이 명령의 출력값이다. (481px X 173px)--lower-limit: 최저값을 정의한다. 로드 평균은 0이 최저값이기 때문에 0으로 정의한다.--upper-limit: 최대값을 정의한다. 로드 평균의 최대값은 정해지지 않았기 때문에 지정하지 않는다.--logarithmic: 플롯에 로그함수를 사용한다. 값의 편차가 클 때 사용해볼만 하다.--base: 기본배수가 되는 값을 지정한다. 지정하지 않으면 1000이다. 메모리의 양이나 디스크및 볼륨의 양을 표시할 때에는 1024로 지정해야 한다. 네트워크 트래픽을 포함한 그외의 경우는 1000으로 지정해야 한다.--rigid: 지정한 상한과 하한값을 사용해 그래프를 그린다. 그래프가 오버런 되도록 한다.--units-exponent: 사용할 유닛의 배수를 지정한다. 0은 비활성화 시킨다. 로드 평균은 k, m, g 등으로 변환하지 않고 그대로 보여주는 것이 좋기 때문에 0으로 세팅한다.--alt-autoscale-max: 최대값을 계산하는 알고리즘을 기본 알고리즘이 아닌 다른 알고리즘을 사용하도록 한다. 좀 더 자세하게 계산하지만, 약간 더 느려진다. 필자의 생각으로는 감안할 수 있는 범위로 생각한다.--disable-rrdtool-tag: 그래프 오른쪽의 rrdtool 태그를 출력하지 않는다.--zoom: 주어진 값 만큼 확대. 높은 DPI를 가진 디스플레이에서 그래프를 봐야할 때 이 옵션을 주어야 한다.- 데이터 구문
DEF: 데이터를 정의한다. 아래와 같은 구문을 가진다.
DEF:<vname>=<rrdfile>:<ds-name>:<CF>[:step=<step>][:start=<time>][:end=<time>][:reduce=<CF>][:daemon=<address>]
예를 들어 DEF:5mind=load.rrd:5min:LAST의 의미는 load.rrd파일에서, DS=5min 및 RRA=LAST
로 저장된 데이터를 5mind
로 정의한다.VDEF: 가상 데이터를 정의한다. 아래와 같은 구문을 가진다.
VDEF:vname=RPN expression
예를 들어 VDEF:xa=x,AVERAGE의 의미는 x의 평균값을 구한다.
CDEF: 정의된 데이터를 RPN식을 사용해 수정한다. 아래와 같은 구문을 가진다.
CDEF:vname=RPN expression
위의 예제에서는 변환하지 않고 그대로 사용하지만, 데이터를 변환할 수 있다. 예를 들어 5mind 값에 20을 더한후 10을 곱하고 싶다면 (5mind + 20) × 10
이므로 CDEF:c5mind=5mind,20,+,10,*와 같이 적으면 된다.
- 그래프 구문
LINE: 데이터를 선으로 그린다. 아래와 같은 구문을 가진다.
LINE[width]:value[#color][:[legend][:STACK][:skipscale][:dashes[=on_s[,off_s[,on_s,off_s]...]][:dash-offset=offset]]]
예를 들어 LINE:5mind#C0FFC0:5MIN의 의미는 5mind
로 정의된 데이터를 #C0FFC0
(■) 색상으로 LINE을 그리고, 5MIN
이라 명명한다.
AREA: 데이터를 영역으로 그린다. 아래와 같은 구문을 가진다.
AREA:value[#color][:[legend][:STACK][:skipscale]]
예를 들어 AREA:15mind#C0C0C0:15MIN의 의미는 15mind
로 정의된 데이터를 #C0C0C0
(■)색상으로 AREA
형식으로 그리고, 15MIN
이라 명명한다.
TICK: 틱 영역을 그린다. 아래와 같은 구문을 가진다.
TICK:vname#rrggbb[aa][:fraction[:legend]]
예를 들어 TICK:value#FFFFA0의 의미는 value 이 0이 아니고 Unknown 이 아닌 경우 #FFFFA0
(■)색상의 수직 라인을 그린다.
STACK: STACK구문은 사용하지 않는다. 기존에는 AREA형식으로 쌓아올리는 그래프를 그리는 구문이었으나, 현재는 LINE, AREA 구문에 통합되어있다.
- 그래프상의 텍스트가 □ 처럼 보이면, 시스템의 폰트설정이 제대로 되어있는지 확인해보자. 솔라리스 11.4 의 경우 기본설치시 폰트가 설치되지 않는데, 이런 경우
~/.fonts 에 폰트 파일(.ttf)을 넣어 설정하면 된다. 그래프를 그릴때 사용하는 폰트를 바꾸려면, RRD_DEFAULT_FONT환경변수를 설정한다. RRD_DEFAULT_FONT="sample.ttf"과 같이 설정하고 sample.ttf 파일을 ~/.fonts 에 넣으면 된다.
DEF 에서 AVERAGE만 지정하면, 그래프의 해상도와 기간에 따라 RRA중에 최적의 값을 선택해 그래프를 생성한다. 너비가 400이며, 1일간의 그래프를 그리기 때문에 RRA:AVERAGE:0.5:1:1440으로 그래프를 그릴 것이다.
-
RRDtool 에서는 LSLSLOPE, LSLINT 식을 사용해 미래의 예측 데이터를 그릴 수 있다. (하기 예제에서 rrdtool_volstat_rpool.rrd파일은 문서 하단에 설명되어있는 rrdtool_volstat.sh 스크립트를 사용해 생성한 파일이다)
windy@wl ~ $ export FN="rrdtool_volstat_rpool.rrd"
windy@wl ~ $ rrdtool graph rrdtool_lsl.png \
--start -4w \
--end +4w \
--vertical-label "Volume Usage" \
--title "Volume Usage root@wl" \
--width 500 \
--height 100 \
--base 1024 \
--lower-limit 0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:TOTAL=$FN:TOTAL:AVERAGE" \
"DEF:USAGE=$FN:USAGE:AVERAGE:start=-8w" \
"CDEF:CTOTAL=TOTAL,1024,*" \
"CDEF:CUSAGE=USAGE,1024,*" \
"CDEF:CTOTAL60=TOTAL,0.6,*,1024,*" \
"CDEF:CAREAW=CUSAGE,CTOTAL60,GT,CUSAGE,0,IF" \
"CDEF:CAREAU=CUSAGE,CTOTAL60,GT,CTOTAL60,CUSAGE,IF" \
"VDEF:DLSL=CUSAGE,LSLSLOPE" \
"VDEF:HLSL=CUSAGE,LSLINT" \
"CDEF:ALSL=CUSAGE,POP,DLSL,COUNT,*,HLSL,+" \
"AREA:CAREAW#EC9D48" \
"AREA:CAREAU#68E4FC" \
"LINE:CUSAGE#1598C3:root Usage" \
"GPRINT:CUSAGE:AVERAGE:%.1lf %S" \
"LINE:CTOTAL#CC3118:root Total" \
"GPRINT:CTOTAL:AVERAGE:%.1lf %S" \
"LINE:ALSL#B415C7:root Usage Pred:dashes=5"
강조된 부분이 LSL 예측에 필요한 파라메터들이다. 아래와 유사한 그래프가 생성되며, 분홍 점선이 LSL 을 사용해 예측한 값이다. 현재 시간 이후 4주차까지 예측해 그렸다.
-
LSL외에도 PREDICT 식을 사용해 미래의 예측 데이터를 그릴 수 있다. (하기 예제에서 rrdtool_net_net.rrd파일은 문서 하단에 설명되어있는 rrdtool_net.sh 스크립트를 사용해 생성한 파일이다)
windy@wl ~ $ export FN="rrdtool_net_net.rrd"
windy@wl ~ $ rrdtool graph rrdtool_predict.png \
--start=-4w \
--end=+1w \
--vertical-label "bytes/s" \
--title "Network Traffics " \
--width 500 \
--height 100 \
--alt-autoscale-max \
--disable-rrdtool-tag \
DEF:value=$FN:bytes_in:AVERAGE:start=-8w \
LINE1:value#ff0000:bytes_in \
CDEF:predict=86400,-7,1800,value,PREDICT \
CDEF:sigma=86400,-7,1800,value,PREDICTSIGMA \
CDEF:upper=predict,sigma,3,*,+ \
CDEF:lower=predict,sigma,3,*,- \
LINE1:predict#00ff00:prediction \
LINE1:upper#0000ff:upper\ certainty\ limit \
LINE1:lower#0000ff:lower\ certainty\ limit \
CDEF:exceeds=value,UN,0,value,lower,upper,LIMIT,UN,IF \
TICK:exceeds#aa000080:1 \
CDEF:perc95=86400,-7,1800,95,value,PREDICTPERC \
LINE1:perc95#ffff00:95th_percentile
아래와 유사한 그래프가 생성된다. Week 14 까지가 데이터가 있는 구간이고, 그이후 구간중 초록색 선이 예측된 값, 파란색 선이 오차 범위를 나타내었다.
그래프상으로는 오차 구간이 크기 때문에 음수까지 나오는데, 이를 없애면 아래와 같이 그려진다. CDEF:lower=predict,sigma,3,*,- \ 대신 CDEF:lower=predict,sigma,3,*,-,0,MAX \를 사용했다.
-
HWPREDICT 지시자를 사용한 운전일탈 감지를 위한 그래프 예시다. 다른 예제와는 달리 RRA 에 HWPREDICT가 사전에 지정되어 있어야 한다.(하기 예제에서 rrdtool_net_net.rrd파일은 문서 하단에 설명되어있는 rrdtool_net.sh 스크립트를 사용해 생성한 파일이다)
windy@wl ~ $ export FN="rrdtool_net_net.rrd"
windy@wl ~ $ rrdtool graph rrdtool_hwpredict.png \
--start -1d \
--vertical-label "bytes/s" \
--title "Network Traffics " \
--width 500 \
--height 100 \
--alt-autoscale-max \
--disable-rrdtool-tag \
--lower-limit 0 \
"DEF:bi=$FN:bytes_in:AVERAGE" \
"DEF:bipred=$FN:bytes_in:HWPREDICT" \
"DEF:bidev=$FN:bytes_in:DEVPREDICT" \
"DEF:bifail=$FN:bytes_in:FAILURES" \
"DEF:bo=$FN:bytes_out:AVERAGE" \
"DEF:bopred=$FN:bytes_out:HWPREDICT" \
"DEF:bodev=$FN:bytes_out:DEVPREDICT" \
"DEF:bofail=$FN:bytes_out:FAILURES" \
"CDEF:gbi=bi" \
"CDEF:gbo=bo" \
"CDEF:biupper=bipred,bidev,2,*,+" \
"CDEF:bilower=bipred,bidev,2,*,-" \
"CDEF:boupper=bopred,bodev,2,*,+" \
"CDEF:bolower=bopred,bodev,2,*,-" \
"TICK:bifail#FFFFA0:1.0" \
"TICK:bofail#FFFFA0:1.0" \
"LINE:biupper#FFC0C0:Input Upper" \
"LINE:bilower#FFC0C0:Input Lower" \
"LINE:boupper#00C000:Output Upper" \
"LINE:bolower#00C000:Output Lower" \
"AREA:gbi#FF8080:Input bytes/s" \
"GPRINT:bi:AVERAGE:%.1lf %S" \
"LINE:gbo#00A000:Output bytes/s" \
"GPRINT:bo:AVERAGE:%.1lf %S"
아래와 유사한 그래프가 나온다. 문제가 있다고 판단되는 경우 (범위를 벗어나는 경우) TICK 커맨드에 의해 노란색 배경으로 출력된다.
-
-
What colours to use 에서 가져온 색상에 몇가지 추가했다.
구글 차트 기본 컬러
-
- 모든 스크립트는 단일 .sh 파일로 되어있다. .sh 파일 하나로 모든 작업을 한다.
- 이 스크립트를 실행하기 위해서는 RRDtool 1.2 이상이 필요하며 1.4 를 권장한다.
- 스크립트에 필요한 변수들은 모두 환경변수로 넘겨받도록 프로그래밍 되어있다.
- 그래프의 크기는 500px × 100px 이며, 단위와 타이틀을 포함한 크기는 597px × 179px 또는 649px × 173px 이다.
-
아래와 같이 데이터를 저장하고 그래프를 생성한다.
| 저장 단위 시간 |
1분 |
5분 |
30분 |
2시간 |
1일 |
| 저장 회수 |
1440 |
1440 |
800 |
800 |
800 |
| 총 저장 기간 1) |
1일 |
5일 |
16일 |
66일 |
2년 |
| 그래프 2) |
1일 |
Ｘ 3) |
1주일 |
1달 |
1년 |
1) 저장단위기간 × 저장회수. .rrd파일에 저장하는 기간이다.
2) 그래프로 그리는 기간이다. 저장하는 기간보다는 당연히 짧다. 일반적으로 저장하는기간=그래프로그리는기간 × 2
이다.
3) MRTG에서는 5분간 데이터를 저장하고 이를 사용해 2일간 그래프를 그리며, 다른 NMS도 이런 형태의 그래프를 채용하고 있기 때문에 솔라나라에서도 5분간 데이터를 저장한다. 하지만 솔라나라에서 작성한 스크립트에서는 2일 그래프를 그리지 않는다. 이 데이터를 사용해 그리기 위해서는 스크립트에 있는 그래프 그리는 줄에서 -1d를 -2d로 변경하기만 하면 된다. 개요 형식의 큰 그래프를 그릴 때 사용하면 알맞다고 생각한다.
-
복잡한 설치과정은 필요 없다.
~/rrdtool 디렉토리를 만들고 스크립트를 다운로드 받은 후 cron 에 1분마다 실행되도록 하면 설치는 완료된다.
windy@wl ~/rrdtool $ crontab -e
* * * * * /export/home/windy/rrdtool/rrd.sh
windy@wl ~/rrdtool $ cat rrd.sh
#!/bin/bash
cd ~/rrdtool
#export RRDCACHED_ADDRESS="unix:/tmp/rrdcached.sock"
./rrdtool_load.sh
./rrdtool_net.sh
...
windy@wl ~/rrdtool $ ls -alF
-rwxr-xr-x 1 windy staff 313 4월 7일 00:00 rrd.sh*
-rwxr-xr-x 1 windy staff 2647 4월 7일 00:00 rrdtool_net.sh*
-rwxr-xr-x 1 windy staff 2101 4월 7일 00:00 rrdtool_load.sh*
...
windy@wl ~/rrdtool $ ./rrd.sh
windy@wl ~/rrdtool $ ls -alF *.rrd
-rw-r--r-- 1 windy staff 172168 4월 7일 00:01 rrdtool_dskstat_sd0.rrd
-rw-r--r-- 1 windy staff 129296 4월 7일 00:01 rrdtool_load.rrd
-rw-r--r-- 1 windy staff 343656 4월 7일 00:01 rrdtool_mem.rrd
-rw-r--r-- 1 windy staff 858120 4월 7일 00:01 rrdtool_mysql.rrd
-rw-r--r-- 1 windy staff 295336 4월 7일 00:01 rrdtool_net_iprb0.rrd
-rw-r--r-- 1 windy staff 86424 4월 7일 00:01 rrdtool_volstat_rpool.rrd
...
-
시스템의 로드 에버리지를 얻어와 저장하고 그래프를 그린다. 이 스크립트는 리눅스(CentOS, Ubuntu)에서도 테스트했다.
#!/bin/bash
# Monitoring load average for Solaris, Linux
# WindyHana's Solanara: RRDtool
# http://www.solanara.net/solanara/rrdtool
# last update: 2014.12.10
PATH=/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/rrdtool/bin:/opt/rrdtool/bin
LANG=C
if [ "$RRDTOOL_BIN" == "" ]; then
RRDTOOL_BIN=`which rrdtool`
if [ "$RRDTOOL_BIN" == "" ]; then
echo "Cannot find RRDTool. Set $RRDTOOL_BIN env."
exit 1;
fi
fi
if [ "$RRDTOOL_HOME" != "" ]; then
cd "$RRDTOOL_HOME"
else
cd `dirname $0`
fi
MI=`date +'%M'`
MI=$(expr $MI + 0)
HR=`date +'%H'`
HR=$(expr $HR + 0)
let MOD5=$MI%5;
let MOD30=$MI%30;
# /tmp/rrdtool_load file format
# 1min load average:5min load average, 15min load average
# ex) 1.00:0.50:0.10
#
TEMPFN="/tmp/rrdtool_load_$$"
uptime | sed -e 's/^.*load average.*: //' -e 's/ //g' | awk -F, "{ printf(\"%f:%f:%f\", \$1, \$2, \$3)}" > $TEMPFN
DATA=`cat $TEMPFN`
rm $TEMPFN
FNPREFIX="rrdtool_load"
FNRRD="$FNPREFIX.rrd"
OS=`uname -s`
if [ "$OS" == "SunOS" ]; then
CPUCOUNT=`kstat -m cpu_info -p | grep state | grep on-line | wc -l`
UPTIME=`kstat -p unix:0:system_misc:snaptime | awk '{print $2}' | awk -F. '{print $1}'`
elif [ "$OS" == "Linux" ]; then
CPUCOUNT=`grep -c processor /proc/cpuinfo`
UPTIME=`cat /proc/uptime | awk '{print $1}' | awk -F. '{print $1}'`
else
CPUCOUNT=2
UPTIME=1
fi
LOADWARNING=`expr $CPUCOUNT "*" 4`
DATA="$DATA:$UPTIME"
if [ ! -f $FNRRD ]; then
rrdtool create $FNRRD \
--step 60 \
"DS:1min:GAUGE:600:0:U" \
"DS:5min:GAUGE:600:0:U" \
"DS:15min:GAUGE:600:0:U" \
"DS:uptime:GAUGE:600:0:U" \
"RRA:AVERAGE:0.5:1:1440" \
"RRA:AVERAGE:0.5:5:1440" \
"RRA:AVERAGE:0.5:30:800" \
"RRA:AVERAGE:0.5:120:800" \
"RRA:AVERAGE:0.5:1440:800"
fi
$RRDTOOL_BIN update $FNRRD N:$DATA
function graphLoad {
FIRST=`rrdtool fetch --start $1 $FNPREFIX.rrd AVERAGE | grep -v "nan" | grep ":" | head -1 | awk -F: '{print $1}'`
if [ "$FIRST" == "" ]; then
FIRST=`nawk 'BEGIN {print srand()}'`
fi
$RRDTOOL_BIN graph ${FNPREFIX}_$2.png \
--start $1 \
--vertical-label "# of threads in run q" \
--title "Load averages ($HOSTNAME)" \
--width 500 \
--height 100 \
--lower-limit 0 \
--alt-autoscale-max \
--units-exponent 0 \
--disable-rrdtool-tag \
"DEF:1mind=$FNRRD:1min:AVERAGE" \
"DEF:5mind=$FNRRD:5min:AVERAGE" \
"DEF:15mind=$FNRRD:15min:AVERAGE" \
"CDEF:fail=1mind,UN,TIME,$FIRST,GT,1,0,IF,0,IF" \
"COMMENT:Current " \
"GPRINT:1mind:LAST:%.2lf" \
"GPRINT:5mind:LAST:%.2lf" \
"GPRINT:15mind:LAST:%.2lf" \
"LINE:1mind#54EC48:1 MIN" \
"LINE:5mind#4D18E4:5 MIN" \
"LINE:15mind#DE48EC:15 MIN" \
"HRULE:$LOADWARNING#FF0000" \
"TICK:fail#FFFF80:1.0" \
> /dev/null
}
if [ "$MOD5" == "0" ]; then
graphLoad -1d day
fi
if [ "$MOD30" == "0" ]; then
graphLoad -1w week
fi
if [ "$MI" == "0" ]; then
graphLoad -1m month
fi
if [ "$HR" == "0" ]; then
graphLoad -1y year
fi
-
시스템의 CPU 모니터링 정보를 얻어와 저장하고 그래프를 그린다. kstat(1M) 를 사용했다. 항목에 대한 설명은 윈디하나의 솔라나라: top, prstat, rstat을 읽어보자.
#!/bin/bash
# Monitoring CPU for Solaris
# WindyHana's Solanara: RRDtool
# http://www.solanara.net/solanara/rrdtool
# last update: 2014.12.10
PATH=/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/rrdtool/bin:/opt/rrdtool/bin
LANG=C
if [ "$RRDTOOL_BIN" == "" ]; then
RRDTOOL_BIN=`which rrdtool`
if [ "$RRDTOOL_BIN" == "" ]; then
echo "Cannot find RRDTool. Set $RRDTOOL_BIN env."
exit 1;
fi
fi
if [ "$RRDTOOL_HOME" != "" ]; then
cd "$RRDTOOL_HOME"
else
cd `dirname $0`
fi
MI=`date +'%M'`
MI=$(expr $MI + 0)
HR=`date +'%H'`
HR=$(expr $HR + 0)
let MOD5=$MI%5;
let MOD30=$MI%30;
FNPREFIX="rrdtool_cpu"
FNSUFFIX=".rrd"
CPUCOUNT=`kstat -m cpu_info -p | grep state | grep on-line | wc -l`
i=0
while [ "$i" -lt $CPUCOUNT ]; do
FN=${FNPREFIX}_${i}$FNSUFFIX
if [ ! -f $FN ]; then
rrdtool create $FN \
--step 60 \
"DS:uptime:GAUGE:600:0:U" \
"DS:idle:DERIVE:600:0:U" \
"DS:user:DERIVE:600:0:U" \
"DS:kernel:DERIVE:600:0:U" \
"DS:wait:DERIVE:600:0:U" \
"DS:wait_io:DERIVE:600:0:U" \
"DS:wait_pio:DERIVE:600:0:U" \
"DS:wait_swap:DERIVE:600:0:U" \
"DS:iowait:DERIVE:600:0:U" \
"DS:pswitch:DERIVE:600:0:U" \
"DS:inv_swtch:DERIVE:600:0:U" \
"DS:syscall:DERIVE:600:0:U" \
"DS:sysread:DERIVE:600:0:U" \
"DS:syswrite:DERIVE:600:0:U" \
"DS:sysfork:DERIVE:600:0:U" \
"DS:sysvfork:DERIVE:600:0:U" \
"DS:sysexec:DERIVE:600:0:U" \
"DS:cow_fault:DERIVE:600:0:U" \
"DS:as_fault:DERIVE:600:0:U" \
"DS:prot_fault:DERIVE:600:0:U" \
"DS:hat_fault:DERIVE:600:0:U" \
"DS:softlock:DERIVE:600:0:U" \
"DS:kernel_asflt:DERIVE:600:0:U" \
"DS:maj_fault:DERIVE:600:0:U" \
"DS:intr:DERIVE:600:0:U" \
"DS:intrblk:DERIVE:600:0:U" \
"DS:intrthread:DERIVE:600:0:U" \
"DS:msg:DERIVE:600:0:U" \
"DS:sema:DERIVE:600:0:U" \
"DS:namei:DERIVE:600:0:U" \
"DS:cpumigrate:DERIVE:600:0:U" \
"DS:xcalls:DERIVE:600:0:U" \
"DS:trap:DERIVE:600:0:U" \
"RRA:AVERAGE:0.5:1:1440" \
"RRA:AVERAGE:0.5:5:1440" \
"RRA:AVERAGE:0.5:30:800" \
"RRA:AVERAGE:0.5:120:800" \
"RRA:AVERAGE:0.5:1440:800"
fi
STATI="cpu_stat:$i:"
# /usr/include/sys/sysinfo.h
uptime=`kstat -p unix:0:system_misc:snaptime | awk '{print $2}' | awk -F. '{print $1}'`
DATA=`kstat -p \
$STATI:idle $STATI:user $STATI:kernel $STATI:wait $STATI:wait_io $STATI:wait_pio $STATI:wait_swap $STATI:iowait \
$STATI:pswitch $STATI:inv_swtch \
$STATI:syscall $STATI:sysread $STATI:syswrite $STATI:sysfork $STATI:sysvfork $STATI:sysexec \
$STATI:cow_fault $STATI:as_fault $STATI:prot_fault $STATI:hat_fault $STATI:softlock $STATI:kernel_asflt $STATI:maj_fault \
$STATI:intr $STATI:intrblk $STATI:intrthread \
$STATI:msg $STATI:sema \
$STATI:namei \
$STATI:cpumigrate $STATI:xcalls $STATI:trap \
| awk '{print $2}' \
| sed -n -e 'N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;N;s/\n/\:/g;p' \
`
DATA=$uptime:$DATA
$RRDTOOL_BIN update $FN N:$DATA
if [ "$?" != "0" ]; then
echo "Cannot update $FN by previous error.";
exit;
fi
function graphCpu {
$RRDTOOL_BIN graph ${FNPREFIX}_${i}_utl_$2.png \
--start $1 \
--vertical-label "Util %" \
--title "CPU $i Utilization" \
--width 500 \
--height 100 \
--lower-limit 0 \
--upper-limit 100 \
--rigid \
--disable-rrdtool-tag \
"DEF:idle=$FN:idle:AVERAGE" \
"DEF:user=$FN:user:AVERAGE" \
"DEF:kernel=$FN:kernel:AVERAGE" \
"DEF:wait=$FN:wait:AVERAGE" \
"CDEF:totaltick=idle,user,+,kernel,wait,+,+" \
"CDEF:pkernel=kernel,100,*,totaltick,/" \
"CDEF:puser=user,100,*,totaltick,/" \
"CDEF:pwait=wait,100,*,totaltick,/" \
"CDEF:pidle=100,pkernel,-,puser,-,pwait,-" \
"AREA:pkernel#7648EC:Kernel" \
"AREA:puser#EA644A:User:STACK" \
"AREA:pwait#54EC48:Wait:STACK" \
"AREA:pidle#68E4FC:Idle:STACK" \
"LINE:100#1598C3" \
> /dev/null
# 'totaltick' always 100 on Solaris System. see hires_tick on Solaris Tunable Parameters Reference Manual
$RRDTOOL_BIN graph ${FNPREFIX}_${i}_sys_$2.png \
--start $1 \
--vertical-label "Total syscall/s" \
--title "CPU $i System Calls" \
--width 500 \
--height 100 \
--lower-limit 0 \
--right-axis-label 'Operations/s' \
--right-axis 0.01:0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:syscall=$FN:syscall:AVERAGE" \
"DEF:sysread=$FN:sysread:AVERAGE" \
"DEF:syswrite=$FN:syswrite:AVERAGE" \
"DEF:sysfork=$FN:sysfork:AVERAGE" \
"DEF:sysvfork=$FN:sysvfork:AVERAGE" \
"DEF:sysexec=$FN:sysexec:AVERAGE" \
"CDEF:csysread=sysread,20,*" \
"CDEF:csyswrite=syswrite,20,*" \
"CDEF:csysfork=sysfork,20,*" \
"CDEF:csysvfork=sysvfork,20,*" \
"CDEF:csysexec=sysexec,20,*" \
"LINE:syscall#48C4EC:total" \
"LINE:csysread#ECD748:read" \
"LINE:csyswrite#54EC48:write" \
"LINE:csysfork#EA644A:fork" \
"LINE:csysvfork#DE48EC:vfork" \
"LINE:csysexec#EC9D48:exec" \
> /dev/null
$RRDTOOL_BIN graph ${FNPREFIX}_${i}_xcl_$2.png \
--start $1 \
--vertical-label "cpumig,xcall/s" \
--title "CPU $i xcall/migration" \
--width 500 \
--height 100 \
--lower-limit 0 \
--right-axis-label 'traps/s' \
--right-axis 100:0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:xcalls=$FN:xcalls:AVERAGE" \
"DEF:cpumigrate=$FN:cpumigrate:AVERAGE" \
"DEF:trap=$FN:trap:AVERAGE" \
"CDEF:ctrap=trap,100,/" \
"LINE:cpumigrate#EA644A:cpu migrations" \
"LINE:xcalls#24BC14:xcalls" \
"LINE:ctrap#DE48EC:traps" \
> /dev/null
$RRDTOOL_BIN graph ${FNPREFIX}_${i}_sch_$2.png \
--start $1 \
--vertical-label "Context Switches/s" \
--title "CPU $i Context Switches" \
--width 500 \
--height 100 \
--lower-limit 0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:inv_swtch=$FN:inv_swtch:AVERAGE" \
"DEF:pswitch=$FN:pswitch:AVERAGE" \
"AREA:pswitch#68E4FC:Total Context Switches" \
"LINE:pswitch#1598C3" \
"AREA:inv_swtch#4D18E4:Involuntary Context Switches" \
> /dev/null
$RRDTOOL_BIN graph ${FNPREFIX}_${i}_ipc_$2.png \
--start $1 \
--vertical-label "operations/s" \
--title "CPU $i IPC" \
--width 500 \
--height 100 \
--lower-limit 0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:msg=$FN:msg:AVERAGE" \
"DEF:sema=$FN:sema:AVERAGE" \
"LINE:msg#EA644A:Message count" \
"AREA:sema#24BC14:Semaphore operations" \
> /dev/null
$RRDTOOL_BIN graph ${FNPREFIX}_${i}_int_$2.png \
--start $1 \
--vertical-label "operations/s" \
--title "CPU $i Interrupts" \
--width 500 \
--height 100 \
--lower-limit 0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:intr=$FN:intr:AVERAGE" \
"DEF:intrblk=$FN:intrblk:AVERAGE" \
"DEF:intrthread=$FN:intrthread:AVERAGE" \
"LINE:intr#EA644A:Interrupts" \
"LINE:intrblk#24BC14:Interrupts Blk" \
"LINE:intrthread#DE48EC:Interrupts Thread" \
> /dev/null
$RRDTOOL_BIN graph ${FNPREFIX}_${i}_flt_$2.png \
--start $1 \
--vertical-label "operations/s" \
--title "CPU $i Faults" \
--width 500 \
--height 100 \
--lower-limit 0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:maj_fault=$FN:maj_fault:AVERAGE" \
"DEF:cow_fault=$FN:cow_fault:AVERAGE" \
"DEF:as_fault=$FN:as_fault:AVERAGE" \
"DEF:prot_fault=$FN:as_fault:AVERAGE" \
"DEF:softlock=$FN:as_fault:AVERAGE" \
"LINE:maj_fault#EA644A:Major Faults" \
"LINE:cow_fault#24BC14:COW Faults" \
"LINE:as_fault#DE48EC:AS Faults" \
"LINE:prot_fault#EC9D48:Protection Faults" \
"LINE:softlock#48C4EC:Soft Lock" \
> /dev/null
}
if [ "$MOD5" == "0" ]; then
graphCpu -1d day
fi
if [ "$MOD30" == "0" ]; then
graphCpu -1w week
fi
if [ "$MI" == "0" ]; then
graphCpu -1m month
fi
if [ "$HR" == "0" ]; then
graphCpu -1y year
fi
i=`echo $i + 1 | bc`;
done
-
시스템의 각 NIC마다 전송된 패킷 수 및 바이트 수를 얻어와 저장하고 그래프를 그린다. kstat(1M) 를 사용했다.
#!/bin/bash
# Monitoring network traffic/packets for solaris
# WindyHana's Solanara: RRDtool
# http://www.solanara.net/solanara/rrdtool
# last update: 2011.12.10
PATH=/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/rrdtool/bin:/opt/rrdtool/bin
LANG=C
if [ "$RRDTOOL_BIN" == "" ]; then
RRDTOOL_BIN=`which rrdtool`
if [ "$RRDTOOL_BIN" == "" ]; then
echo "Cannot find RRDTool. Set $RRDTOOL_BIN env."
exit 1;
fi
fi
if [ "$RRDTOOL_HOME" != "" ]; then
cd "$RRDTOOL_HOME"
else
cd `dirname $0`
fi
MI=`date +'%M'`
MI=$(expr $MI + 0)
HR=`date +'%H'`
HR=$(expr $HR + 0)
let MOD5=$MI%5;
let MOD30=$MI%30;
# /tmp/rrdtool_net file format
# InterfaceName InputPackets OutputPackets InputBytes OutputBytes InterfaceSpeed per each line.
# -> e1000g0 ipackets obytes opackets rbytes ifspeed
# Do not use 64bit integer for compatibility issue.
TEMPFN="/tmp/rrdtool_net_$$"
kstat -c net -p 'link:::[or]bytes' -p 'link:::[io]packets' -p 'link:::ifspeed' \
| sed '/lo/d' \
| awk 'BEGIN{FS=":"} {print $3,$4}' \
| awk '{print $1,$2,$3}' \
| sort -k 1,2 \
| sed -n -e 'N;N;N;N;s/\n/ /g;p' \
| awk '{print $1,$6,$12,$15,$9,$3}' \
> $TEMPFN
cat $TEMPFN | while read LINE
do
IFNAME=`echo $LINE | awk '{print $1}'`
DATA=`echo $LINE | awk '{print $2,$3,$4,$5}' | sed -e 's/ /:/g'`
IFSPEED=`echo $LINE | awk '{print $6}'`
FN="rrdtool_net_$IFNAME.rrd"
if [ "$IFSPEED" == "10000000" ]; then
IFSPEEDMSG="10Mbps"
elif [ "$IFSPEED" == "100000000" ]; then
IFSPEEDMSG="100Mbps"
elif [ "$IFSPEED" == "1000000000" ]; then
IFSPEEDMSG="1Gbps"
elif [ "$IFSPEED" == "10000000000" ]; then
IFSPEEDMSG="10Gbps"
elif [ "$IFSPEED" == "40000000000" ]; then
IFSPEEDMSG="40Gbps"
elif [ "$IFSPEED" == "100000000000" ]; then
IFSPEEDMSG="100Gbps"
else
IFSPEEDMSG="?"
fi
if [ ! -f $FN ]; then
rrdtool create $FN \
--step 60 \
"DS:packets_in:DERIVE:600:0:U" \
"DS:packets_out:DERIVE:600:0:U" \
"DS:bytes_in:DERIVE:600:0:U" \
"DS:bytes_out:DERIVE:600:0:U" \
"RRA:HWPREDICT:1440:0.1:0.0035:288" \
"RRA:AVERAGE:0.5:1:1440" \
"RRA:AVERAGE:0.5:5:1440" \
"RRA:AVERAGE:0.5:30:800" \
"RRA:AVERAGE:0.5:120:800" \
"RRA:AVERAGE:0.5:1440:800" \
"RRA:MAX:0.5:60:24"
fi
rrdtool update $FN N:$DATA
function graphNet {
rrdtool graph rrdtool_net_${IFNAME}_pks_$2.png \
--start $1 \
--vertical-label "Packets/s" \
--title "Network Traffics ${IFNAME}@$HOSTNAME ($IFSPEEDMSG)" \
--width 500 \
--height 100 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:pi=$FN:packets_in:AVERAGE" \
"DEF:po=$FN:packets_out:AVERAGE" \
"DEF:fail=$FN:packets_out:FAILURES" \
"CDEF:gpi=pi" \
"CDEF:gpo=po" \
"TICK:fail#FFFFA0:1.0" \
"AREA:gpi#FF8080:Input Packets/s" \
"GPRINT:pi:AVERAGE:%.1lf %S" \
"LINE:gpo#00A000:Output Packets/s" \
"GPRINT:po:AVERAGE:%.1lf %S" \
> /dev/null
rrdtool graph rrdtool_net_${IFNAME}_bit_$2.png \
--start $1 \
--vertical-label "bytes/s" \
--title "Network Traffics ${IFNAME}@$HOSTNAME ($IFSPEEDMSG)" \
--width 500 \
--height 100 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:bi=$FN:bytes_in:AVERAGE" \
"DEF:bipred=$FN:bytes_in:HWPREDICT" \
"DEF:bidev=$FN:bytes_in:DEVPREDICT" \
"DEF:bifail=$FN:bytes_in:FAILURES" \
"DEF:bo=$FN:bytes_out:AVERAGE" \
"DEF:bopred=$FN:bytes_out:HWPREDICT" \
"DEF:bodev=$FN:bytes_out:DEVPREDICT" \
"DEF:bofail=$FN:bytes_out:FAILURES" \
"CDEF:gbi=bi" \
"CDEF:gbo=bo" \
"CDEF:biupper=bipred,bidev,2,*,+" \
"CDEF:bilower=bipred,bidev,2,*,-" \
"CDEF:boupper=bopred,bodev,2,*,+" \
"CDEF:bolower=bopred,bodev,2,*,-" \
"TICK:bifail#FFFFA0:1.0" \
"TICK:bofail#FFFFA0:1.0" \
"AREA:gbi#FF8080:Input bytes/s" \
"GPRINT:bi:AVERAGE:%.1lf %S" \
"LINE:gbo#00A000:Output bytes/s" \
"GPRINT:bo:AVERAGE:%.1lf %S" \
> /dev/null
}
function graphNetSumm {
rrdtool graph rrdtool_net_${IFNAME}_bit_summ.png \
--start -2d \
--vertical-label "bytes/s" \
--title "Network Traffics Summary ${IFNAME}@$HOSTNAME ($IFSPEEDMSG)" \
--width 500 \
--height 150 \
--alt-autoscale-max \
--disable-rrdtool-tag \
--x-grid "HOUR:1:HOUR:6:HOUR:6:0:%H:00" \
"DEF:bi=$FN:bytes_in:AVERAGE" \
"DEF:bo=$FN:bytes_out:AVERAGE" \
"DEF:bi1w=$FN:bytes_in:AVERAGE:end=now-1w:start=end-1w" \
"DEF:bo1w=$FN:bytes_out:AVERAGE:end=now-1w:start=end-1w" \
"VDEF:bimax=bi,MAXIMUM" \
"VDEF:biavg=bi,AVERAGE" \
"VDEF:bimin=bi,MINIMUM" \
"VDEF:bomax=bo,MAXIMUM" \
"VDEF:boavg=bo,AVERAGE" \
"VDEF:bomin=bo,MINIMUM" \
"VDEF:bi1wmax=bi1w,MAXIMUM" \
"VDEF:bi1wavg=bi1w,AVERAGE" \
"VDEF:bi1wmin=bi1w,MINIMUM" \
"VDEF:bo1wmax=bo1w,MAXIMUM" \
"VDEF:bo1wavg=bo1w,AVERAGE" \
"VDEF:bo1wmin=bo1w,MINIMUM" \
"LINE:bi#EA644A:Input " \
"GPRINT:bimax:%6.1lf %S" \
"GPRINT:biavg:%6.1lf %S" \
"GPRINT:bimin:%6.1lf %S\l" \
"LINE:bi1w#EC9D48:Input (-1w)" \
"GPRINT:bi1wmax:%6.1lf %S" \
"GPRINT:bi1wavg:%6.1lf %S" \
"GPRINT:bi1wmin:%6.1lf %S\l" \
"LINE:bo#7648EC:Output " \
"GPRINT:bomax:%6.1lf %S" \
"GPRINT:boavg:%6.1lf %S" \
"GPRINT:bomin:%6.1lf %S\l" \
"LINE:bo1w#48C4EC:Output (-1w)" \
"GPRINT:bo1wmax:%6.1lf %S" \
"GPRINT:bo1wavg:%6.1lf %S" \
"GPRINT:bo1wmin:%6.1lf %S\l" \
"DEF:fail=$FN:bytes_in:FAILURES" \
"TICK:fail#000000:1.0:Fail" \
> /dev/null
}
if [ "$MOD5" == "0" ]; then
graphNet -1d day
fi
if [ "$MOD30" == "0" ]; then
graphNet -1w week
fi
if [ "$MI" == "0" ]; then
graphNet -1m month
fi
if [ "$HR" == "0" ]; then
graphNet -1y year
fi
# graphNetSumm
done
rm $TEMPFN
-
메모리 사용량을 모니터링 해준다. 스크립트는 mdb(1)를 사용했기 때문에, root 권한을 가진 사용자로 실행해야 한다.
#!/bin/bash
# Monitoring memory usage for solaris
# WindyHana's Solanara: RRDtool
# http://www.solanara.net/solanara/rrdtool
# last update: 2015.12.16
. /etc/profile
PATH=/opt/rrdtool/bin:/usr/bin
cd ~windy/rrdtool
LANG=C
# /tmp/rrdtool_mem file format
# Kernel ZFS Anon ExecLib Page FreeCache FreeList Total (in pages)
PAGESIZE=`pagesize`
echo '::memstat' | pfexec mdb -k > /tmp/rrdtool_mem
if [ "$?" != "0" ]; then
echo "Must run as root priv."
exit 1
fi
MDBLINES=`cat /tmp/rrdtool_mem | wc -l | awk '{print $1}'`
if [ "$MDBLINES" == "10" ]; then
# Solaris 11.4
cat /tmp/rrdtool_mem \
| sed '1,2d' \
| sort -k 1 \
| awk '{print substr($0, 18, 100) }' \
| awk '{print $1 }' \
| sed -n -e 'N;N;N;N;N;N;N;s/\n/ /g;p' \
| awk '{print $4,$8,$7,$1,$5,$3,$2,$6}' \
> /tmp/rrdtool_mem2
elif [ "$MDBLINES" == "11" ]; then
# Solaris 10
cat /tmp/rrdtool_mem \
| sed '1,2d' \
| sort -k 1 \
| awk '{print substr($0, 18, 100) }' \
| awk '{print $1 }' \
| sed -n -e 'N;N;N;N;N;N;N;N;s/\n/ /g;p' \
| awk '{print $5,$8,$1,$2,$6,$3,$4,$7}' \
> /tmp/rrdtool_mem2
elif [ "$MDBLINES" == "12" ]; then
# Solaris 11
cat /tmp/rrdtool_mem \
| sed '1,2d' \
| sort -k 1 \
| awk '{print substr($0, 18, 100) }' \
| awk '{print $1 }' \
| sed -n -e 'N;N;N;N;N;N;N;N;N;s/\n/ /g;p' \
| awk '{print $6,$9 + $10,$1,$2,$7,$3,$4,$8}' \
> /tmp/rrdtool_mem2
else
echo "ERROR: Cannot recognize MDB Output [$MDBLINES]"
exit 1
fi
rm /tmp/rrdtool_mem
DATA=`cat /tmp/rrdtool_mem2 | sed -e 's/ /:/g'`
rm /tmp/rrdtool_mem2
FN="rrdtool_mem.rrd"
if [ ! -f $FN ]; then
rrdtool create $FN \
--step 60 \
"DS:kern:GAUGE:600:0:U" \
"DS:zfsd:GAUGE:600:0:U" \
"DS:anon:GAUGE:600:0:U" \
"DS:exec:GAUGE:600:0:U" \
"DS:page:GAUGE:600:0:U" \
"DS:fcah:GAUGE:600:0:U" \
"DS:flst:GAUGE:600:0:U" \
"DS:tot:GAUGE:600:0:U" \
"RRA:AVERAGE:0.5:1:1440" \
"RRA:AVERAGE:0.5:5:1440" \
"RRA:AVERAGE:0.5:30:800" \
"RRA:AVERAGE:0.5:120:800" \
"RRA:AVERAGE:0.5:1440:800"
fi
rrdtool update $FN N:$DATA
function graphMem {
rrdtool graph rrdtool_mem_$2.png \
--start $1 \
--vertical-label "Memory Usage" \
--title "Memory Usage ($HOSTNAME)" \
--width 500 \
--height 100 \
--base 1024 \
--lower-limit 0 \
--disable-rrdtool-tag \
"DEF:kern=$FN:kern:AVERAGE" \
"DEF:zfsd=$FN:zfsd:AVERAGE" \
"DEF:anon=$FN:anon:AVERAGE" \
"DEF:exec=$FN:exec:AVERAGE" \
"DEF:page=$FN:page:AVERAGE" \
"DEF:fcah=$FN:fcah:AVERAGE" \
"DEF:flst=$FN:flst:AVERAGE" \
"DEF:tot=$FN:tot:AVERAGE" \
"CDEF:ckern=kern,$PAGESIZE,*" \
"CDEF:czfsd=zfsd,$PAGESIZE,*" \
"CDEF:canon=anon,$PAGESIZE,*" \
"CDEF:cexec=exec,$PAGESIZE,*" \
"CDEF:cpage=page,$PAGESIZE,*" \
"CDEF:cfcah=fcah,$PAGESIZE,*" \
"CDEF:cflst=flst,$PAGESIZE,*" \
"CDEF:ctot=tot,$PAGESIZE,*" \
"AREA:ckern#EA644A:Kernel" \
"AREA:canon#EC9D48:Anon:STACK" \
"AREA:cexec#ECD748:Exec:STACK" \
"AREA:cpage#54EC48:Page:STACK" \
"AREA:czfsd#48C4EC:ZFS:STACK" \
"AREA:cfcah#DE48EC:FreeCache:STACK" \
"AREA:cflst#7648EC:FreeList:STACK" \
"LINE:ctot#4D18E4:Total" \
> /dev/null
}
graphMem -1d day
MI=`date +'%M'`
if [ "$MI" -lt "5" ]; then
graphMem -1w week
graphMem -1m month
graphMem -1y year
fi
-
볼륨 사용량을 모니터링 해준다. UFS로 마운트 된 각 마운트 지점과, ZFS 풀의 전체 용량과 사용량을 모니터링 한다.
#!/bin/bash
# Monitoring disk usage for solaris
# WindyHana's Solanara: RRDtool
# http://www.solanara.net/solanara/rrdtool
# last update: 2014.03.26
PATH=/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/rrdtool/bin:/opt/rrdtool/bin
LANG=C
if [ "$RRDTOOL_BIN" == "" ]; then
RRDTOOL_BIN=`which rrdtool`
if [ "$RRDTOOL_BIN" == "" ]; then
echo "Cannot find RRDTool. Set $RRDTOOL_BIN env."
exit 1;
fi
fi
if [ "$RRDTOOL_HOME" != "" ]; then
cd "$RRDTOOL_HOME"
else
cd `dirname $0`
fi
FNPREFIX="rrdtool_volstat_"
FNCONF="rrdtool_volstat.conf"
FNRRDSUFFIX=".rrd"
FNGRASUFFIX=".png"
if [ ! -f "$FNCONF" ]; then
UFS=`mount -p | awk '{print $3}' | grep ufs`
if [ -x /usr/sbin/zpool ]; then
ZFS=`zpool list | sed 1d | awk '{print $1}'`
fi
echo "FS='$UFS $ZFS'" > $FNCONF
fi
. "$FNCONF"
if [ "$FS" == "" ]; then
echo "Cannot determine file systems."
exit 1
fi
for MNTPOINT in $FS; do
FNRRD=$FNPREFIX$MNTPOINT$FNRRDSUFFIX
if [ ! -f "$FNRRD" ]; then
$RRDTOOL_BIN create "$FNRRD" \
--step 60 \
DS:TOTAL:GAUGE:600:0:U \
DS:USAGE:GAUGE:600:0:U \
"RRA:AVERAGE:0.5:1:1440" \
"RRA:AVERAGE:0.5:5:1440" \
"RRA:AVERAGE:0.5:30:800" \
"RRA:AVERAGE:0.5:120:800" \
"RRA:AVERAGE:0.5:1440:800"
fi
DATA=`df -k $MNTPOINT | sed 1d | awk '{print $2, $2 - $4}' | sed -e 's/ /:/g'`
$RRDTOOL_BIN update $FNRRD N:$DATA
function graphVol {
$RRDTOOL_BIN graph ${FNPREFIX}${MNTPOINT}_$2$FNGRASUFFIX \
--start $1 \
--vertical-label "Volume Usage" \
--title "Volume Usage $MNTPOINT@$HOSTNAME" \
--width 500 \
--height 100 \
--base 1024 \
--lower-limit 0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:TOTAL=$FNRRD:TOTAL:AVERAGE" \
"DEF:USAGE=$FNRRD:USAGE:AVERAGE" \
"CDEF:CTOTAL=TOTAL,1024,*" \
"CDEF:CUSAGE=USAGE,1024,*" \
"CDEF:CTOTAL60=TOTAL,0.6,*,1024,*" \
"CDEF:CAREAW=CUSAGE,CTOTAL60,GT,CUSAGE,0,IF" \
"CDEF:CAREAU=CUSAGE,CTOTAL60,GT,CTOTAL60,CUSAGE,IF" \
"AREA:CAREAW#EC9D48" \
"AREA:CAREAU#68E4FC" \
"LINE:CUSAGE#1598C3:$MNTPOINT Usage" \
"GPRINT:CUSAGE:AVERAGE:%.1lf %S" \
"LINE:CTOTAL#CC3118:$MNTPOINT Total" \
"GPRINT:CTOTAL:AVERAGE:%.1lf %S" \
> /dev/null
}
graphVol -1d day
MI=`date +'%M'`
if [ "$MI" -lt "5" ]; then
graphVol -1w week
graphVol -1m month
graphVol -1y year
fi
done
-
디스크 사용량을 모니터링 해준다. 솔라리스에 연결된 디스크에 대한 읽기/쓰기 바이트수를 모니터링 한다.
#!/bin/bash
# Monitoring disk activity for solaris
# WindyHana's Solanara: RRDtool
# http://www.solanara.net/solanara/rrdtool
# last update: 2014.03.17
PATH=/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/rrdtool/bin:/opt/rrdtool/bin
LANG=C
if [ "$RRDTOOL_BIN" == "" ]; then
RRDTOOL_BIN=`which rrdtool`
if [ "$RRDTOOL_BIN" == "" ]; then
echo "Cannot find RRDTool. Set $RRDTOOL_BIN env."
exit 1;
fi
fi
if [ "$RRDTOOL_HOME" != "" ]; then
cd "$RRDTOOL_HOME"
else
cd `dirname $0`
fi
CONFFN="rrdtool_dskstat.conf"
FNPREFIX="rrdtool_dskstat_"
FNSUFFIX=".rrd"
if [ ! -f $CONFFN ]; then
DISKS=`kstat -p :::class | grep disk | grep -v unix | awk -F: '{print $3}'`
echo "# Generated by rrdtool_dskstat.sh" > $CONFFN
echo "# If you want add DISK INSTANCES, edit carefully, must use space as seperater." >> $CONFFN
echo "DISKS='$DISKS'" >> $CONFFN
fi
. $CONFFN
if [ "$DISKS" == "" ]; then
echo "Cannot determine disks."
exit 1
fi
TEMPFN="/tmp/rrdtool_dskstat_status_$$"
RRDCREATECMD=""
DATA=""
RRDGRAPHCMD=""
NUM=0
for DISKID in $DISKS; do
IDX=$NUM
NUM=`expr $NUM + 1`
FN="$FNPREFIX$DISKID$FNSUFFIX"
STATI="::$DISKID"
DATA=`kstat -p \
$STATI:nread $STATI:nwritten \
$STATI:reads $STATI:writes \
$STATI:rtime $STATI:wtime \
$STATI:rlentime $STATI:wlentime \
$STATI:rcnt $STATI:wcnt \
$STATI:rlastupdate $STATI:wlastupdate \
| awk '{print $2}' \
| awk -F. '{print $1}' \
| sed -n -e 'N;N;N;N;N;N;N;N;N;N;N;s/\n/\:/g;p'`
if [ ! -f $FN ]; then
rrdtool create $FN \
--step 60 \
"DS:NREAD:DERIVE:600:0:U" \
"DS:NWRITE:DERIVE:600:0:U" \
"DS:READ:DERIVE:600:0:U" \
"DS:WRITE:DERIVE:600:0:U" \
"DS:RTIME:DERIVE:600:0:U" \
"DS:WTIME:DERIVE:600:0:U" \
"DS:RLENTIME:DERIVE:600:0:U" \
"DS:WLENTIME:DERIVE:600:0:U" \
"DS:RCNT:GAUGE:600:0:U" \
"DS:WCNT:GAUGE:600:0:U" \
"DS:RLASTUPDATE:DERIVE:600:0:U" \
"DS:WLASTUPDATE:DERIVE:600:0:U" \
"RRA:AVERAGE:0.5:1:1440" \
"RRA:AVERAGE:0.5:5:1440" \
"RRA:AVERAGE:0.5:30:800" \
"RRA:AVERAGE:0.5:120:800" \
"RRA:AVERAGE:0.5:1440:800"
fi
rrdupdate $FN N:$DATA
function graphDsk {
rrdtool graph $FNPREFIX${DISKID}_opr_$2.png \
--start $1 \
--vertical-label "Bytes/s" \
--title "Disk Stat ${DISKID}@$HOSTNAME" \
--width 500 \
--height 100 \
--base 1024 \
--right-axis-label 'Operations/s' \
--right-axis 0.0001:0 \
--lower-limit 0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:NREAD=$FN:NREAD:AVERAGE" \
"DEF:NWRITE=$FN:NWRITE:AVERAGE" \
"DEF:READ=$FN:READ:AVERAGE" \
"DEF:WRITE=$FN:WRITE:AVERAGE" \
"CDEF:CNREAD=NREAD" \
"CDEF:CNWRITE=NWRITE" \
"CDEF:CREAD=READ,10000,*" \
"CDEF:CWRITE=WRITE,10000,*" \
"LINE:CNREAD#EA644A:Read bytes" \
"GPRINT:NREAD:LAST:%.1lf %S/s" \
"LINE:CNWRITE#54EC48:Write bytes" \
"GPRINT:NWRITE:LAST:%.1lf %S/s" \
"LINE:CREAD#EC9D48:Read" \
"GPRINT:READ:LAST:%.1lf" \
"LINE:CWRITE#7648EC:Write" \
"GPRINT:WRITE:LAST:%.1lf" \
> /dev/null
rrdtool graph $FNPREFIX${DISKID}_que_$2.png \
--start $1 \
--vertical-label "Queue Waits" \
--title "Disk Stat Queue Waits ${DISKID}@$HOSTNAME" \
--width 500 \
--height 100 \
--base 1024 \
--lower-limit 0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:RCNT=$FN:RCNT:AVERAGE" \
"DEF:WCNT=$FN:WCNT:AVERAGE" \
"LINE:RCNT#EA644A:Read Queue Counts" \
"GPRINT:RCNT:LAST:%.0lf" \
"LINE:WCNT#54EC48:Write Queue Counts" \
"GPRINT:WCNT:LAST:%.0lf" \
> /dev/null
rrdtool graph $FNPREFIX${DISKID}_hrt_$2.png \
--start $1 \
--vertical-label "nano seconds/s" \
--title "Disk Stat Time ${DISKID}@$HOSTNAME" \
--width 500 \
--height 100 \
--base 1024 \
--lower-limit 0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:RTIME=$FN:RTIME:AVERAGE" \
"DEF:WTIME=$FN:WTIME:AVERAGE" \
"DEF:RLENTIME=$FN:RLENTIME:AVERAGE" \
"DEF:WLENTIME=$FN:WLENTIME:AVERAGE" \
"CDEF:GRTIME=RTIME,1000,*" \
"CDEF:GWTIME=WTIME,1000,*" \
"LINE:RTIME#EA644A:R Time" \
"GPRINT:GRTIME:LAST:%.0lf ps/s" \
"LINE:WTIME#54EC48:W Time" \
"GPRINT:GWTIME:LAST:%.0lf ps/s" \
"LINE:RLENTIME#EC9D48:R LenTime" \
"LINE:WLENTIME#7648EC:W LenTime" \
> /dev/null
}
graphDsk -1d day
MI=`date +'%M'`
if [ "$MI" -lt "5" ]; then
graphDsk -1w week
graphDsk -1m month
graphDsk -1y year
fi
done
rm -f $TEMPFN
-
Apache httpd 의 사용량에 대한 그래프를 그려준다.
apachectl status명령의 결과를 사용하며, 초당 요청 정보와 초당 사용량, MPM의 클라이언트 사용량을 그려주는데, mod_status가 활성화 되어있어야 하며, lynx(1) (윈디하나의 솔라나라: lynx 참조)가 설치되어있어야 한다. mod_status를 활성화 하는 방법은 Apache Module mod_status를 읽어보자.
#!/bin/bash
# Monitoring Apache for Solaris, Linux
# WindyHana's Solanara: RRDtool
# http://www.solanara.net/solanara/rrdtool
# last update: 2014.04.07
PATH=/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/rrdtool/bin:/opt/rrdtool/bin
LANG=C
if [ "$RRDTOOL_BIN" == "" ]; then
RRDTOOL_BIN=`which rrdtool`
if [ "$RRDTOOL_BIN" == "" ]; then
echo 'Cannot find RRDTool. Set $RRDTOOL_BIN env.'
exit 1;
fi
fi
if [ "$RRDTOOL_HOME" != "" ]; then
cd "$RRDTOOL_HOME"
else
cd `dirname $0`
fi
FNPREFIX="rrdtool_apache"
if [ "$LYNX" == "" ]; then
LYNX=`which lynx`
if [ ! -x "$LYNX" ]; then
echo 'Cannot run Lynx. Set $LYNX env.'
exit 1
fi
fi
if [ "$STATUSURL" == "" ]; then
STATUSURL="http://localhost/server-status"
fi
FN="$FNPREFIX.rrd"
if [ ! -f $FN ]; then
rrdtool create $FN \
--step 60 \
"DS:Accesses:DERIVE:600:0:U" \
"DS:kBytes:DERIVE:600:0:U" \
"DS:CPULoad:GAUGE:600:0:U" \
"DS:Uptime:GAUGE:600:0:U" \
"DS:ReqPerSec:GAUGE:600:0:U" \
"DS:BytesPerSec:GAUGE:600:0:U" \
"DS:BytesPerReq:GAUGE:600:0:U" \
"DS:BusyWorkers:GAUGE:600:0:U" \
"DS:IdleWorkers:GAUGE:600:0:U" \
"RRA:AVERAGE:0.5:1:1440" \
"RRA:AVERAGE:0.5:5:1440" \
"RRA:AVERAGE:0.5:30:800" \
"RRA:AVERAGE:0.5:120:800" \
"RRA:AVERAGE:0.5:1440:800"
fi
TMPFN=/tmp/rrdtool_apache_$$
$LYNX -dump $STATUSURL?auto > $TMPFN
if [ "$?" != "0" ]; then
echo "Cannot retrive httpd status. '$STATUSURL' is invalid?";
rm $TMPFN
exit 1
fi;
#DATA=`cat $TMPFN | sed -n -e 'N;N;N;N;N;N;N;N;s/\n/ /g;p' | head -1 | awk '{printf("%d:%d:%f:%d:%f:%f:%f:%d:%d", $3, $6, $8, $10, $12, $14, $16, $18, $20)}'`
Accesses=`cat $TMPFN | grep 'Total Accesses' | awk '{printf("%d", $3)}'`
kBytes=`cat $TMPFN | grep 'Total kBytes' | awk '{printf("%d", $3)}'`
CPULoad=`cat $TMPFN | grep 'Load1:' | awk '{printf("%f", $2)}'`
Uptime=`cat $TMPFN | grep 'ServerUptimeSeconds' | awk '{printf("%d", $2)}'`
ReqPerSec=`cat $TMPFN | grep 'ReqPerSec' | awk '{printf("%f", $2)}'`
BytesPerSec=`cat $TMPFN | grep 'BytesPerSec' | tail -1 | awk '{printf("%f", $2)}'`
BytesPerReq=`cat $TMPFN | grep 'BytesPerReq' | tail -1 | awk '{printf("%f", $2)}'`
BusyWorkers=`cat $TMPFN | grep 'BusyWorkers' | tail -1 | awk '{printf("%d", $2)}'`
IdleWorkers=`cat $TMPFN | grep 'IdleWorkers' | tail -1 | awk '{printf("%d", $2)}'`
DATA="$Accesses:$kBytes:$CPULoad:$Uptime:$ReqPerSec:$BytesPerSec:$BytesPerReq:$BusyWorkers:$IdleWorkers"
rm $TMPFN
FACTOR=`echo $DATA | awk -F: '{print $7 / 1024}'`
#FACTOR="0.01"
# 484392:8276985:0.657552:776624:0.623715:10913.400000:17497.500000:1:249
# or use support/log_server_status
$RRDTOOL_BIN update $FN N:$DATA
if [ "$?" != "0" ]; then
echo "Cannot update $FN by previous error.";
exit;
fi
function graphApache {
$RRDTOOL_BIN graph ${FNPREFIX}_sec_$2.png \
--start $1 \
--vertical-label "Requests/s" \
--title "Apache httpd Transmit status" \
--width 500 \
--height 100 \
--lower-limit 0 \
--right-axis-label 'KBytes/s' \
--right-axis $FACTOR:0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:kBytes=$FN:kBytes:AVERAGE" \
"DEF:Accesses=$FN:Accesses:AVERAGE" \
"DEF:Uptime=$FN:Uptime:AVERAGE" \
"CDEF:ckBytes=Uptime,PREV(Uptime),GT,kBytes,UNKN,IF,$FACTOR,/" \
"CDEF:cAccesses=Uptime,PREV(Uptime),GT,Accesses,UNKN,IF" \
"CDEF:gBytes=kBytes,1024,*" \
"CDEF:gAccesses=Accesses" \
"AREA:ckBytes#24BC14: Transfered/s" \
"GPRINT:gBytes:LAST:%.1lf %S" \
"LINE:cAccesses#EA644A:Requests/s" \
"GPRINT:gAccesses:LAST:%.1lf" \
> /dev/null
$RRDTOOL_BIN graph ${FNPREFIX}_req_$2.png \
--start $1 \
--vertical-label "Bytes/Requests" \
--title "Apache httpd status" \
--width 500 \
--height 100 \
--lower-limit 0 \
--right-axis-label 'Bytes/Requests' \
--right-axis 1:0 \
--base 1024 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:BytesPerReq=$FN:BytesPerReq:AVERAGE" \
"CDEF:cBytesPerReq=BytesPerReq" \
"AREA:cBytesPerReq#68E4FC:Bytes/Requests" \
"LINE:cBytesPerReq#1598C3" \
"GPRINT:cBytesPerReq:AVERAGE:%.2lf %S" \
> /dev/null
$RRDTOOL_BIN graph ${FNPREFIX}_worker_$2.png \
--start $1 \
--vertical-label "Workers" \
--title "Apache httpd Worker status" \
--width 500 \
--height 100 \
--lower-limit 0 \
--right-axis-label 'Workers' \
--right-axis 1:0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:BusyWorkers=$FN:BusyWorkers:AVERAGE" \
"DEF:IdleWorkers=$FN:IdleWorkers:AVERAGE" \
"CDEF:cBusyWorkers=BusyWorkers" \
"CDEF:cIdleWorkers=IdleWorkers" \
"CDEF:cTotalWorkers=IdleWorkers,BusyWorkers,+" \
"AREA:cBusyWorkers#7648EC:Busy Workers" \
"GPRINT:cBusyWorkers:AVERAGE:%.0lf" \
"AREA:cIdleWorkers#68E4FC:Idle Workers:STACK" \
"GPRINT:cIdleWorkers:AVERAGE:%.0lf" \
"LINE:cTotalWorkers#EA644A" \
> /dev/null
}
graphApache -1d day
MI=`date +'%M'`
if [ "$MI" -lt "5" ]; then
graphApache -1w week
graphApache -1m month
graphApache -1y year
fi
-
파일 또는 디렉토리의 사용량의 증가량에 대한 그래프를 그려준다. 로그파일의 증가 속도를 가늠하기 위해 만들었다.
#!/bin/bash
# Monitoring File, Directory Growth for Solaris, Linux
# WindyHana's Solanara: RRDtool
# http://www.solanara.net/solanara/rrdtool
# last update: 2014.12.10
PATH=/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/rrdtool/bin:/opt/rrdtool/bin
LANG=C
if [ "$RRDTOOL_BIN" == "" ]; then
RRDTOOL_BIN=`which rrdtool`
if [ "$RRDTOOL_BIN" == "" ]; then
echo "Cannot find RRDTool. Set $RRDTOOL_BIN env."
exit 1;
fi
fi
if [ "$RRDTOOL_HOME" != "" ]; then
cd "$RRDTOOL_HOME"
else
cd `dirname $0`
fi
MI=`date +'%M'`
MI=$(expr $MI + 0)
HR=`date +'%H'`
HR=$(expr $HR + 0)
let MOD5=$MI%5;
let MOD30=$MI%30;
if [ "$1" == "" ]; then
echo "Usage: $0 rrdsuffix filepath[:filepath[:filepath[:filepath]]]";
exit 1;
fi
KEY="$1"
GROWTHPATH="$2"
FNPREFIX="rrdtool_growth_$KEY"
FNRRD="$FNPREFIX.rrd"
COLORS=("" "#EA644A" "#54EC48" "#48C4EC" "#DE48EC" "#7648EC")
OIFS="$IFS"
IFS=':' read -a GROWTHPATHARR <<< "$GROWTHPATH"
IFS="$OIFS"
N=0;
for GROWTHFILE in "${GROWTHPATHARR[@]}"; do
N=`expr $N + 1`
FN=`basename $GROWTHFILE`
if [ -f "$GROWTHFILE" ]; then
GROWTHSIZE=`ls -l "$GROWTHFILE" | awk -F" " '{ print $5 }'`
elif [ -d "$GROWTHFILE" ]; then
GROWTHSIZE=`du -sk "$GROWTHFILE" | awk '{print $1}'`
GROWTHSIZE=`expr $GROWTHSIZE "*" 1024`
else
GROWTHSIZE="-"
fi;
COLOR=${COLORS[N]}
CREATEDATA="$CREATEDATA DS:file$N:DERIVE:600:0:U"
GRAPHDATA="$GRAPHDATA DEF:file$N=$FNRRD:file$N:AVERAGE LINE:file$N$COLOR:$FN"
DATA="$DATA:$GROWTHSIZE"
done
if [ ! -f $FNRRD ]; then
rrdtool create $FNRRD \
--step 60 \
$CREATEDATA \
"RRA:AVERAGE:0.5:1:1440" \
"RRA:AVERAGE:0.5:5:1440" \
"RRA:AVERAGE:0.5:30:800" \
"RRA:AVERAGE:0.5:120:800" \
"RRA:AVERAGE:0.5:1440:800"
fi
rrdtool update $FNRRD N$DATA
function graphFile {
$RRDTOOL_BIN graph ${FNPREFIX}_$2.png \
--start $1 \
--vertical-label "bytes/s" \
--title "File/Directory Growth ($KEY)" \
--width 500 \
--height 100 \
--lower-limit 0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
$GRAPHDATA \
> /dev/null
}
graphFile -1d day
if [ "$MOD5" == "0" ]; then
graphFile -1d day
fi
if [ "$MOD30" == "0" ]; then
graphFile -1w week
fi
if [ "$MI" == "0" ]; then
graphFile -1m month
fi
if [ "$HR" == "0" ]; then
graphFile -1y year
fi
-
MySQL의 사용량을 측정한다. MySQL 5.6 ~ 8.0 기준으로 작성했다.
#!/bin/bash
# MySQL Query usage
# WindyHana's Solanara: RRDtool
# http://www.solanara.net/solanara/rrdtool
# last update: 2018.12.10
PATH=/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/rrdtool/bin:/opt/rrdtool/bin:/usr/local/mysql/bin
LANG=C
if [ "$RRDTOOL_BIN" == "" ]; then
RRDTOOL_BIN=`which rrdtool`
if [ "$RRDTOOL_BIN" == "" ]; then
echo "Cannot find RRDTool. Set $RRDTOOL_BIN env."
exit 1;
fi
fi
if [ "$RRDTOOL_HOME" != "" ]; then
cd "$RRDTOOL_HOME"
else
cd `dirname $0`
fi
MI=`date +'%M'`
MI=$(expr $MI + 0)
HR=`date +'%H'`
HR=$(expr $HR + 0)
let MOD5=$MI%5;
let MOD30=$MI%30;
#MYSQLLOGINSTR=MySQL login command here
if [ "$MYSQL_BIN" == "" ]; then
MYSQL_BIN=`which mysql`
fi
if [ "$QUESTIONSFACTOR" == "" ]; then
QUESTIONSFACTOR=2
fi
if [ "$ROWSFACTOR" == "" ]; then
ROWSFACTOR=100
fi
# Set MySQL login string
if [ "$MYSQLLOGINSTR" == "" ]; then
echo Must be set MYSQLLOGINSTR env
echo MYSQLLOGINSTR=\"--user=username --password=password --host==localhost --port=3306\"\; export MYSQLLOGINSTR
exit 1
fi
STATUSFN="/tmp/rrdtool_mysql_status_$$"
GLOBALSTATUSFN="/tmp/rrdtool_mysql_globalstatus_$$"
VARFN="/tmp/rrdtool_mysql_var_$$"
# Get Total Questions and Queries Avg.
echo "status" | $MYSQL_BIN $MYSQLLOGINSTR > $STATUSFN
echo "show global status" | $MYSQL_BIN $MYSQLLOGINSTR > $GLOBALSTATUSFN
echo "show variables" | $MYSQL_BIN $MYSQLLOGINSTR > $VARFN
QUERIES=`echo "show global status like 'Com\_%'" | $MYSQL_BIN $MYSQLLOGINSTR | sed 1d | awk '{sum += $2} END { print sum }'`
QUESTIONS=`cat $STATUSFN | grep Questions | awk -e '{print $4}'`
QUERYSAVG=`cat $STATUSFN | grep "Queries per second avg" | awk -e '{print $20}'`
ROWS_READ=`cat $GLOBALSTATUSFN | grep 'Innodb_rows_read' | awk -e '{print $2}'`
ROWS_INSERT=`cat $GLOBALSTATUSFN | grep 'Innodb_rows_inserted' | awk -e '{print $2}'`
ROWS_UPDATE=`cat $GLOBALSTATUSFN | grep 'Innodb_rows_updated' | awk -e '{print $2}'`
ROWS_DELETE=`cat $GLOBALSTATUSFN | grep 'Innodb_rows_deleted' | awk -e '{print $2}'`
QUERYS_SELECT=`cat $GLOBALSTATUSFN | grep 'Com_select' | head -1 | awk -e '{print $2}'`
QUERYS_INSERT=`cat $GLOBALSTATUSFN | grep 'Com_insert' | head -1 | awk -e '{print $2}'`
QUERYS_INSERTSELECT=`cat $GLOBALSTATUSFN | grep 'Com_insert_select' | head -1 | awk -e '{print $2}'`
QUERYS_UPDATE=`cat $GLOBALSTATUSFN | grep 'Com_update' | head -1 | awk -e '{print $2}'`
QUERYS_UPDATEMULTI=`cat $GLOBALSTATUSFN | grep 'Com_update_multi' | head -1 | awk -e '{print $2}'`
QUERYS_DELETE=`cat $GLOBALSTATUSFN | grep 'Com_delete' | head -1 | awk -e '{print $2}'`
QUERYS_DELETEMULTI=`cat $GLOBALSTATUSFN | grep 'Com_delete_multi' | head -1 | awk -e '{print $2}'`
# Query Cache Supported?
QCACHE=`cat $VARFN | grep 'query_cache_type' | awk -e '{print $2}'`
if [ "$QCACHE" == "ON" ]; then
QCACHE_TOTAL=`cat $VARFN | grep 'query_cache_limit' | awk -e '{print $2}'`
QCACHE_FREE=`cat $GLOBALSTATUSFN | grep 'Qcache_free_memory' | awk -e '{print $2}'`
QCACHE_TOTALBLOCK=`cat $GLOBALSTATUSFN | grep 'Qcache_total_blocks' | head -1 | awk -e '{print $2}'`
QCACHE_FREEBLOCK=`cat $GLOBALSTATUSFN | grep 'Qcache_free_blocks' | head -1 | awk -e '{print $2}'`
QCACHE_QUERIES=`cat $GLOBALSTATUSFN | grep 'Qcache_queries_in_cache' | head -1 | awk -e '{print $2}'`
QCACHE_HIT=`cat $GLOBALSTATUSFN | grep 'Qcache_hits' | head -1 | awk -e '{print $2}'`
QCACHE_NOTCACHED=`cat $GLOBALSTATUSFN | grep 'Qcache_not_cached' | head -1 | awk -e '{print $2}'`
QCACHE_INSERTS=`cat $GLOBALSTATUSFN | grep 'Qcache_inserts' | head -1 | awk -e '{print $2}'`
QCACHE_PRUNES=`cat $GLOBALSTATUSFN | grep 'Qcache_lowmem_prunes' | head -1 | awk -e '{print $2}'`
else
QCACHE_TOTAL=0
QCACHE_FREE=0
QCACHE_TOTALBLOCK=0
QCACHE_FREEBLOCK=0
QCACHE_QUERIES=0
QCACHE_HIT=0
QCACHE_NOTCACHED=0
QCACHE_INSERTS=0
QCACHE_PRUNES=0
fi
rm $GLOBALSTATUSFN
rm $STATUSFN
rm $VARFN
FNRRD="rrdtool_mysql.rrd"
if [ ! -f $FNRRD ]; then
$RRDTOOL_BIN create $FNRRD \
--step 60 \
"DS:queriesavg:GAUGE:120:0:U" \
"DS:questions:DERIVE:120:0:U" \
"DS:rowsread:DERIVE:120:0:U" \
"DS:rowsinsert:DERIVE:120:0:U" \
"DS:rowsupdate:DERIVE:120:0:U" \
"DS:rowsdelete:DERIVE:120:0:U" \
"DS:queriesselect:DERIVE:120:0:U" \
"DS:queriesinsert:DERIVE:120:0:U" \
"DS:queriesupdate:DERIVE:120:0:U" \
"DS:queriesdelete:DERIVE:120:0:U" \
"DS:queries:DERIVE:120:0:U" \
"DS:qcachetotal:GAUGE:120:0:U" \
"DS:qcachefree:GAUGE:120:0:U" \
"DS:qcachetotalblock:GAUGE:120:0:U" \
"DS:qcachefreeblock:GAUGE:120:0:U" \
"DS:qcachequeries:GAUGE:120:0:U" \
"DS:qcachehit:DERIVE:120:0:U" \
"DS:qcachenotcached:DERIVE:120:0:U" \
"DS:qcacheinserts:DERIVE:120:0:U" \
"DS:qcacheprunes:DERIVE:120:0:U" \
"RRA:AVERAGE:0.5:1:1440" \
"RRA:AVERAGE:0.5:5:1440" \
"RRA:AVERAGE:0.5:30:800" \
"RRA:AVERAGE:0.5:120:800" \
"RRA:AVERAGE:0.5:1440:800"
fi
DATA=$QUESTIONS:$ROWS_READ:$ROWS_INSERT:$ROWS_UPDATE:$ROWS_DELETE:$QUERYS_SELECT:$QUERYS_INSERT:$QUERYS_UPDATE:$QUERYS_DELETE:$QUERIES
CACHEDATA=$QCACHE_TOTAL:$QCACHE_FREE:$QCACHE_TOTALBLOCK:$QCACHE_FREEBLOCK:$QCACHE_QUERIES:$QCACHE_HIT:$QCACHE_NOTCACHED:$QCACHE_INSERTS:$QCACHE_PRUNES
$RRDTOOL_BIN update $FNRRD N:$QUERYSAVG:$DATA:$CACHEDATA
#for debug
#DT=`date`
#TS=`perl -e 'print time(), "\n" '`
#echo $DT $TS N:$QUERYSAVG:$DATA1:$DATA1 >> /tmp/rrdtool_mysql.data
function graphMySQL {
$RRDTOOL_BIN graph rrdtool_mysql_query_$2.png \
--start $1 \
--alt-autoscale-max \
--vertical-label "Queries/s" \
--title "MySQL Queries ($HOSTNAME)" \
--width 500 \
--height 100 \
--lower-limit 0 \
--right-axis-label 'Questions/s' \
--right-axis $QUESTIONSFACTOR:0 \
--disable-rrdtool-tag \
"DEF:cntquestions=$FNRRD:questions:AVERAGE" \
"DEF:cntqueries=$FNRRD:queries:AVERAGE" \
"DEF:cntselect=$FNRRD:queriesselect:AVERAGE" \
"DEF:cntinsert=$FNRRD:queriesinsert:AVERAGE" \
"DEF:cntupdate=$FNRRD:queriesupdate:AVERAGE" \
"DEF:cntdelete=$FNRRD:queriesdelete:AVERAGE" \
"CDEF:cquestions=cntquestions,$QUESTIONSFACTOR,/" \
"CDEF:cquestionsgprint=cntquestions" \
"CDEF:cqueries=cntqueries" \
"CDEF:cselect=cntselect" \
"CDEF:cinsert=cntinsert" \
"CDEF:cupdate=cntupdate" \
"CDEF:cdelete=cntdelete" \
"AREA:cselect#FF9090:select" \
"AREA:cinsert#00FF00:insert:STACK" \
"AREA:cupdate#8080FF:update:STACK" \
"AREA:cdelete#FFFF00:delete:STACK" \
"LINE:cqueries#4D18E4:Queries/s" \
"GPRINT:cqueries:AVERAGE:%.1lf" \
"LINE:cquestions#A0A0A0:Questions/s" \
"GPRINT:cquestionsgprint:AVERAGE:%.1lf" \
> /dev/null
$RRDTOOL_BIN graph rrdtool_mysql_rows_$2.png \
--start $1 \
--alt-autoscale-max \
--vertical-label "Rows Affected/s" \
--title "MySQL Query Rows ($HOSTNAME)" \
--width 500 \
--height 100 \
--lower-limit 0 \
--right-axis-label 'Rows read/s' \
--right-axis $ROWSFACTOR:0 \
--disable-rrdtool-tag \
"DEF:read=$FNRRD:rowsread:AVERAGE" \
"DEF:insert=$FNRRD:rowsinsert:AVERAGE" \
"DEF:update=$FNRRD:rowsupdate:AVERAGE" \
"DEF:delete=$FNRRD:rowsdelete:AVERAGE" \
"CDEF:cread=read,$ROWSFACTOR,/" \
"CDEF:cinsert=insert" \
"CDEF:cupdate=update" \
"CDEF:cdelete=delete" \
"LINE:cread#7648EC:Rows read" \
"AREA:cinsert#EA644A:Rows insert" \
"AREA:cupdate#54EC48:Rows update:STACK" \
"AREA:cdelete#48C4EC:Rows delete:STACK" \
> /dev/null
if [ "$QCACHE" == "ON" ]; then
$RRDTOOL_BIN graph rrdtool_mysql_cache_$2.png \
--start $1 \
--vertical-label "Cache (bytes)" \
--title "MySQL Query Cache ($HOSTNAME)" \
--width 500 \
--height 100 \
--lower-limit 0 \
--base 1024 \
--right-axis-label "Queries in cache" \
--right-axis 0.0009765625:0 \
--right-axis-format %.0lf \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:qcachetotal=$FNRRD:qcachetotal:AVERAGE" \
"DEF:qcachefree=$FNRRD:qcachefree:AVERAGE" \
"DEF:qcachequeries=$FNRRD:qcachequeries:AVERAGE" \
"CDEF:cqcachetotal=qcachetotal" \
"CDEF:cqcacheuse=qcachetotal,qcachefree,-" \
"CDEF:cqcachequeries=qcachequeries,1024,*" \
"LINE:cqcachetotal#7648EC:Cache Total" \
"AREA:cqcacheuse#54EC48:Cache Used" \
"LINE:cqcachequeries#EA644A:Queries in cache" \
> /dev/null
$RRDTOOL_BIN graph rrdtool_mysql_ratio_$2.png \
--start $1 \
--vertical-label "counts/s" \
--title "MySQL Query Ratio ($HOSTNAME)" \
--width 500 \
--height 100 \
--lower-limit 0 \
--right-axis-label "counts/s" \
--right-axis 1:0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:qcachehit=$FNRRD:qcachehit:AVERAGE" \
"DEF:qcachenotcached=$FNRRD:qcachenotcached:AVERAGE" \
"DEF:qcacheinserts=$FNRRD:qcacheinserts:AVERAGE" \
"DEF:qcacheprunes=$FNRRD:qcacheprunes:AVERAGE" \
"CDEF:cqcachehit=qcachehit" \
"CDEF:cqcachenotcached=qcachenotcached" \
"CDEF:cqcacheinserts=qcacheinserts" \
"CDEF:cqcacheprunes=qcacheprunes" \
"LINE:cqcachenotcached#EA644A:Cache Miss" \
"LINE:cqcacheinserts#54EC48:Cache Inserts" \
"LINE:cqcacheprunes#DE48EC:Cache Prunes" \
"LINE:cqcachehit#7648EC:Cache Hits" \
> /dev/null
fi
}
if [ "$MOD5" == "0" ]; then
graphMySQL -1d day
fi
if [ "$MOD30" == "0" ]; then
graphMySQL -1w week
fi
if [ "$MI" == "0" ]; then
graphMySQL -1m month
fi
if [ "$HR" == "0" ]; then
graphMySQL -1y year
fi
-
라즈베리 파이를 모니터링 해준다. 최신 라즈비안에서 테스트해보았다. 라즈베리 파이와 라즈비안에 대대해서는 윈디하나의 솔라나라: Raspberry Pi Raspbian를 읽어보자.
#!/bin/bash
# Monitoring Raspberry Pi
# WindyHana's Solanara: RRDtool
# http://www.solanara.net/solanara/rrdtool
# last update: 2016.06.18
PATH=/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/rrdtool/bin:/opt/rrdtool/bin
LANG=C
if [ "$RRDTOOL_BIN" == "" ]; then
RRDTOOL_BIN=`which rrdtool`
if [ "$RRDTOOL_BIN" == "" ]; then
echo "Cannot find RRDTool. Set $RRDTOOL_BIN env or run 'sudo apt-get install rrdtool'"
exit 1;
fi
fi
if [ -f /etc/os-release ]; then
ISPI=`cat /etc/os-release | grep -e "^ID=raspbian"`
if [ "$ISPI" != "ID=raspbian" ]; then
echo "This script run only on Raspbian"
exit 1;
fi
else
echo "This script run only on Raspbian"
exit 1;
fi
if [ "$RRDTOOL_HOME" != "" ]; then
cd "$RRDTOOL_HOME"
else
cd `dirname $0`
fi
FNPREFIX="rrdtool_pi_"
FNCONF="rrdtool_pi.conf"
FNRRDSUFFIX=".rrd"
FNGRASUFFIX=".png"
if [ -f "$FNCONF" ]; then
. "$FNCONF"
fi
if [ "$PI_TEMP" == "" ]; then
if [ -x "/usr/bin/vcgencmd" ]; then
PI_TEMP=`/usr/bin/vcgencmd measure_temp | cut -d'=' -f2 | cut -d"'" -f1`
else
echo "Cannot get Temp";
exit 1;
fi
fi
if [ "$PI_MEM" == "" ]; then
if [ -x "/usr/bin/free" ]; then
PI_MEM=`/usr/bin/free -o | tail -2 | sed -n -e 'N;s/\n/ \:/g;p' | awk '{printf("%d:%d:%d:%d:%d:%d:%d:%d:%d", $2, $3, $4, $5, $6, $7, $9, $10, $11)}'`
else
echo "Cannot get MEM";
exit 1;
fi
fi
if [ "$PI_VOLTS" == "" ]; then
if [ -x "/usr/bin/vcgencmd" ]; then
V1=`/usr/bin/vcgencmd measure_volts core | cut -d"=" -f2 | cut -d"V" -f1`
V2=`/usr/bin/vcgencmd measure_volts sdram_c | cut -d"=" -f2 | cut -d"V" -f1`
V3=`/usr/bin/vcgencmd measure_volts sdram_i | cut -d"=" -f2 | cut -d"V" -f1`
V4=`/usr/bin/vcgencmd measure_volts sdram_p | cut -d"=" -f2 | cut -d"V" -f1`
PI_VOLTS="$V1:$V2:$V3:$V4"
else
echo "Cannot get Volts";
exit 1;
fi
fi
FNRRD_TEMP="${FNPREFIX}temp${FNRRDSUFFIX}"
FNRRD_MEM="${FNPREFIX}mem${FNRRDSUFFIX}"
FNRRD_VOLTS="${FNPREFIX}volts${FNRRDSUFFIX}"
if [ ! -f "$FNRRD_TEMP" ]; then
$RRDTOOL_BIN create "$FNRRD_TEMP" \
--step 60 \
"DS:TEMPERATURE:GAUGE:600:0:U" \
"RRA:AVERAGE:0.5:1:1440" \
"RRA:AVERAGE:0.5:5:1440" \
"RRA:AVERAGE:0.5:30:800" \
"RRA:AVERAGE:0.5:120:800" \
"RRA:AVERAGE:0.5:1440:800"
fi
if [ ! -f "$FNRRD_MEM" ]; then
$RRDTOOL_BIN create "$FNRRD_MEM" \
--step 60 \
"DS:TOTAL:GAUGE:600:0:U" \
"DS:USED:GAUGE:600:0:U" \
"DS:FREE:GAUGE:600:0:U" \
"DS:SHARED:GAUGE:600:0:U" \
"DS:BUFFERS:GAUGE:600:0:U" \
"DS:CACHED:GAUGE:600:0:U" \
"DS:SWAPTOTAL:GAUGE:600:0:U" \
"DS:SWAPUSED:GAUGE:600:0:U" \
"DS:SWAPFREE:GAUGE:600:0:U" \
"RRA:AVERAGE:0.5:1:1440" \
"RRA:AVERAGE:0.5:5:1440" \
"RRA:AVERAGE:0.5:30:800" \
"RRA:AVERAGE:0.5:120:800" \
"RRA:AVERAGE:0.5:1440:800"
fi
if [ ! -f "$FNRRD_VOLTS" ]; then
$RRDTOOL_BIN create "$FNRRD_VOLTS" \
--step 60 \
"DS:CORE:GAUGE:600:0:U" \
"DS:SDRAMC:GAUGE:600:0:U" \
"DS:SDRAMI:GAUGE:600:0:U" \
"DS:SDRAMP:GAUGE:600:0:U" \
"RRA:AVERAGE:0.5:1:1440" \
"RRA:AVERAGE:0.5:5:1440" \
"RRA:AVERAGE:0.5:30:800" \
"RRA:AVERAGE:0.5:120:800" \
"RRA:AVERAGE:0.5:1440:800"
fi
$RRDTOOL_BIN update $FNRRD_TEMP N:$PI_TEMP
$RRDTOOL_BIN update $FNRRD_MEM N:$PI_MEM
$RRDTOOL_BIN update $FNRRD_VOLTS N:$PI_VOLTS
function graphPi {
$RRDTOOL_BIN graph ${FNPREFIX}temp_$2$FNGRASUFFIX \
--start $1 \
--vertical-label "SoC ('C)" \
--title "Raspberry Pi Temperature@$HOSTNAME" \
--width 500 \
--height 100 \
--lower-limit 0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:TMP=$FNRRD_TEMP:TEMPERATURE:AVERAGE" \
"CDEF:CTEMP=TMP" \
"CDEF:CTEMP85=TMP,POP,85,0,+" \
"CDEF:CAREAW=CTEMP,CTEMP85,GT,CTEMP,0,IF" \
"CDEF:CAREAU=CTEMP,CTEMP85,GT,CTEMP85,CTEMP,IF" \
"AREA:CAREAW#CC3118" \
"AREA:CAREAU#48C4EC" \
"LINE:CTEMP#1598C3:Temprature" \
"GPRINT:CTEMP:LAST:%.1lf %S" \
> /dev/null
$RRDTOOL_BIN graph ${FNPREFIX}mem_$2$FNGRASUFFIX \
--start $1 \
--vertical-label "Memory Usage" \
--title "Raspberry Pi Memory Usage@$HOSTNAME" \
--width 500 \
--height 100 \
--base 1024 \
--lower-limit 0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:TOTAL=$FNRRD_MEM:TOTAL:AVERAGE" \
"DEF:USED=$FNRRD_MEM:USED:AVERAGE" \
"DEF:FREE=$FNRRD_MEM:FREE:AVERAGE" \
"DEF:SHARED=$FNRRD_MEM:SHARED:AVERAGE" \
"DEF:BUFFERS=$FNRRD_MEM:BUFFERS:AVERAGE" \
"DEF:CACHED=$FNRRD_MEM:CACHED:AVERAGE" \
"DEF:SWAPTOTAL=$FNRRD_MEM:SWAPTOTAL:AVERAGE" \
"DEF:SWAPUSED=$FNRRD_MEM:SWAPUSED:AVERAGE" \
"DEF:SWAPFREE=$FNRRD_MEM:SWAPFREE:AVERAGE" \
"CDEF:GFREE=FREE,BUFFERS,CACHED,+,+,1024,*" \
"CDEF:CTOTAL=TOTAL,1024,*" \
"CDEF:CUSED=USED,BUFFERS,-,CACHED,-,SHARED,-,1024,*" \
"CDEF:CFREE=FREE,1024,*" \
"CDEF:CSHARED=SHARED,1024,*" \
"CDEF:CBUFFERS=BUFFERS,1024,*" \
"CDEF:CCACHED=CACHED,1024,*" \
"CDEF:CSWAPTOTAL=SWAPTOTAL,1024,*" \
"CDEF:CSWAPUSED=SWAPUSED,1024,*" \
"CDEF:CSWAPFREE=SWAPFREE,1024,*" \
"AREA:CSHARED#C9B215:Shared" \
"AREA:CUSED#ECD748:Used:STACK" \
"AREA:CBUFFERS#24BC14:Buffers:STACK" \
"AREA:CCACHED#48C4EC:Cached:STACK" \
"AREA:CFREE#1598C3:Free:STACK" \
"LINE:CSWAPTOTAL#CC3118:Swap Total" \
"LINE:CSWAPFREE#CC7016:Swap Free" \
"LINE:CTOTAL#1598C3:" \
"GPRINT:CTOTAL:LAST:Mem Total %.1lf %S" \
"GPRINT:GFREE:LAST:Mem Free %.1lf %S" \
"GPRINT:CSWAPFREE:LAST:Swap Free %.1lf %S" \
> /dev/null
$RRDTOOL_BIN graph ${FNPREFIX}volts_$2$FNGRASUFFIX \
--start $1 \
--vertical-label "Volts (V)" \
--title "Raspberry Pi Volts@$HOSTNAME" \
--width 500 \
--height 100 \
--lower-limit 0 \
--alt-autoscale-max \
--disable-rrdtool-tag \
"DEF:CORE=$FNRRD_VOLTS:CORE:AVERAGE" \
"DEF:SDRAMC=$FNRRD_VOLTS:SDRAMC:AVERAGE" \
"DEF:SDRAMI=$FNRRD_VOLTS:SDRAMI:AVERAGE" \
"DEF:SDRAMP=$FNRRD_VOLTS:SDRAMP:AVERAGE" \
"LINE:SDRAMC#4D18E4:SDRAM Controller" \
"LINE:SDRAMI#1598C3:SDRAM I/O" \
"LINE:SDRAMP#24BC14:SDRAM Physcal" \
"LINE:CORE#CC3118:Core" \
"GPRINT:CORE:LAST:%.3lf V" \
> /dev/null
}
graphPi -1d day
MI=`date +'%M'`
if [ "$MI" -lt "5" ]; then
graphPi -1w week
graphPi -1m month
graphPi -1y year
fi
MRTG에서 RRD파일을 생성하도록 설정했다면 MRTG에서 자동으로 RRD파일을 생성하고, 갱신하게 된다. 인터페이스의 모니터링 항목 한개당 94616 바이트의 작은 rrd 파일이 생성되며, 이 파일에 1년치 평균 데이터까지 모두 저장되어있다.
사용자 노트는 사용자의 제안이나 문서의 정확도 향상을 위해 개발되었습니다. 본문과 관련된 대한 질문/의견등을 노트에 남겨주시면 이 페이지에 방문하는 다른 사용자에게 도움이 될 것입니다. 사용자 노트는 서술한 내용이 반영되거나, 코멘트 내용이 본문과 관련 없는 경우 '삭제'됩니다.