MySQL Forums
Forum List  »  MyISAM

Re: convert myisam to innodb - table status
Posted by: Greg K.
Date: January 10, 2013 01:24AM

hi
just to complete the picture...
I converted 220GB table from MyISAM getting 173GB of InnoDB table.
Another time, 5GB MyISAM table become 12GB InnoDB table.
Strange, no rule. Beware! ;-)

p.s. I was wondering about it and think that perhaps it's the result of dealing with puffed up table where many deletes were done. It seems like convertion did defragmentation at the same time. Can it be?



Edited 1 time(s). Last edit at 01/11/2013 12:41AM by Greg K..

Options: ReplyQuote


Subject
Views
Written By
Posted
3020
December 03, 2012 06:09AM
Re: convert myisam to innodb - table status
1582
January 10, 2013 01:24AM


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.