15 messages in com.mysql.lists.perlRe: Calculating the Disk space requir...
FromSent OnAttachments
ed phillips25 Sep 2001 09:51 
Dodger25 Sep 2001 12:43 
ed phillips25 Sep 2001 13:15 
Rajeev Rumale25 Sep 2001 22:58 
Angus Lee25 Sep 2001 23:40 
ed phillips26 Sep 2001 08:31 
Angus Lee26 Sep 2001 09:53 
Angus Lee26 Sep 2001 13:47 
Dodger26 Sep 2001 17:51 
ed phillips26 Sep 2001 18:01 
ed phillips26 Sep 2001 19:02 
Angus Lee26 Sep 2001 19:15 
Rajeev Rumale26 Sep 2001 20:39 
Dodger27 Sep 2001 08:06 
Angus Lee27 Sep 2001 09:51 
Subject:Re: Calculating the Disk space requirements.
From:Dodger (se@aquest.com)
Date:09/27/2001 08:06:12 AM
List:com.mysql.lists.perl

----- Original Message ----- From: "Rajeev Rumale" <raj@myangel.com> To: <msql@lists.mysql.com> Sent: Wednesday, September 26, 2001 11:39 PM Subject: Calculating the Disk space requirements. ...

Currently I am trying to estimate by summing up all the field sizes in each table multiplied by the estimated number of records at any time.

...

Don't forget about indices, room for temporary tables if you use them, space that the table structure itself takes up, and so on. Also, I believe the amount of space taken up depends on the type of table, so different table types will have different space issues.