MySQL Forums :: Newbie :: Estimating disk space required for MySQL DB


Advanced Search

Estimating disk space required for MySQL DB
Posted by: ganesh b ()
Date: June 13, 2009 08:15AM

Let us assume i have a MySQL database with Two table

Table 1 has 5 fields,first Num-Primarry Key rest 4 are Varchar(20) this table has 1 million records.

Table 2 has 10 fields, 1 Num-Primary Key, 2 Num(forain key from table 1), rest 8 are varchar(20). This table also has 1 million records.

How do i estimate size of desk space required for this database.

Actually, i need to understand 'How to estimate DB size given schema/table details'

Thanks in Advance

Options: ReplyQuote


Subject Written By Posted
Estimating disk space required for MySQL DB ganesh b 06/13/2009 08:15AM
Re: Estimating disk space required for MySQL DB Rick James 06/14/2009 01:19PM


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.