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]

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

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

RE: reclaim disk space

2006-06-21 Thread George Law
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 most storage engines, each table is in its own