Estimate table size
Posted on 2006-06-19
Need some help in submitting a proposal.
Lets assume i have a table ,type InnoDb, with hte following structure
how do i calculate the table size for this table ? The table will have one foreign key and one index. How do i estimate the database size given that there are six such tables and the company estimates that each table will hold minimum 50000 records. What would be the ideal database server configuration,a estimate, for such a scenario, assuming 250-500 concurrent users.