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
9250
July 25, 2005 09:12PM
3710
July 26, 2005 04:04AM
3208
July 26, 2005 08:43AM
3151
July 26, 2005 10:37AM
3158
July 26, 2005 11:49AM
2881
July 26, 2005 02:27PM
2820
July 26, 2005 04:36PM
Re: large tables, large keycaches
2630
July 27, 2005 03:03AM
2729
July 27, 2005 02:53AM
2650
July 27, 2005 10:49AM
2664
July 27, 2005 03:52PM
2482
July 28, 2005 02:36AM
2520
July 28, 2005 06:38PM
2536
August 02, 2005 08:04PM
2651
July 26, 2005 10:51AM
2763
July 27, 2005 03:15AM
2482
July 27, 2005 07:48AM
2644
July 28, 2005 03:12AM
2683
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.