MySQL Forums
Forum List  »  InnoDB

Huge row size compared to MyIsam
Posted by: Grungean G
Date: September 25, 2010 05:24AM

I have a table with for columns, a smallint, an integer and two floats. Expected memory for each row is 14bytes (2+4+2*4).
I have around 700,000 rows in my table. I've set no primary keys and indices.
While the MyIsam type takes around 10MB (average of 15b for each row), the InnoDB type takes more than 30Mb (average of 44b).
What am I missing here? Would InnoDB have so much of overhead for each row, or are the table status number not to be trusted.
I need to store data which will run into GBs, so need to decide on the storage type by weighing different parameters.

Options: ReplyQuote


Subject
Views
Written By
Posted
Huge row size compared to MyIsam
2467
September 25, 2010 05:24AM
1030
September 26, 2010 10:03AM
1740
September 28, 2010 03:02AM
902
September 28, 2010 09:48AM


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.