List:General Discussion« Previous MessageNext Message »
From:Homam S.A. Date:January 5 2005 5:52pm
Subject:Index fill factor
View as plain text  
What's the default fill factor on MyISAM B-Tree
indexes? I know it's 15/16 by default for InnoDB, but
nothing is mentioned about MyISAM.

For example, if I'm going to create read-only tables
and index them, I'd like the fill factor to be 100%
since there won't be updates and therefore I'm not
worried about page splits.

Is there a way to control it, the same way MS SQL
Server allows you to specify the fillfactor for
indexes and primary keys?

Thanks!

Homam



		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250
Thread
Index fill factorHomam S.A.5 Jan