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
9111
July 25, 2005 09:12PM
Re: large tables, large keycaches
3535
July 26, 2005 04:04AM
3174
July 26, 2005 08:43AM
3112
July 26, 2005 10:37AM
2949
July 26, 2005 11:49AM
2683
July 26, 2005 02:27PM
2775
July 26, 2005 04:36PM
2565
July 27, 2005 03:03AM
2552
July 27, 2005 02:53AM
2454
July 27, 2005 10:49AM
2481
July 27, 2005 03:52PM
2412
July 28, 2005 02:36AM
2417
July 28, 2005 06:38PM
2502
August 02, 2005 08:04PM
2569
July 26, 2005 10:51AM
2554
July 27, 2005 03:15AM
2419
July 27, 2005 07:48AM
2403
July 28, 2005 03:12AM
2505
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.