MySQL Forums
Forum List  »  Newbie

Re: Estimate table size
Posted by: Shawn Taylor
Date: September 08, 2010 07:41AM

Rick,

> With InnoDB, data is stored in units of 16KB.

Is the unit of measure not different for each disk architecture? For instance in my environment the block size on disk is 8k. Does that simply mean for InnoDB that each write will merely take two sequential disk blocks for each logical 16k unit of data in MySQL??

> CHAR(15) should be used only if you expect all the items to be exactly 15 characters long.

Wouldn't it be faster with that row count to try and keep the data fixed length??

Thanks,

Shawn

Options: ReplyQuote


Subject
Written By
Posted
September 07, 2010 10:57AM
September 07, 2010 03:01PM
September 07, 2010 11:18PM
Re: Estimate table size
September 08, 2010 07:41AM
September 08, 2010 09:50AM


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.