Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
David Williams wrote:
snip
> LRU's too low means the there is contention among the queues and
> Informix runs slower as processes have to wait before the can update
> the queues. There is one mutex per queue which controls give thread
> can update the queue. Remember queues come in pairs and as buffers
> are modified they are removed from the free queue and moved to the
> modified queue. Something has to stop two threads from moving the
> same buffer at the same time.
snip
> Yes lots of other factors affect checkpoint duration. First set
> LRUS=CLEANERS=number of physical disk on the system. Keep
> LRU_MIN_DIRTY and LRU_MAX_DIRTY at 5 and 7.
snip
A fair while ago I came to the conclusion that the number of LRU queues
was loosely based on the number of users on the system. If you have 100
users, contention for the mutexes on the e.g 8 LRUS is lower than with
250 users, thus 250 user systems would require more LRUS.
Davin
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.