MySQL Forums :: InnoDB :: Huge row size compared to MyIsam


Advanced Search

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 1650 Grungean G 09/25/2010 05:24AM
Re: Huge row size compared to MyIsam 756 Rick James 09/26/2010 10:03AM
Re: Huge row size compared to MyIsam 1320 Grungean G 09/28/2010 03:02AM
Re: Huge row size compared to MyIsam 715 Rick James 09/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.