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