From: Dan Nelson
Date: June 21 2006 7:57pm
Subject: Re: reclaim disk space
List-Archive: http://lists.mysql.com/mysql/199171
Message-Id: <20060621195742.GC9539@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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