MySQL Forums
Forum List  »  InnoDB

tablespace size on windows platform
Posted by: Michael Weisman
Date: January 24, 2005 11:04AM

After truncating a very large table in an innodb tablespace, is the innodb file size dynamically reduced?

I am being told that in order to perform "maintenance on a database hosted off-site" that the db is being dumped, the database deleted and re-created, in order to defragment the database and recover disk space.

Is all that really necessary?

Any thought are GREATLY appreciated.

Michael.

Options: ReplyQuote


Subject
Views
Written By
Posted
tablespace size on windows platform
4003
January 24, 2005 11:04AM
2374
January 26, 2005 07:56AM


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.