Re: large tables, large keycaches
I doubt that the first advice is good. Setting key_cache_size to zero means to flush *and drop* the whole key cache (except of the default key chache). Setting the size to non-zero creates it anew. But all cached pages are lost. A flush fllushes the key pages but can leave them in the cache for later use (I'm not sure if this happens currently, but it is possible to do it. If someone could test it, it would be nice. If you insist, I could explore this myself.).
Subject
Views
Written By
Posted
9578
July 25, 2005 09:12PM
4366
July 26, 2005 04:04AM
3239
July 26, 2005 08:43AM
3190
July 26, 2005 10:37AM
3796
July 26, 2005 11:49AM
3597
July 26, 2005 02:27PM
2864
July 26, 2005 04:36PM
Re: large tables, large keycaches
2666
July 27, 2005 03:03AM
3394
July 27, 2005 02:53AM
3295
July 27, 2005 10:49AM
3395
July 27, 2005 03:52PM
2528
July 28, 2005 02:36AM
2698
July 28, 2005 06:38PM
2581
August 02, 2005 08:04PM
2726
July 26, 2005 10:51AM
3512
July 27, 2005 03:15AM
2530
July 27, 2005 07:48AM
3406
July 28, 2005 03:12AM
3174
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.