Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.


Archive: Informix long checkpoints

Bottom of Page

1 to 3 of 3

  1.  
    • CommentAuthorpeyton
    • CommentTimeNov 3rd 2006
     
    Good day,

    We have problem with full checkpoints on Informix DB.
    Sometimes checkpoints are more then 6 sec,somtetimes 50 sec.

    Please help me to resolve problem.
    Please see in attach. oconfig file and output from onstat -F command, and also interesting.
    • CommentAuthorgregory
    • CommentTimeNov 3rd 2006
     
    I'm guessing at some things since the information wasn't provided, but here's some observations:

    You have 128 LRU's (good) but 128 CLEANERS (bad, since you only have 4 CPUVPS threads defined. I'm assuming 4 physical CPU's, so those cleaners are all fighting.

    It looks like the majority of the "writes" occur on dbspace rtlogidxa. Cleaning that will be your bottleneck.

    You are not running Fuzzy checkpoints - why not?

    You have allowed AIO to take the default of 2*#chunks, yet you don't use AIO, so you have idle AIO threads just messing things up.

    Physically, where does your physical and logical logs sit relative to rtlogidxa and rtlogdatac.
    • CommentAuthorjohnathan
    • CommentTimeNov 3rd 2006
     
    Thanks for the answer, the system has 2XDual Core CPU not 4 physical.

    Fuzzy checpoints is not good for this application, it is specific.

    Maybe somethink also I can modified in the system or onconfig file?

1 to 3 of 3

  1.