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
9174
July 25, 2005 09:12PM
3551
July 26, 2005 04:04AM
3186
July 26, 2005 08:43AM
3128
July 26, 2005 10:37AM
2994
July 26, 2005 11:49AM
2721
July 26, 2005 02:27PM
2796
July 26, 2005 04:36PM
Re: large tables, large keycaches
2608
July 27, 2005 03:03AM
2565
July 27, 2005 02:53AM
2474
July 27, 2005 10:49AM
2495
July 27, 2005 03:52PM
2454
July 28, 2005 02:36AM
2459
July 28, 2005 06:38PM
2516
August 02, 2005 08:04PM
2614
July 26, 2005 10:51AM
2569
July 27, 2005 03:15AM
2461
July 27, 2005 07:48AM
2444
July 28, 2005 03:12AM
2549
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.