There's a lot of mention about the ephemeral nature of time series data, but how is InfluxDB for storing permanent time series data? Are there any performance limitations I should be thinking about (aside from the limits of the hardware itself)?
There's a lot of mention about the ephemeral nature of time series data, but how is InfluxDB for storing permanent time series data? Are there any performance limitations I should be thinking about (aside from the limits of the hardware itself)?
The ephemeral nature of time series is more about the fact that metadata and the raw data are constantly changing. For example if you use a round robin database (like Graphite or RRD) you have to pre-allocate the file based on how much of the series data you're going to have (e.g. 10s samples for 3 months).
Having series that are ephemeral and may exist for an hour or a day make this much harder to deal with. Our storage engine, the Time Structured Merge Tree, is designed with this ephemeral nature in mind. So it's able to store this data efficiently.
The 0.9.6 release that came out today has that storage engine in it for testing. We'll release it for production use at the end of January after more testing.
https://influxdb.com/blog/2015/10/07/the_new_influxdb_storag...
We use them for storing "permanent" data. They slice up the data into weekly files, so if you don't access it often, it's no biggie to store a lot of data. If you constantly access data across time, you may run into performance degradation from a caching point of view (having to pull in the files from past, blowing caches of new stuff constantly).