MySQL Forums :: Newbie :: Estimate table size


Advanced Search

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 rows...how could I calculate the amount of space it will need?

CREATE TABLE `Test` (
`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,
PRIMARY KEY (`Try1`)
) 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


Subject Written By Posted
Estimate table size Susan Lundstrom 09/07/2010 10:57AM
Re: Estimate table size Shawn Taylor 09/07/2010 03:01PM
Re: Estimate table size Rick James 09/07/2010 11:18PM
Re: Estimate table size Shawn Taylor 09/08/2010 07:41AM
Re: Estimate table size Rick James 09/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.