Only floats, using coarse precision, 30 values recorded every 15 seconds: 30 values per write * 86400 seconds per day * 1/15 writes per second * 3 bytes per value = ~520000, or about half a megabyte per day, once fully compacted.
On Wed, Oct 19, 2016 at 5:50 AM, Guillaume Berthomé < [email protected]> wrote: > In fact, it's not really possible to predict this size if I well > understand? > > In my case, I have an interval of 15s, a precision in seconds and the > values are only floats. > > > Le mercredi 19 octobre 2016 13:45:33 UTC+2, Mathias Herberts a écrit : >> >> Efficiency of compression depends on different factors, including >> interval between timestamps, resolution of said timestamps, volatility and >> type of values. >> >> The 2 or 3 bytes footprint is usually not achievable if you store your >> timestamps with milli, micro or nanosecond precision as the delta between >> consecutive timestamps will vary and will therefore not compress as well. >> >> >> On Wednesday, October 19, 2016 at 1:04:44 PM UTC+2, Guillaume Berthomé >> wrote: >>> >>> Thank you for your answer. >>> >>> So let's admit that I have 2 metrics collected every 15 seconds during >>> 24h >>> >>> - cpu with 20 values >>> - mem with 10 values >>> >>> The total size of stored data will be 3 bytes * 8 metrics per minutes * >>> 1440 minutes ? >>> >>> >>> >>> Le mardi 18 octobre 2016 18:57:53 UTC+2, Sean Beckett a écrit : >>>> >>>> After final compactions, InfluxDB uses between 2 and 3 bytes per field >>>> value stored. If your metrics are all numbers, then the total steady-state >>>> size will be a bit more than 3 bytes * (metrics per minute) * minutes of >>>> data stored. >>>> >>>> See http://docs.influxdata.com/influxdb/v1.0/concepts/storage_engine/ >>>> and http://docs.influxdata.com/influxdb/v1.0/guides/hardware_siz >>>> ing/#how-much-storage-do-i-need for details. >>>> >>>> On Tue, Oct 18, 2016 at 2:51 AM, <[email protected]> wrote: >>>> >>>>> Hi everybody, >>>>> >>>>> Is there any way to calculate the database's size from the number >>>>> measurements done per minute ? I mean predict the databse behavior (wal >>>>> files, tsm files ...) >>>>> >>>>> Thank you. >>>>> >>>>> -- >>>>> Remember to include the version number! >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "InfluxData" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to [email protected]. >>>>> To post to this group, send email to [email protected]. >>>>> Visit this group at https://groups.google.com/group/influxdb. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/influxdb/ee32b8d0-f9bf-40d >>>>> f-baf1-e77fa93cddf5%40googlegroups.com. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> >>>> >>>> -- >>>> Sean Beckett >>>> Director of Support and Professional Services >>>> InfluxDB >>>> >>> -- > Remember to include the version number! > --- > You received this message because you are subscribed to the Google Groups > "InfluxData" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/716ce75f-5830-42b4-83f2-3dcc3999ed2e%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/716ce75f-5830-42b4-83f2-3dcc3999ed2e%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvME0RVyaagecsLDbB73a_kw7gapFL7npZeAykBX9kT9nw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
