Estimate table size

[Susan Lundstrom]

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.