List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 24 1999 3:13am
Subject:Re: ISD file size
View as plain text  
At 10:06 PM -0500 9/23/99, Cliff Addy wrote:
>On Tue, 21 Sep 1999, Paul DuBois wrote:
>
>> At 6:38 PM -0500 9/21/99, Cliff Addy wrote:
>> >I'm sure this has to be a FAQ, but I've been unable to dig it up.  I have
>> >a rather large database that I've zapped a lot of old data from.  However,
>> >the ISD file remains the same size.
>> >
>> >What do I need to do to have mysql release all that disk space?
>>
>> OPTIMIZE TABLE
>
>My, what a terse answer.  And just where do I use this magical little
>command?  I can't even find it in the docs.

There's not much more to say.  Invoke mysql and issue this command:

mysql> OPTIMIZE TABLE tbl_name;


The command is described in chapter 7 of the MySQL Reference Manual,
in the section for, er, OPTIMIZE TABLE.  Perhaps you have an old
version of the manual.

--
Paul DuBois, paul@stripped
Thread
ISD file sizeCliff Addy22 Sep
Re: ISD file sizePaul DuBois22 Sep
  • Re: ISD file sizeCliff Addy24 Sep
    • Re: ISD file sizePaul DuBois24 Sep
      • Re: ISD file sizeCliff Addy24 Sep
        • Re: ISD file sizeThimble Smith24 Sep
          • Re: ISD file sizeVivek Khera24 Sep
        • Re: ISD file sizeBob Kline24 Sep
    • Re: ISD file sizeMartin Ramsch24 Sep
    • Re: ISD file sizeBob Kline24 Sep