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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
