List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:January 30 2003 4:27pm
Subject:RE: Storage issue
View as plain text  
These two links should help you.

http://www.mysql.com/doc/en/Column_types.html
http://www.mysql.com/doc/en/Storage_requirements.html


I believe you would be using a 4byte field. So..

(1 314 000 000) * (4) = 5 256 000 000 bytes

or, 5.256Tb

(assuming my calculations are not in error)

Huge.

---------------------
Johnny Withers
johnny@stripped
p. 601.932.0211
c. 601.209.4985 

-----Original Message-----
From: Jonas Askås [mailto:jonas@stripped] 
Sent: Thursday, January 30, 2003 2:52 AM
To: mysql@stripped
Subject: Storage issue


Hi,

I'm wondering how well MySQL compress data. I'm about to design a
database which will hold mainly _a lot_ of FLOAT-values, and since I do
not really know how well MySQL compress data or how I could calculate
this I'd really appriciate a little guidance.

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?


Best regards,
Jonas Askås



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread131209@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-johnny=mindbender.net@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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