Stack Overflow
Stack Overflow

Questions tagged [influxdb]

InfluxDB is an open-source time series, events, and metrics database written in Go, with no external dependencies.

Links

2990 questions
76
votes
4 answers

Usecases: InfluxDB vs. Prometheus

Following the Prometheus webpage one main difference between Prometheus and InfluxDB is the usecase: while Prometheus stores time series only InfluxDB is better geared towards storing individual events. Since there was some major work done on the…
SpaceMonkey
  • 965
  • 1
  • 8
  • 12
71
votes
4 answers

How to format time in influxdb select query

I am new to InfluxDB. I am querying data in admin ui. I see time as timestamp. Is it possible to see it formatted as date and time?
PolinaC
  • 711
  • 1
  • 5
  • 3
65
votes
11 answers

Can you delete data from influxdb?

How do you delete data from influxdb? The documentation shows it should be as simple as: delete from foo where time < now() -1h For some reason, influxdb rejects my delete statements saying "Delete queries can't have where clause that doesn't…
spuder
  • 17,437
  • 19
  • 87
  • 153
47
votes
4 answers

InfluxDB storage size on disk

All I want is simply to know how much space my InfluxDB database takes on my HDD. The stats() command gives me dozens of numbers but I don't know which one shows what I want.
Jaap Weijland
  • 3,146
  • 5
  • 23
  • 31
44
votes
5 answers

In Influxdb, How to delete all measurements?

I know DROP MEASUREMENT measurement_name used to drop single measurement. How to delete all measurements at once ?
rajagopalx
  • 3,012
  • 9
  • 41
  • 52
36
votes
7 answers

Export data from InfluxDB

Is there a way (plugin or tool) to export the data from the database (or database itself) ? I'm looking for this feature as I need to migrate a DB from present host to another one.
Srikanta
  • 1,145
  • 2
  • 12
  • 22
33
votes
4 answers

InfluxDB : single or multiple measurement

I'm a beginner with influxDB and after reading the Schema design documentation a question remain. How to decide if you should use one measurement with multiple fields or multiple measurement with single field ? I have multiple iot device which send…
grunk
  • 14,718
  • 15
  • 67
  • 108
31
votes
7 answers

InfluxDB - Getting only last value in query

Is possible to query only for the last value (or n-th value) of the results of a query? For example, in the query: SELECT value FROM response_times WHERE time > now() - 1h limit 1000; Is possible to get only the last value, i.e. the one more far…
dukebody
  • 7,025
  • 3
  • 36
  • 61
28
votes
2 answers

Integrating Grafana into a web app

A little background, I have been working with BCI (brain computer interface) and multi channel EEG to monitor brain activity. When the user starts a session with the BCI cap on, the raw data streaming from each channel is stored into Influxdb. I…
Corleone
  • 361
  • 1
  • 3
  • 6
27
votes
2 answers

How to change location of Influxdb storage folder?

I've Installed package from the official site by instruction. By default the physical destination of database folder is /opt/influxdb/shared. I've tried to change properties of config file and written it properly. But after that I can't start the…
Alexey Batsman
  • 371
  • 1
  • 3
  • 5
26
votes
3 answers

Delete points with unwanted field values from InfluxDB measurement

InfluxDB lets you delete points based on WHERE tag='value' conditions, but not by field value. For example, if you have accidentally stored a measurement with a value of -1 in a series of positive floats (e.g. CPU utilization), DELETE FROM metrics…
Dan Dascalescu
  • 143,271
  • 52
  • 317
  • 404
25
votes
1 answer

Max values per tag limit exceeded InfluxDB

I am using java and writing into InfluxDb using batch points. My code is mention below, BatchPoints batchPoints = BatchPoints .database(dbName).retentionPolicy("autogen") .consistency(InfluxDB.ConsistencyLevel.ALL).build(); point =…
Ammad
  • 4,031
  • 12
  • 39
  • 62
25
votes
5 answers

How to get InfluxDB version via shell

The influx shell has a -version flag, but not influx server: /path/to/bin/influx -version InfluxDB shell version: 1.1.1 /path/to/bin/influxd -version flag provided but not defined: -version /path/to/bin/influxd -v flag provided but not defined:…
Anto
  • 6,806
  • 8
  • 43
  • 65
25
votes
7 answers

Is there a way to have a moving average in Grafana?

I didn't find a 'moving average' feature and I'm wondering if there's a workaround. I'm using influxdb as the backend.
bbigras
  • 1,311
  • 2
  • 17
  • 32
23
votes
2 answers

How to install Debian packages on Alpine?

How to install Debian packages on Alpine? For example: wget https://dl.influxdata.com/influxdb/releases/influxdb_0.13.0_armhf.deb sudo dpkg -i influxdb_0.13.0_armhf.deb
viswa
  • 259
  • 1
  • 2
  • 4
1
2 3
…
99 100