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
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.
You can select RFC 3339 formatting by entering the following command in the CLI: precision rfc3339