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
