I am new to databases and mysql in particular. I need to provide the specifications for database size for a new design...
Lets assume one of my tables has the following structure column1 int column2 int column3 varchar(200) column4 char(1) column5 int column6 text column7 datetime column8 datetime which gives an approximate value of 630 bytes for a row in this table and given that I can have 48000 such rows in this table taking the table size to 30MB. Note that I have not taken into account the indexes and foreign keys... How much space do these take? I have 6 such innodb tables more or less the same size. How can I reach to a number for database size and hence disk space? Thanks