Re: convert myisam to innodb - table status
Posted by:
Rick James
Date: January 13, 2013 12:00AM
There are many reasons why the two engines are different.
Yes, defrag could have been a side effect causing the shrinkage.
The effect of DELETEs is different between the engines -- each recovers some of the space, but in different ways.
InnoDB is _often_ 2x-3x bigger than MyISAM, mostly because of the how the data is laid out.
Then there is space/overhead for transactions.
Indexes are rather different. A wide PRIMARY KEY takes a lot of space in MyISAM, but almost none in InnoDB since it is 'clustered' with the data.
Secondary keys may be fatter in InnoDB because they contain the PK instead of a 6-byte pointer to the data.
CHAR, TEXT, and BLOB are handled rather differently, leading to more or less space consumed.
Etc.
Subject
Views
Written By
Posted
3276
December 03, 2012 06:09AM
1839
December 05, 2012 12:26AM
1730
January 10, 2013 01:24AM
Re: convert myisam to innodb - table status
2055
January 13, 2013 12:00AM
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.