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
9160
July 25, 2005 09:12PM
3549
July 26, 2005 04:04AM
3183
July 26, 2005 08:43AM
3126
July 26, 2005 10:37AM
2988
July 26, 2005 11:49AM
2716
July 26, 2005 02:27PM
2790
July 26, 2005 04:36PM
Re: large tables, large keycaches
2602
July 27, 2005 03:03AM
2562
July 27, 2005 02:53AM
2471
July 27, 2005 10:49AM
2492
July 27, 2005 03:52PM
2448
July 28, 2005 02:36AM
2453
July 28, 2005 06:38PM
2513
August 02, 2005 08:04PM
2608
July 26, 2005 10:51AM
2566
July 27, 2005 03:15AM
2455
July 27, 2005 07:48AM
2438
July 28, 2005 03:12AM
2544
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.