I'm using InfluxDB 1.0.2 and Grafana 3.1.1 and have built a Grafana dashboard to visualise InfluxDB stats from the *_internal *database, which is going well, however I am struggling to build a query to display the growth in size (i.e. *diskBytes*) of each database over time.
The required data appears to be obtainable from both the *shard *and *tsm1_filestore *measurements, however in order to calculate the total size of each database, it is required to sum the last(diskBytes) for each path (tsm file), then group by database, which I am completely failing to do. I think it probably requires a nested query, which InfluxDB still doesn't support. :/ So, can anyone recommend a query to do this, or the best alternative way to chart database sizes over time? Would it be worth requesting that *totalDiskBytes *be added as a field to the database measurements (alongside the *numMeasurements *and *numSeries *fields)? This would simplify things a great deal. Thanks, David -- 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/f44f4350-2897-43d1-b692-55522d06db8c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
