Re: large tables, large keycaches
I do not feel comfortable with performance questions. We have a special forum for these. But I will share my thoughts.
For this case we would need a thread which flushes modified cache pages in the background so that eviction can be done very fast. But as far as I know there are no plans to implement it.
What you can try to do: Put the large table in a separate key cache (see reference menual 7.4.6.2. Multiple Key Caches). This would at least prevent the big table from evicting pages from the small tables.
Whenever your key data grow far beyond the key cache size then you will only be able to process as much as the disk can. Eventually. (After the cache is filled.) I cannot think about any way to get around this.
If you try my above suggestion, I would be happy for feedback. That way I might take the first step to get some expertise in performance questions and help others later.
Subject
Views
Written By
Posted
9245
July 25, 2005 09:12PM
Re: large tables, large keycaches
3704
July 26, 2005 04:04AM
3208
July 26, 2005 08:43AM
3149
July 26, 2005 10:37AM
3153
July 26, 2005 11:49AM
2872
July 26, 2005 02:27PM
2819
July 26, 2005 04:36PM
2630
July 27, 2005 03:03AM
2722
July 27, 2005 02:53AM
2636
July 27, 2005 10:49AM
2654
July 27, 2005 03:52PM
2481
July 28, 2005 02:36AM
2518
July 28, 2005 06:38PM
2535
August 02, 2005 08:04PM
2651
July 26, 2005 10:51AM
2749
July 27, 2005 03:15AM
2481
July 27, 2005 07:48AM
2627
July 28, 2005 03:12AM
2674
July 28, 2005 01:08PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.