List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:June 21 2006 7:57pm
Subject:Re: reclaim disk space
View as plain text  
In the last episode (Jun 21), luiz Rafael said:
> how to reclain the disk space used by an table that was dropped?

For most storage engines, each table is in its own file so a dropped
table immediately returns space back to the OS.  For InnoDB in
tablespace mode (i.e. innodb_file_per_table is unset), you will have to
back up and drop all your InnoDB tables, delete the tablespace files,
and reload the tables.

http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html
http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html

-- 
	Dan Nelson
	dnelson@stripped
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