This morning I was preparing a spreadsheet from 10 hours worth of stats collected on an IBM Power AIX system with:
iostat -DlRT 15 2400
That kind of stuff takes me forever. Don't smirk - you try manipulating the dinky keyboard and diminutive trackpad of a Lenovo laptop with sasquatch hands. It took me at least ten minutes to sort out the rows with only zeroes in the reported stats (based on bps bytes-per-second=0.0) and delete them.
Something was prodding my memory... wasn't there some cool option I used in the past to only report lines with nonzero stats? Something other than piping it to awk?
Sure enough! The -V option. Much nicer! Now back to the work of driving the Oracle reads up to 1 mb from single 32kb database blocks, in order to drive down the IOPs count and make qfulls disappear!
[sasquatch@moutainhome] $ iostat -DlRTV 1 1
System configuration: lcpu=64 drives=32 paths=64 vdisks=0
Disks: xfers read write queue time
-------------- -------------------------------- ------------------------------------ ------------------------------------ -------------------------------------- ---------
%tm bps tps bread bwrtn rps avg min max time fail wps avg min max time fail avg min max avg avg serv
act serv serv serv outs serv serv serv outs time time time wqsz sqsz qfull
hdisk6 54.0 9.7M 185.0 9.7M 0.0 185.0 6.2 0.2 30.2 0 0 0.0 0.0 0.0 0.0 0 0 0.0 0.0 0.6 0.0 0.0 0.0 05:35:27
hdisk3 61.0 4.7M 143.0 4.7M 0.0 143.0 5.9 0.2 29.3 0 0 0.0 0.0 0.0 0.0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 05:35:27
hdisk10 16.0 786.4K 24.0 786.4K 0.0 24.0 8.2 0.3 30.4 0 0 0.0 0.0 0.0 0.0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 05:35:27
No comments:
Post a Comment