MySQL Forums
Forum List  »  Newbie

Estimate table size
Posted by: Susan Lundstrom
Date: September 07, 2010 10:57AM

What is the best way to calculate a tables' expected size. I want to be sure I have enough space for a table. Suppose it is created as follows and I estimate it would hold 10 million could I calculate the amount of space it will need?

`Try1` char(15) COLLATE latin1_general_cs NOT NULL,
`Try2` char(15) COLLATE latin1_general_cs NOT NULL,
`Try3` int(15) NOT NULL,
`Try4` int(15) NOT NULL,
`Try5` int(15) NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs

Edited 1 time(s). Last edit at 09/07/2010 01:35PM by Susan Lundstrom.

Options: ReplyQuote

Written By
Estimate table size
September 07, 2010 10:57AM
September 07, 2010 03:01PM
September 07, 2010 11:18PM
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.