Results 1 to 4 of 4

Thread: Mincommit

  1. #1
    Join Date
    Oct 2006
    Posts
    15

    Unanswered: Mincommit

    UDB V8.2 FP7 OS . AIX 5.0

    All-

    I am trying to improve the peformance of my system. I might need you help as i am not good in tuning.

    1) I am seeing about 1650 transactions persecond. Do i need to increase the
    value of Mincommit to some value . Currently it had the default values.

    2) And i am seeing almost equal values for

    Buffer pool data writes = 9075
    Asynchronous pool data page writes = 8983

    and Buffer pool index writes = 28892
    Asynchronous pool index page writes = 28118

    Is this a problem. As far as i know , both these values should not be same.

    thanks
    sunINDia.

  2. #2
    Join Date
    Oct 2006
    Posts
    15
    NO one has answers for it ?

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I'm sure Administration Guide: Performance has all the answers you need.

    In particular, increasing MINCOMMIT may be warranted in you case, if log write time is significant. You may need to increase log buffer as well.

    As for asynchronous write operations, I'd say the more the better.

  4. #4
    Join Date
    Nov 2003
    Posts
    121

    how did u find your total transaction

    Can u tell me how did u find total transaction (1650) in your database per min or per sec ?
    Greatly appreciate it.
    TIA.

Posting Permissions

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