Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    71

    Unanswered: need opinion on two sets of onstat -p output

    Hi forum. I have pasted a before and after copy of "onstat -p" and I
    am hoping to get your take on what you think seems to have gotten
    better/worse based on just that info. I made some changes to my
    buffers, cleaners, lrus and check point intervals - largely based on
    input from you folks!

    It is not a mistake for you to assume I have very little Informix dba
    type experience. But I am trying to read my way to it as well as I
    can!

    ___| BEFORE |_________________________________________________ _______
    IBM Informix Dynamic Server Version 9.40.FC2 -- On-Line -- Up 17 days
    07:04:06 -- 1706560 Kbytes

    Profile
    dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
    900881808 1877905516 32921980794 97.26 65487771 101306873 1371660039
    95.23

    isamtot open start read write rewrite delete commit
    rollbk
    26826182414 777860503 1129038992 18919136928 513690577 76895220
    21650089 110788
    136

    gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
    0 0 0 0 0 0 0

    ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
    0 0 0 1365099.75 263254.84 1279 3547

    bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress
    seqscans
    51043463 12 15084951321 0 0 4442 11836393
    22801537

    ixda-RA idx-RA da-RA RA-pgsused lchwaits
    93004239 26278520 637128593 753040097 38850158


    ___| AFTER |_________________________________________________ __________
    IBM Informix Dynamic Server Version 9.40.FC2 -- On-Line -- Up 17
    days 02:05:52 -- 3387376 Kbytes

    Profile
    dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
    450404183 1066467881 26798253905 98.32 68805670 117683468 998172729
    93.11

    isamtot open start read write rewrite delete commit
    rollbk
    21845481388 505190720 1169318304 14887625300 240575222 101593739
    50604236 96415
    14

    gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
    0 0 0 0 0 0 0

    ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
    0 0 0 905473.40 160867.72 4488 13024

    bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress
    seqscans
    28954227 6 16212210789 0 0 18081 6319320
    4991755

    ixda-RA idx-RA da-RA RA-pgsused lchwaits
    42829593 17202291 297607117 356203620 5794405
    __________________________________________________ _______________
    I have seen some signifigant performance boosts on some of the OLTP
    type work we do in the evening. I also have noticed longer checkpoints
    (even though I lowered the interval and raised cleaners and lrus
    aggresively) but the users have not really noticed or complained.

    Thanks for helping.

  2. #2
    Join Date
    Nov 2003
    Location
    Mumbai, India
    Posts
    92
    Please refer the link below for an answer:

    http://www.tek-tips.com/gviewthread....179/qid/845259

Posting Permissions

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