Re: reclaim disk space

[Dan Nelson]

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