analyze 5-sec-status-2011-03-20

引用

#!/bin/sh
#this script converts SHOW GLOBAL STATUS into a tabulated format, one line
#per sample in the input, with the metrics divided by the time elapsed
#between samples.

awk '
  BEGIN{
    printf "#ts date time load QPS";
    fmt = "%.2f";
  }
/^TS/{# The timestamp lines begin with TS.
  ts = substr($2,1,index($2,".")-1);
  load = NF - 2;
  diff = ts - prev_ts;
  prev_ts = ts;
  printf "\n%s %s %s %s",ts,$3,$4,substr($load,1,length($load)-1);
}
/Queries/{
  printf fmt,($2-Queries)/diff;
  Queries=$2
}
' "$@"