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
9621
July 25, 2005 09:12PM
4507
July 26, 2005 04:04AM
3246
July 26, 2005 08:43AM
3200
July 26, 2005 10:37AM
3938
July 26, 2005 11:49AM
3778
July 26, 2005 02:27PM
2873
July 26, 2005 04:36PM
2688
July 27, 2005 03:03AM
3522
July 27, 2005 02:53AM
3439
July 27, 2005 10:49AM
3545
July 27, 2005 03:52PM
2542
July 28, 2005 02:36AM
2733
July 28, 2005 06:38PM
2593
August 02, 2005 08:04PM
2747
July 26, 2005 10:51AM
Re: large tables, large keycaches
3669
July 27, 2005 03:15AM
2547
July 27, 2005 07:48AM
3578
July 28, 2005 03:12AM
3280
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.