A very first thing you should do is to evaluate the storage needed by a single row. This can be done by summing up all columns data types length in bytes and index lenght as well. This should be quite accurate.
Just a tip to start: http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html 2009/9/30 John Dove <mysqlsee...@live.com> > > > > > > > Hi! > > I need to figure out how much disk space an arbitrary number of rows in a > table take up. For example > > > SELECT DISK_SPACE(*) FROM ORDERS WHERE CREATED_AT BETWEEN x AND y > > > I know i could do something like a mysqldump with conditions and analyze > the output file but i'd like to avoid outputting anything to the filesystem > as it's slow. > > My underlying db type is InnoDB on Server version: 5.0.75-0ubuntu10.2 > > Any help would be much appreciated. > > -John > > _________________________________________________________________ > Hotmail® has ever-growing storage! Don’t worry about storage limits. > > http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage_062009 -- Claudio
