Re: large tables, large keycaches
You can try to set key_cache_block_size to 4k. But see also reference manual 7.4.6.5. Key Cache Block Size. The problem is that there is currently no way to influence the index block size. This is only computed from the key size.
I have an internal task on my plate to make the index block size configurable for every index. But other things have higher priority currently.
I'm not sure but I fear that a FLUSH TABLE will stop all writing threads until the flush is complete. That way you won't get any parallelism.
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
2609
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
Re: large tables, large keycaches
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.