Help Interpreting IOSTAT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Help Interpreting IOSTAT

  1. #1
    Join Date
    Apr 2000
    Location
    Charlotte, NC, USA
    Posts
    48

    Help Interpreting IOSTAT

    We notice very high i/o times in top and slow performance when going against a particular table, reads or writes. Dug up this command. Does this indicate that there is an issue on these devices? Once processing against this table finishes, i/o times go from 50% to .5%. Any experienced guidance is appreciated. Samples taken during processing. The actv keeps increasing.

    Maintenance Commands iostat(1M)
    Device name of the disk
    r/s reads per second
    w/s writes per second
    Kr/s kilobytes read per second
    Kw/s kilobytes written per second
    wait average number of transactions waiting for service (queue length)
    actv average number of transactions actively being serviced
    (removed from the queue but not yet completed)
    svc_t average service time, in milliseconds
    %w percent of time there are transactions waiting for
    service (queue non-empty)
    %b percent of time the disk is busy (transactions in progress)


    extended device statistics

    r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device

    2.0 0.0 67.4 0.0 0.0 1.4 0.0 692.1 0 100 c2t6d0

    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t6d0s2

    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t6d0s3

    2.0 0.0 67.4 0.0 0.0 1.4 0.0 692.0 0 100 c2t6d0s4





    0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0 100 c2t6d0

    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t6d0s2

    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t6d0s3

    0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0 100 c2t6d0s4

    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t22d0





    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c3t22d0

    1.0 0.0 63.9 0.0 0.0 1.0 0.0 1000.2 0 100 c2t6d0

    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t6d0s2

    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t6d0s3

    1.0 0.0 63.9 0.0 0.0 1.0 0.0 1000.1 0 100 c2t6d0s4

    16.0 0.0 866.5 0.0 0.0 0.1 0.0 5.1 0 8 c2t21d0


    2.0 0.0 127.1 0.0 0.0 1.5 0.0 758.0 0 100 c2t6d0

    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t6d0s2

    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t6d0s3

    2.0 0.0 127.1 0.0 0.0 1.5 0.0 758.1 0 100 c2t6d0s4



    2.0 0.0 127.1 0.0 0.0 1.0 0.0 502.0 0 100 c2t6d0

    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t6d0s2

    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t6d0s3

    2.0 0.0 127.1 0.0 0.0 1.0 0.0 502.0 0 100 c2t6d0s4



    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t8d0s3
    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t8d0s4
    1.0 0.0 63.4 0.0 0.0 1.0 0.0 1007.2 0 100 c2t6d0
    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t6d0s2
    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t6d0s3
    1.0 0.0 63.4 0.0 0.0 1.0 0.0 1007.2 0 100 c2t6d0s4
    0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c2t22d0

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    There's a couple of things to look at with iostat. First, to get a good indication of how busy a device is, look at the %b number. If this is 100% for one device, but 0% for other devices, look at spreading your data out on multiple devices. If your swap device is 100% busy, I would look to make sure your system is not swapping.

    The second thing to look at is svc_t. If you have high service times with high %b and a low number of I/O's, you might have a disk going bad.

    Lastly, I look at r/s and w/s to make sure they look like they are doing the right amount of work. A 5400RPM drive does about 100 I/Os per second, a 7200RPM drive does around 140, and a 10KRPM does around 180-200. Of course, striped devices do more.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    and don't forget to stand in front of the disks and watch the lights flash! (I'm serious!) It's quick, easy and cheap.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  4. #4
    Join Date
    Dec 2002
    Location
    Munich, Germany
    Posts
    20
    2 acur8dba

    Regardless of your iostat statistics. Did you analyze your database layer? I mean execution plan of slow queries, database wait events and so on?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width