Re: Huge index file, why?

[Michael Widenius]

>>>>> "V" == V Yau <v_yau@stripped> writes:

V> . >
>> Yes;  In this case all key blocks will be filled to 100% (In normal
>> usage the key blocks will 'only' be filled to about 70 %).
>> 
>> Note that if you only want to pack the indexes, you should run:
>> 
>> isamchk -rq -Si table_name
>> 
>> (The -Si sorts the index block, which should give you a little better
>> access times)
>> 

V> Monty,  does this command equivalent to
mysql> optimize table_name ;

Not yet;  We are working into integrating myisamchk within mysqld and
when this is done optimize table will handle this!

Regards,
Monty