MySQL Forums
Forum List  »  Quality Assurance

Re: DB Size Doesn't Decrease After Dropping Tables
Posted by: Thomas CORBIERE
Date: October 11, 2007 05:57AM

Hello,

The InnoDB tablespace can only grow.
Your only solution to reclaim disk space is to dump the database,
delete InnoDB tablespace and logfiles, recreate them, and reload your
database.

Before reloading the data, you can add the innodb_file_per_table to your
my.cnf so that InnoDB use a separate file for each table instead of the global
tablespace. So you can drop a table and reclaim the disk space.

Regards,

Thomas CORBIERE

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: DB Size Doesn't Decrease After Dropping Tables
3172
October 11, 2007 05:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.