List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:August 30 1999 10:00am
Subject:Re: Huge index file, why?
View as plain text  
>>>>> "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
Thread
Huge index file, why?Jules Bean26 Aug
  • Huge index file, why?sinisa26 Aug
  • Re: Huge index file, why?Jules Bean26 Aug
    • Re: Huge index file, why?Benjamin Pflugmann26 Aug
      • Re: Huge index file, why?Michael Widenius27 Aug
    • Re: Huge index file, why?Michael Widenius27 Aug
  • Re: Huge index file, why?Jules Bean27 Aug
    • Re: Huge index file, why?Michael Widenius27 Aug
  • Re: Huge index file, why?Scott Hess27 Aug
    • Re: Huge index file, why?Benjamin Pflugmann27 Aug
      • Re: Huge index file, why?Michael Widenius27 Aug
        • Re: Huge index file, why?Benjamin Pflugmann28 Aug
  • Re: Huge index file, why?Jules Bean27 Aug
  • Re: Huge index file, why?Scott Hess27 Aug
    • Re: Huge index file, why?Michael Widenius29 Aug
Re: Huge index file, why?V Yau30 Aug
  • Re: Huge index file, why?Michael Widenius30 Aug