Click to See Complete Forum and Search --> : Estimating the size of a mysql database


cs3mw
10-08-2008, 10:28 AM
Hi I have created a mysql database and been asked to estimate the size of the database. Now obniously this will depend on how many results are in the database but could anyone suggest how I could go about giving the client a rough idea?

chazzy
10-08-2008, 07:12 PM
calculating the rowsize is pretty easy (just add the byte size from each column). you know approximately how many rows will be added at a time, right?