mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 21, 2006 3:58 PM
> To: luiz Rafael
> Cc: mysql@lists.mysql.com
> Subject: Re: reclaim disk space
>
> In the last episode (Jun 21), luiz Rafael said:
> > how to reclain the disk space used by an table that was dropped?
>
> For
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 unse
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?i
