List:General Discussion« Previous MessageNext Message »
From:Dan Buettner Date:June 21 2006 7:51pm
Subject:Re: reclaim disk space
View as plain text  
Luiz, if you are working with MyISAM tables, the table files should be 
deleted when you DROP the table.  If not, you might have an OS 
permissions issue.

If you are working with InnoDB tables in one tablespace, you cannot 
currently easily reclaim the space.  See
http://bugs.mysql.com/bug.php?id=1287

One way to work around the InnoDB behavior is to enable the 
file-per-table option when you do initial set up; it's discussed in the 
link above.

Dan


luiz Rafael wrote:
> Dear Friends
> 
> how to reclain the disk space used by an table that was dropped?
> 
> Regards
> Luiz
> 

-- 
Dan Buettner
Thread
Just need script for creating tablesXiaobo Chen21 Jun
  • Re: Just need script for creating tablesDaniel da Veiga21 Jun
  • RE: Just need script for creating tablesPeter Lauri21 Jun
    • query slowluiz Rafael21 Jun
      • Re: query slowJay Pipes21 Jun
        • Re: query slowEugene Kosov21 Jun
      • Re: query slowEugene Kosov21 Jun
    • Re: query slowluiz Rafael21 Jun
    • reclaim disk spaceluiz Rafael21 Jun
      • Re: reclaim disk spaceDan Buettner21 Jun
      • Re: reclaim disk spaceDan Nelson21 Jun
    • Re: query slowluiz Rafael25 Jun
  • Re: Just need script for creating tablesMartin Jespersen21 Jun
RE: reclaim disk spaceGeorge Law21 Jun