For data, please see page 6 of https://www.influxdata.com/wp-content/uploads/2016/05/InfluxDB-vs-MongoDB-Sept82016.pdf, page 7 of https://www.influxdata.com/wp-content/uploads/2016/05/InfluxDB-vs-Cassandra-Sept82016.pdf, and pages 6 and 7 of https://www.influxdata.com/wp-content/uploads/2016/05/InfluxDB-vs-Elastic-Sept82016.pdf .
Please note that in those tests the data shows less than 2 bytes per numeric value stored in InfluxDB, so the 3 bytes per value I quoted is a pessimistic number. On Wed, Oct 19, 2016 at 12:33 PM, Sean Beckett <s...@influxdb.com> wrote: > Mathias, I question your findings on this. We've run extensive testing > with nanosecond timestamps and routinely get < 3 bytes per recorded numeric > value. > > Please note that this figure is only for fully compacted data, e.g. cold > shards. Shards currently hot for writes will be much less compact. Over > time the steady state of the system will approach ~2.5 bytes per numeric > field. > > On Wed, Oct 19, 2016 at 5:45 AM, Mathias Herberts < > mathias.herbe...@gmail.com> wrote: > >> 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, <guillau...@gmail.com> 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 influxdb+u...@googlegroups.com. >>>>> To post to this group, send email to infl...@googlegroups.com. >>>>> 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 influxdb+unsubscr...@googlegroups.com. >> To post to this group, send email to influxdb@googlegroups.com. >> Visit this group at https://groups.google.com/group/influxdb. >> To view this discussion on the web visit https://groups.google.com/d/ms >> gid/influxdb/b08ad8c0-341e-4390-a18c-8d6b67da26f0%40googlegroups.com >> <https://groups.google.com/d/msgid/influxdb/b08ad8c0-341e-4390-a18c-8d6b67da26f0%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 > -- 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 influxdb+unsubscr...@googlegroups.com. To post to this group, send email to influxdb@googlegroups.com. 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/CALGqCvNdnvQZ9MU8mUonwGVyVxDQqMBPDSzQMzqqOHmT_HpdMg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
