Re: Create Index Mysteriously Slow at the End - IDS 11.10.UC2W2-RedHatEL5
"Superboer" <superboer7@t-online.de> wrote in message
news:475f7a43-274a-4512-ab0f-6d872018f293@59g2000hsb.googlegroups.com...
> what happens when you try onmode -B
With LRUs set to 127, Cleaners set to 127, LRU min/max set to 70/80,
RTO_SERVER_RESTART disabled and CKPTINTVL set to 8 hours I execute onmode -B
and continuously execute onmode -B each time I see the cleaner stop writing
to a chunk (state = C).
Doing this I get about the same performance as my previous test of
RTO_SERVER_RESTART 0, aka disabled
CKPTINTVL 28800, 8 hours
LRUs 1
CLEANERS 1
LRU min dirty 0.00000
LRU max dirty 0.00001
The only difference seems to be most of the writes are chunk writes and not
LRU writes, no change in performance.
Still 5 minutes to scan the data pages, 10 minutes to write the index pages
and 20 minutes to read the index pages.
Thanks for the suggestion,
Andrew |