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
9398
July 25, 2005 09:12PM
Re: large tables, large keycaches
4018
July 26, 2005 04:04AM
3221
July 26, 2005 08:43AM
3170
July 26, 2005 10:37AM
3463
July 26, 2005 11:49AM
3220
July 26, 2005 02:27PM
2843
July 26, 2005 04:36PM
2651
July 27, 2005 03:03AM
3034
July 27, 2005 02:53AM
2942
July 27, 2005 10:49AM
3003
July 27, 2005 03:52PM
2505
July 28, 2005 02:36AM
2581
July 28, 2005 06:38PM
2556
August 02, 2005 08:04PM
2684
July 26, 2005 10:51AM
3110
July 27, 2005 03:15AM
2504
July 27, 2005 07:48AM
2972
July 28, 2005 03:12AM
2914
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.