MySQL Forums
Forum List  »  InnoDB

Varchar does it cause data file to continously grow
Posted by: Eric Hernandez
Date: June 30, 2010 10:54AM

Hi I am using the innodb_plugin 1.0.9 (MySQL 5.1.48)

If I use varchar does innodb reclaim space in the innodb data file.
Or can it only do this with char?

My concern is that if I use varchar i will be saving space per row but my ibd file will grow indifinetely until i rebuild table. On the other hand I use char my table will be bigger but i can re-use table space and this might make the overall table smaller.

Thanks

-Eric

Options: ReplyQuote


Subject
Views
Written By
Posted
Varchar does it cause data file to continously grow
2762
June 30, 2010 10:54AM


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.