List:General Discussion« Previous MessageNext Message »
From:David Bordas Date:January 30 2003 2:46pm
Subject:Re: Storage issue
View as plain text  
>Here's an example of how much data could be stored in a year:

>1 value/minute are stored = 1440 values/day.
>365 days / year.

>We have 100 different tables with 25 columns each.
>This makes 100*25*365*1440 = 1 314 000 000 values per year.

>A typical value could be 25,5624.

>How much space (in Mb) could this take up after a year do you think?

You'll find something here :
http://www.mysql.com/doc/en/Storage_requirements.html

Typically a float is stored on 4 Bytes ( a Byte is 8 bits ).
Thread
query cacheext) Reiner29 Jan
  • Re: query cacheDan Nelson30 Jan
    • Storage issueJonas Ask√•s30 Jan
      • Re: Storage issueDavid Bordas30 Jan
      • RE: Storage issueJohnny Withers30 Jan
      • Re: Storage issueDan Nelson30 Jan