Forum Discussion
JJMan
Sep 07, 2016Nimbostratus
Hi, To have the data under /var/rrd, i'm using the command below:
rrdtool xport --start now-2592000 --end now-10 DEF:d1=memory:Rtotal:AVERAGE DEF:d2=memory:Rfree:AVERAGE DEF:d3=memory:Rtmmmemory:AVERAGE DEF:d4=memory:Rtmmused:AVERAGE DEF:d5=rollupcpu:Ruser:AVERAGE DEF:d6=rollupcpu:Rsystem:AVERAGE DEF:d7=rollupcpu:Ridle:AVERAGE DEF:d8=throughput:tput_bytes_in:AVERAGE DEF:d9=throughput:tput_bytes_out:AVERAGE XPORT:d1 XPORT:d2 XPORT:d3 XPORT:d4 XPORT:d5 XPORT:d6 XPORT:d7 XPORT:d8 XPORT:d9
For my daily KPI, i'm using the bash script below:
../..
F5_START=$(date -d `date -d 'yesterday' "+%Y-%m-%d"` +%s)
F5_END=$(date -d `date -d 'now' "+%Y-%m-%d"` +%s)
GREP_CMD=`which grep`;
SED_CMD=`which sed`;
AWK_CMD=`which awk`;
RRDTOOL_CMD=`which rrdtool`;
DATA=`$RRDTOOL_CMD xport --start $F5_START --end $F5_END DEF:d3=memory:Rtmmmemory:AVERAGE DEF:d4=memory:Rtmmused:AVERAGE DEF:d5=rollupcpu:Ruser:AVERAGE DEF:d6=rollupcpu:Rsystem:AVERAGE DEF:d7=rollupcpu:Ridle:AVERAGE DEF:d8=throughput:tput_bytes_in:AVERAGE DEF:d9=throughput:tput_bytes_out:AVERAGE XPORT:d3 XPORT:d4 XPORT:d5 XPORT:d6 XPORT:d7 XPORT:d8 XPORT:d9 | $GREP_CMD "" | $SED_CMD -e 's/<\/t>/;/g' | $SED_CMD -e 's/<\/v>/;/g' | $SED_CMD -e 's///g' | $SED_CMD -e 's/<\/v><\/row>//g' |$SED_CMD -e 's/ //g' | $GREP_CMD -v "NaN" | $AWK_CMD -F';' '{if (tput <= $7+$8) {date=$1;mem=$3*100/$2; cpu=($4+$5)*100/($4+$5+$6); tput=$7+$8}} END{printf "%.0f;%.2f;%.2f;%.2f",date,mem,cpu,tput}'`
date_a=$(date -d @`echo $DATA | awk -F';' '{print $1}'` "+%Y%m%d %H:%M:%S");
CPU_RATIO=`echo $DATA | awk -F';' '{print $3}'`;
MEM_RATIO=`echo $DATA | awk -F';' '{print $2}'`;
THROUGHPUT_TTAL_BYTES=`echo $DATA | awk -F';' '{print $4}'`;
THROUGHPUT_TTAL=$(awk "BEGIN {printf \"%.2f\",${THROUGHPUT_TTAL_BYTES}*8}");
THROUGHPUT_RATIO=$(awk "BEGIN {printf \"%.2f\",${THROUGHPUT_TTAL}*100/${F5_LICTPUT}}");
../..
Hope it helps.