If you are using InfluxDB 0.8 dont use FIRST() or LAST() if you have not GROUP BY because its very slow 🙁 So if you want to get the these Values you shoud use: First Value: SELECT * FROM <SERIES> GROUP BY * ORDER BY ASC LIMIT 1 Last Value: SELECT * FROM <SERIES> GROUP … Read more
Bit of an old question but this is probably relevant to anyone working on TSDBs. When I first started, my appoach used to be that every data point went into a single field measurement. The assumption was that I’d combine the data I needed in a SQL statement at a later date. However, as anyone … Read more
Export data: sudo service influxdb start (Or leave this step if service is already running) influxd backup -database grpcdb /opt/data grpcdb is name of DB and back up will be saved under /opt/data directory in this case. Import Data: sudo service influxdb stop (Service should not be running) influxd restore -metadir /var/lib/influxdb/meta /opt/data influxd restore … Read more
Theres no way to drop all of the measurements directly, but the query below will achieve the same result. DROP SERIES FROM /.*/
Stats output does not contain that information. The size of the directory structure on disk will give that info. du -sh /var/lib/influxdb/data/<db name> Where /var/lib/influxdb/data is the data directory defined in influxdb.conf.
It appears that you can do this in influxdb 0.9. For instance, here’s a query that just succeeded for me: DROP SERIES FROM temperature WHERE machine=”zagbar” (Per generous comment by @MuratCorlu, I’m reposting my earlier comment as an answer…)
You can select RFC 3339 formatting by entering the following command in the CLI: precision rfc3339
InfluxDB CEO and developer here. The next version of InfluxDB (0.9.5) will have our new storage engine. With that engine we’ll be able to efficiently store either single event data or regularly sampled series. i.e. Irregular and regular time series. InfluxDB supports int64, float64, bool, and string data types using different compression schemes for each … Read more