MySQL Forums
Forum List  »  Partitioning

MySQL DB Size increase after partitioning
Posted by: Ronald Higgins
Date: July 25, 2010 11:37AM

Hi Fellow MySQL Forumites,

I had a 215GB InnoDB database that i partioned.
Once I had partitioned various tables the ibdata file has grown
to 375GB . I understand when you perform the Alter table to perform the partitioning a temp table is created so i expected some temporary growth, but
i'm a bit perplexed as to why the DB has nearly doubled in size?

Any pointers ?



Options: ReplyQuote

Written By
MySQL DB Size increase after partitioning
July 25, 2010 11:37AM

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.