InfluxDB is an open-source time series, events, and metrics database written in Go, with no external dependencies.
Links
Questions tagged [influxdb]
2385 questions
68
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
- 885
- 1
- 8
- 11
64
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
- 641
- 1
- 5
- 3
53
votes
10 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
- 14,200
- 14
- 77
- 129
36
votes
3 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
- 2,419
- 6
- 34
- 49
34
votes
1 answer
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
- 2,367
- 4
- 18
- 28
30
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,014
- 2
- 12
- 21
24
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
- 13,700
- 12
- 61
- 103
22
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
- 5,900
- 7
- 37
- 60
22
votes
6 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
- 6,284
- 3
- 30
- 54
22
votes
12 answers
How to install InfluxDB in Windows
I am new to InfluxDB. I could not find any details about installing InfluxDB on Windows. Is there any way to install it on a Windows machine or do I need to use a Linux server for development purposes?
Sajith
- 2,802
- 9
- 33
- 47
21
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
- 271
- 1
- 2
- 6
20
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
- 3,225
- 5
- 29
- 52
19
votes
2 answers
How to use a InfluxDB-tag value in a grafana legend?
I have a InfluxDB dataseries. It stores one information about mulitple machines. I distingsh between these machines with a tag. I can display the information for all three machines at once using a "Group by tag(machine)" clause. the name of the…
Michael K.
- 373
- 1
- 2
- 12
19
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
- 110,650
- 40
- 276
- 363
18
votes
4 answers
select from InfluxDB where value is null
If my data (conceptually) is:
# a b c
-------
1 1 1
2 1 1 0
3 1 0 1
Then in legacy SQL language, the statement would be:
select * from table where b is null
I cannot find a similar condition within the InfluxDB Query Language…
glasnt
- 2,788
- 5
- 32
- 51