topic sums averages in using expr, awk in Operating System - HP-UX

sums averages in using expr, awk

rmueller58 — Wed, 10 Nov 2004 16:05:19 GMT

all,

I am using vmstat and sar, piping output to flat files for some long term performance monitoring.
I want want to create a script that builds a running average of CPU idle, and memory use.
I will have columnar data, I want to summarize daily data files, with sums and averages using "expr", and "awk".

Basically from vmstat out put I will keep a timestamp, avg, free.

I will do something similar with "sar", capturing CPU1 idle, CPU2 idle, and timestamp.

Basically,

I want to create a running average, and a daily average

if Free is Column 2 I want to sum the column and divide by "wc -l"

If someone can show me a quicky on how to use an expr to sum my columns I can probably figure the rest out.

Re: sums averages in using expr, awk

RAC_1 — Wed, 10 Nov 2004 16:10:58 GMT

awk -F "sepeator" '{s+=$1/$whatever} END {print s/NR}'

Anil

Re: sums averages in using expr, awk

Rodney Hills — Wed, 10 Nov 2004 16:11:21 GMT

A typical way I have summed a column in awk is-

awk 'BEGIN{s=0;n=0};{n++;s=s+$2};END{print $s/$n}' myinputfile

HTH

-- Rod Hills

Re: sums averages in using expr, awk

Mark Greene_1 — Wed, 10 Nov 2004 16:13:36 GMT

You can do this in ksh and use the built-in to do the math, as it is much more straight-forward I think:

(( TOTAL_CPU1 = $TOTAL_CPU1 + SAR_CPU1 ))

where you can use some looping mechanism of your choice (for, while, etc) to loop through the file or variable where you've captured the sar data to be totaled.

mark

Re: sums averages in using expr, awk

rmueller58 — Wed, 10 Nov 2004 16:16:46 GMT

Rod,

in the awk
'BEGIN{s=0;n=0};{n++;s=s+$2};END{print $s/$n}'

is the $2 the column of which I want to sum?

Re: sums averages in using expr, awk

Rodney Hills — Wed, 10 Nov 2004 16:20:18 GMT

Yes $2 is the second field.

Change $s/$n to s/n (sometimes I think perl :-)).

-- Rod Hills

Re: sums averages in using expr, awk

rmueller58 — Wed, 10 Nov 2004 16:44:21 GMT

Thanks All.

Did it!!