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
9576
July 25, 2005 09:12PM
Re: large tables, large keycaches
4361
July 26, 2005 04:04AM
3239
July 26, 2005 08:43AM
3190
July 26, 2005 10:37AM
3787
July 26, 2005 11:49AM
3589
July 26, 2005 02:27PM
2864
July 26, 2005 04:36PM
2666
July 27, 2005 03:03AM
3383
July 27, 2005 02:53AM
3285
July 27, 2005 10:49AM
3383
July 27, 2005 03:52PM
2528
July 28, 2005 02:36AM
2696
July 28, 2005 06:38PM
2581
August 02, 2005 08:04PM
2726
July 26, 2005 10:51AM
3501
July 27, 2005 03:15AM
2530
July 27, 2005 07:48AM
3390
July 28, 2005 03:12AM
3168
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.