Hi, I have a question about schema design. Data is interface statistics. There are about 12 counters per interface and some thousand interfaces. Polling interval 10s...60s. Polling data via SNMP using Telegraf leads to many series with only one field each. Would it be more efficient if I had one series (with a certain set of tags (device, ifName)) with all fields of a certain timestamp? More efficient := smaller memory footprint, less storage, faster queries
I'm currently merging fields using a tree of joins in Kapacitor, but I think this approach is probably the least efficient possible. I imagine, polling data with some custom code, calculating derivatives and then pushing data interface by interface to the DB might be the most efficient. Regards, Claudius -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" 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/447c7a4c-0b40-4494-be1d-dae7fe901926%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
