Visit Our UNIX and Linux User Community


Formatting output from iostat


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Formatting output from iostat
# 1  
Old 08-06-2009
Formatting output from iostat

So I use Cacti for monitoring IO statistics on my servers, now originally I couldnt monitor Multipath deviced servers as they have alot of /dev/sdxx and /dev/emcpowerxx, I have devised a method of trimming them down to just the actual devices but the issue is the output looks like so.

Code:
[root@daaorc010b svcsuprt]# iostat -xkd 30 2 `cat /etc/fstab | grep emcpower | awk ' { print $1 } ' | grep -v ^#`                                          
Linux 2.6.9-78.0.17.ELlargesmp (daaorc010b)    08/06/2009

Device:    rrqm/s wrqm/s   r/s   w/s  rsec/s  wsec/s    rkB/s    wkB/s avgrq-sz avgqu-sz   await  svctm  %util
emcpowerad1
             0.00   0.00  0.53  0.50    1.22    0.50     0.61     0.25     1.67     0.00    0.49   0.49   0.05
emcpowera1   0.00   0.00  0.03  0.00    0.19    0.00     0.09     0.00     6.78     0.00    0.36   0.35   0.00
emcpowerau1
             0.57   0.56  1.57  9.54 1097.87 1096.71   548.93   548.36   197.59     0.01    1.35   1.00   1.12
emcpowerav1
             0.00   0.56  0.53  9.54    1.22 1096.71     0.61   548.36   109.00     0.01    0.92   0.73   0.73
emcpoweraw1
             3.76   0.00 93.63 11.43 1552.05  860.13   776.02   430.07    22.96     0.54    5.10   3.03  31.84
emcpowerbc1
             0.00   0.00  0.03  0.00    0.07    0.00     0.04     0.00     2.70     0.00    0.24   0.23   0.00
emcpowerbi1
             1.08   0.00 29.54  8.57 2126.44  505.35  1063.22   252.67    69.06     0.13    3.42   1.38   5.27
emcpowerbe1
             1.42   0.00 33.30  8.70 2612.47  542.55  1306.24   271.28    75.11     0.14    3.39   1.13   4.75
emcpowerc    0.02   2.70  0.44  1.29   46.11   33.70    23.06    16.85    46.12     0.01    4.85   1.52   0.26
emcpowerb    0.04  14.34  1.11  1.43  124.91  126.20    62.45    63.10    98.71     0.03   10.20   1.47   0.37
emcpowerbd1
             1.43   0.01 72.06  9.10 3870.18  543.36  1935.09   271.68    54.38     0.18    2.27   1.01   8.21
emcpoweran1
             0.00   0.00  0.53  0.50    1.22    0.50     0.61     0.25     1.67     0.00    0.49   0.49   0.05
emcpowerao1
             0.00   0.00  0.53  0.50    1.22    0.50     0.61     0.25     1.67     0.00    0.54   0.54   0.06
emcpowercg1
             0.00   0.00  0.53  0.50    1.22    0.50     0.61     0.25     1.67     0.00    0.54   0.54   0.06
emcpowerch1
             0.00   0.00  0.53  0.50    1.22    0.50     0.61     0.25     1.67     0.00    0.49   0.49   0.05
emcpoweram1
             0.00   0.00  0.53  0.50    1.22    0.50     0.61     0.25     1.67     0.00    0.54   0.53   0.05
emcpowerar1
             3.14   0.15 93.49 10.46 9175.99 1025.57  4587.99   512.79    98.13     0.42    4.04   2.54  26.46
emcpowerba1
           423.76   2.08 16.08  4.11 3562.64 3410.64  1781.32  1705.32   345.36     0.09    4.48   3.40   6.87
emcpowerq1   0.62   0.90  0.22  0.02    6.77    7.32     3.39     3.66    57.69     0.00    3.69   3.05   0.07
emcpowerbg1
             2.63   0.49 29.42  3.56 4583.21  908.28  2291.61   454.14   166.52     0.04    1.14   0.60   1.98
emcpowerat1
             0.85   0.60  1.80  1.57 1425.46 1097.62   712.73   548.81   749.59     0.93  275.48   2.06   0.69
emcpowerbj1
             1.00   0.00 20.37 13.21 1759.59  788.88   879.80   394.44    75.89     0.30    8.86   1.47   4.95
emcpowerab   0.00   0.00  6.53  3.49    7.34    3.49     3.67     1.74     1.08     0.01    0.64   0.60   0.60
emcpowerbf1
             0.00   0.23  0.54  1.63    3.63  907.01     1.82   453.51   419.38     0.00    2.19   1.19   0.26
emcpowercb1
           162.94   0.00  6.46  0.50 1352.08    0.50   676.04     0.25   194.23     0.03    3.92   3.24   2.26
emcpowerax1
             2.79   0.00 119.39 11.84 1560.09 1041.68   780.04   520.84    19.83     0.66    5.02   3.13  41.04
emcpowerbh1
             0.00   0.49  0.53  3.56    1.22  908.28     0.61   454.14   222.50     0.01    1.47   1.06   0.43
emcpoweras1
             3.64   0.00 131.96 10.82 2089.97  992.04  1044.98   496.02    21.59     0.86    6.03   3.58  51.16

Device:    rrqm/s wrqm/s   r/s   w/s  rsec/s  wsec/s    rkB/s    wkB/s avgrq-sz avgqu-sz   await  svctm  %util
emcpowerad1
             0.00   0.00  0.50  0.50    1.00    0.50     0.50     0.25     1.50     0.00    0.30   0.30   0.03
emcpowera1   0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
emcpowerau1
             0.00   0.00  0.50  1.94    1.00   28.90     0.50    14.45    12.27     0.00    0.47   0.48   0.12
emcpowerav1
             0.00   0.00  0.50  1.94    1.00   28.90     0.50    14.45    12.27     0.00    0.38   0.38   0.09
emcpoweraw1
             0.00   0.00 52.12  3.77 1647.58  178.81   823.79    89.41    32.68     0.25    4.49   4.29  23.98
emcpowerbc1
             0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
emcpowerbi1
             0.00   0.00 12.98  1.17  392.06   36.80   196.03    18.40    30.31     0.01    0.77   0.77   1.09
emcpowerbe1
             0.00   0.00 12.78  1.13  386.69   35.74   193.34    17.87    30.36     0.01    0.78   0.77   1.07
emcpowerc    0.00   3.04  0.00  0.70    0.00   29.90     0.00    14.95    42.67     0.00    4.38   2.76   0.19
emcpowerb    0.00   0.57  0.00  1.00    0.00   12.55     0.00     6.27    12.53     0.00    4.73   1.73   0.17
emcpowerbd1
             0.00   0.00 43.41  1.53 1354.45   66.70   677.23    33.35    31.62     0.03    0.61   0.59   2.65
emcpoweran1
             0.00   0.00  0.50  0.50    1.00    0.50     0.50     0.25     1.50     0.00    0.30   0.30   0.03
emcpowerao1
             0.00   0.00  0.50  0.50    1.00    0.50     0.50     0.25     1.50     0.00    0.47   0.47   0.05
emcpowercg1
             0.00   0.00  0.50  0.50    1.00    0.50     0.50     0.25     1.50     0.00    0.30   0.30   0.03
emcpowerch1
             0.00   0.00  0.50  0.50    1.00    0.50     0.50     0.25     1.50     0.00    0.37   0.37   0.04
emcpoweram1
             0.00   0.00  0.50  0.50    1.00    0.50     0.50     0.25     1.50     0.00    0.30   0.30   0.03
emcpowerar1
             0.00   0.00 56.89  5.71 1802.40  491.66   901.20   245.83    36.65     0.24    3.88   3.70  23.18
emcpowerba1
             0.00   0.00  0.50  0.50    1.00    0.50     0.50     0.25     1.50     0.00    0.37   0.37   0.04
emcpowerq1   4.30   0.00  1.00  0.00   42.44    0.00    21.22     0.00    42.40     0.00    1.60   1.60   0.16
emcpowerbg1
             1.47   0.00 29.16  5.27 4346.95   30.13  2173.47    15.07   127.11     0.02    0.50   0.46   1.60
emcpowerat1
             0.00   0.00  0.50  0.50    1.00    0.50     0.50     0.25     1.50     0.00    0.33   0.33   0.03
emcpowerbj1
             0.00   0.00  1.84  4.80   29.23  809.88    14.61   404.94   126.37     0.01    1.80   1.35   0.89
emcpowerab   0.00   0.00  6.51  3.50    7.01    3.50     3.50     1.75     1.05     0.00    0.37   0.37   0.37
emcpowerbf1
             0.00   0.00  0.50  0.50    1.00    0.50     0.50     0.25     1.50     0.00    0.27   0.27   0.03
emcpowercb1
             0.00   0.00  0.50  0.50    1.00    0.50     0.50     0.25     1.50     0.00    0.30   0.27   0.03
emcpowerax1
             0.00   0.00 99.13  2.20 3149.98  114.75  1574.99    57.37    32.22     0.53    5.27   4.51  45.72
emcpowerbh1
             0.00   0.00  0.50  5.27    1.00   30.13     0.50    15.07     5.39     0.00    0.50   0.50   0.29
emcpoweras1
             0.00   0.00 171.04  4.80 5451.99  393.43  2725.99   196.71    33.24     0.96    5.44   4.21  74.07

[root@daaorc010b svcsuprt]#

but I need it to look like this (Only formatting wise not device names)

Code:
[root@daaorc302 ~]# cat /tmp/iostat.cache 
Linux 2.6.9-42.ELsmp (daaorc302)       08/06/09

Device:    rrqm/s wrqm/s   r/s   w/s  rsec/s  wsec/s    rkB/s    wkB/s avgrq-sz avgqu-sz   await  svctm  %util
sda          0.02   3.30  0.77  2.12   53.13   43.33    26.56    21.67    33.46     0.01    3.85   2.28   0.66
sdb          0.07   0.10  0.04  0.00    0.91    0.82     0.46     0.41    36.69     0.00    3.13   2.02   0.01
sdc          0.01   0.57  0.30  0.21   49.21   29.78    24.60    14.89   154.47     0.03   51.85  18.00   0.92
sdd          8.25   2.27 85.75  5.40  139.49  782.06    69.75   391.03    10.11     0.23   16.37   4.31  39.27
sde          8.52   2.26 86.72  5.39  304.43  788.84   152.22   394.42    11.87     0.25   16.36   4.32  39.81
sdf          8.27   2.27 85.76  5.17  154.63  783.43    77.31   391.71    10.32     0.42   18.46   4.60  41.82
sdg          8.64   2.26 87.83  4.89  451.81  773.80   225.91   386.90    13.22     1.10   11.87   3.82  35.43
dm-0         0.00   0.00  0.30  2.27    9.33   18.18     4.66     9.09    10.68     0.02    6.40   0.77   0.20
dm-1         0.00   0.00  0.28  1.73   41.27   13.81    20.64     6.91    27.49     0.01    4.42   1.69   0.34
dm-2         0.00   0.00  0.07  1.42    2.14   11.34     1.07     5.67     9.05     0.01    4.78   0.89   0.13

Device:    rrqm/s wrqm/s   r/s   w/s  rsec/s  wsec/s    rkB/s    wkB/s avgrq-sz avgqu-sz   await  svctm  %util
sda          0.00   4.77  0.00  2.43    0.00   57.33     0.00    28.67    23.56     0.01    3.10   1.34   0.33
sdb          0.00   0.00  0.00  0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sdc          0.00   1.40  0.00  6.77    0.00 1072.80     0.00   536.40   158.54     2.24  331.83 147.34  99.70
sdd          0.97   4.63  1.23 27.93  278.40 3791.00   139.20  1895.50   139.52     6.70  236.11  27.79  81.06
sde          0.93   4.10  1.83 24.97  290.13 3403.73   145.07  1701.87   137.83     6.17  231.18  33.08  88.64
sdf          0.93   4.57  1.50 25.83  282.67 3599.80   141.33  1799.90   142.04     7.81  284.86  33.33  91.11
sdg          0.97   4.77  1.17 25.97  273.07 3687.47   136.53  1843.73   145.97     3.25  119.71  22.68  61.53
dm-0         0.00   0.00  0.00  3.90    0.00   31.20     0.00    15.60     8.00     0.02    4.60   0.23   0.09
dm-1         0.00   0.00  0.00  2.53    0.00   20.27     0.00    10.13     8.00     0.01    3.49   0.50   0.13
dm-2         0.00   0.00  0.00  0.73    0.00    5.87     0.00     2.93     8.00     0.00    3.41   1.59   0.12

[root@daaorc302 ~]#



---------- Post updated at 05:02 PM ---------- Previous update was at 12:29 PM ----------

Fixed.... thanks I think.

Previous Thread | Next Thread
Test Your Knowledge in Computers #348
Difficulty: Easy
Awk's built-in variables include the field variables: $1, $2, $3, and so on ($0 represents the entire record).
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help to parse iostat command output

Hi, I got the code below is one of the threads from this forum. lineCount=$(iostat | wc -l) numDevices=$(expr $lineCount - 7); iostat $interval -x -t | awk -v awkCpuFile=$cpuFile -v awkDeviceFile=$deviceFile -v awkNumDevices=$numDevices ' BEGIN { print... (2 Replies)
Discussion started by: gopivallabha
2 Replies

2. Shell Programming and Scripting

Need help to get the parsed output of "iostat" command

Hi, I have a requirement where parsed output from various linux commands like top, netstat, iostat, etc. will be the input for one javascript with the parsed output from these commands converted to JSON format For "iostat" command, since there are two outputs - one w.r.t CPU utilization and... (2 Replies)
Discussion started by: gopivallabha
2 Replies

3. Solaris

Asvc_t values in iostat output

Noticed that asvc_t values in iostat command outputs are mostly more than 100 in our previous iostat analysis. Also found the following detail from an alternate site IO Bottleneck - Disk performance issue - UnixArena ---- 1. asvc_t average service time of active transactions, in... (2 Replies)
Discussion started by: saraperu
2 Replies

4. Solaris

Unmatched ssd create huge unuseful iostat output

My scheduled collection of statistics is giving very large output because of an high number of ssd device not associated to any disk The iostat -x command is collecting statistics from them and the output is very large. I.g. if a run iostat -x|tail +3|awk '{print $1}'>f0.txt.$$ iostat... (5 Replies)
Discussion started by: sun-mik
5 Replies

5. UNIX for Dummies Questions & Answers

Formatting df output

Hi all, Can anyone please suggest how best to handle output from running df where some of the information for a volume/filesystem spread over two lines? Some of my volume/filesytem are NFS mounted and when I run a df, the information is spread over the two lines instead of the usual norm... (4 Replies)
Discussion started by: newbie_01
4 Replies

6. Filesystems, Disks and Memory

iostat output vs TPC output (array layer)

Hi Guys, I've been having some arguments with my colleagues about one thing. Always my thought was that as as far as disk performance is concern by looking at the output of the iostat command (AIX) you would be able to identify if you have a hot disk and then by moving some files out that disk... (3 Replies)
Discussion started by: arizah
3 Replies

7. Shell Programming and Scripting

finding greatest value in a column using awk from iostat output in linux

Friends, Need some help. On linux i have to run iostat command and in each iteration have to print the greatest value in each column. e.g iostat -dt -kx 2 2 | awk ' !/sd/ &&!/%util/ && !/Time/ && !/Linux/ {print $12}' 4.38 0.00 0.00 0.00 WHhat i would like to... (15 Replies)
Discussion started by: achak01
15 Replies

8. Shell Programming and Scripting

finding greatest value in a column using awk from iostat output in linux

Friends, . On linux i have to run iostat command and in each iteration have to print the greatest value in each column. e.g iostat -dt -kx 2 2 | awk ' !/sd/ &&!/%util/ && !/Time/ && !/Linux/ {print $12}' 4.38 0.00 0.00 0.00 What i would like to print is only the... (3 Replies)
Discussion started by: achak01
3 Replies

9. UNIX for Advanced & Expert Users

iostat output what is that mean

Hi all, i have run iostat -em, and get below result. Can i know what is this output meaning, and how to fix that problem. iostat -em ---- errors --- device s/w h/w trn tot sd7 0 1 0 1 sd8 1 1 0 2 sd9 0 1 0 1 sd10 0 ... (2 Replies)
Discussion started by: foongkt5220
2 Replies

10. Solaris

iostat -e / -E output explanation

Hi all, hope you are having a nice day, its nice and warm today in Canberra Australia. iostat -e / -E reports soft and hard errors. Any idea what these are exactly? All I hear are I/O's failing and needing to retry, but no cause as to why they fail. My SUN guru tells me its our EMC SAN... (1 Reply)
Discussion started by: scottman
1 Replies

Featured Tech Videos