ansaurus

Question

Answer 1

A:

here's one way. tail is used to get the last 2 lines, especially useful in terms of efficiency if you have a big file.

tail -2 file | awk '
{
 gsub(/[a-zA-Z: ]+/," ")
 m=split($0,a," ")
 if (f) {
   for (i=1;i<=m;i++){
        print -(b[i]-a[i])
    }
   # to check for Questions, slow queries etc
   if (  -(b[3]-a[3])  < 100 ){
      print "Questions parameter too low"
   }else if ( -(b[4]-a[4]) > 500 ){
      print "Slow queries more than 500"
   }else if ( a[1] - b[1] < 0 ){
      print "mysql ...... "
   }
    exit
 }
 for(i=1;i<=m;i++ ){ b[i]=a[i] ;f=1 }
} '

output

$ ./shell.sh
61
-1
1063
10
0
0
0
0.1

ghostdog74 2010-01-29 08:59:26

I will like to add one more if /else. If the uptime is less than the earlier one then show the message "mysql service restarted". I could not use "curl" in the if clause.

shantanuo 2010-01-29 11:00:25

if the uptime is less than earlier one, the the value will be less than 0. see the updated code. (NB:give it a shot yourself next time). In doubt, read up the awk docs.

ghostdog74 2010-01-29 11:25:01

I managed to get the values using the method suggested by Ramashalanka. Thanks all.

shantanuo 2010-01-29 12:21:51

Answer 2

A:

gawk:

BEGIN {
  arr[1] = "0"
}
length(arr) > 1 {
  print $2-arr[1], $4-arr[2], $6-arr[3], $9-arr[4], $11-arr[5], $14-arr[6], $17-arr[7], $22-arr[8]
}
{
  arr[1] = $2
  arr[2] = $4
  arr[3] = $6
  arr[4] = $9
  arr[5] = $11
  arr[6] = $14
  arr[7] = $17
  arr[8] = $22
}

Ignacio Vazquez-Abrams 2010-01-29 09:03:21

Answer 3

+1 A:

Just a slight variation on ghostdog74's (original) answer:

tail -2 file | awk ' {
  gsub(/[a-zA-Z: ]+/," ")
  m=split($0,a," ");
  for (i=1;i<=m;i++)
    if (NR==1) b[i]=a[i]; else print a[i] - b[i]
} '

Ramashalanka 2010-01-29 09:19:53

ansaurus

tags:

views:

answers:

calculate the difference from flat file

related questions