* Keith C. Ivey
[...]
> Jonas said the tables had 25 floats in each record, so the added
> integer ID and deletion flag would only occur 1/25 as often. There
You are probably right. I focused on the "1 value/minute are stored" part,
and wondered why he would store a float for each field in a data
On 30 Jan 2003, at 15:41, Roger Baklund wrote:
> However, you would normally need to store something more than just the
> float value, otherwise it would be difficult to use the data for
> anything... assuming you also need an integer pointer for each value,
> you would need 4 extra bytes per row,
Please don't hijack threads.
In the last episode (Jan 30), Jonas Ask?s said:
> 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
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.
--
> 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.
see chapter 6.2.6 of the mysql manu
>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
* Jonas Askås
> 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.
mysql does not compres
