MySQL Forums
Forum List  »  MyISAM

Re: myisam_block_size set to 4K corrupts indexes
Posted by: David Lombardi
Date: April 13, 2006 11:43AM

I reported the problem in http://bugs.mysql.com/bug.php?id=19079

By your answer, I understand that I know little (or little is said) on this and other settings.
In particular, my understanding was that myisam_block_size influenced only the allocation in memory of the indexes, instead by your answer it seems also a way to globally control the allocation on disk for indexes.

Provided that, if this is a bug, eventually it will get fixed, it is reasonable to use sizes larger than the OS cluster size (16K, 32K or even much larger such as 256K, 512K)?
Does it provide other benefits (or drawbacks), beside keeping under control disk fragmentation?

Thanks for your help

David

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: myisam_block_size set to 4K corrupts indexes
2726
April 13, 2006 11:43AM


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.