RE: reclaim disk space

2006-06-21 Thread George Law
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

Re: reclaim disk space

2006-06-21 Thread 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 unse

Re: reclaim disk space

2006-06-21 Thread Dan Buettner
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

reclaim disk space

2006-06-21 Thread luiz Rafael
Dear Friends how to reclain the disk space used by an table that was dropped? Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]