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
7
votes
0 answers

How to store rrd file into influxdb

I'm using ganglia for monitoing. ganglia store its data as rrd file. It is rrd files that stores metrics data on gmetad. Usually the default path is /var/lib/ganglia/rrds/// where each metric is stored in a single rrd file…
Shahriar
  • 13,460
  • 8
  • 78
  • 95
7
votes
2 answers

How to run InfluxDB on Heroku?

Is it possible, and if so, how? I'd like to be able to reach it from my existing Heroku infrastructure. Will I need a Procfile? From what I understand it's just a standalone binary written in Go! so it shouldn't be that hard to deploy it, I'm just…
dsp_099
  • 5,801
  • 17
  • 72
  • 128
7
votes
2 answers

Calculating duration between a start and end event in InfluxDB

I have two write points for InfluxDB, one is the start and the other is the end. I just need to determine the duration between those two events, and make queries around it. InfluxDB has difference() aggregate method, but it doesn't work on the time…
Arbie Samong
  • 1,195
  • 1
  • 15
  • 17
6
votes
0 answers

Append calculated field (percentage) and combine with results from different datasets, in Influx Flux

I'm struggling with an Influx 2 query in Flux on how to join and map data from two differents sets (tables) into a specific desired output. My current Flux query is this: data = from(bucket: "foo") |> range(start:-1d) |> filter(fn: (r) =>…
Juliën
  • 9,047
  • 7
  • 49
  • 80
6
votes
1 answer

Why is this InfluxDB Flux query returning 2 tables?

Obv. I'm new to InfluxDB & the Flux query language so appreciate patience! Happy to be redirected to documentation but I haven't found anything genuinely useful to date. I've configured Jenkins (2.277.3) to push build metrics to InfluxDB (Version…
CPH
  • 501
  • 1
  • 5
  • 14
6
votes
2 answers

How to check if a tag exists in a measurement using flux?

How to check if a specific tag exists in a measurement using flux language? My influxdb version is 2.0.
多线程大脑
  • 89
  • 1
  • 6
6
votes
2 answers

aggregateWindow aligned to specified timezone

Given the following query in Influxdb's Flux language: from(bucket: "some-great-metrics") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> aggregateWindow(every: 1mo, fn: sum) |> yield() Assuming my current timezone is PST. How…
GreNodge
  • 907
  • 4
  • 12
  • 26
6
votes
1 answer

How to filter out data if "_value" is a string [Flux] [InfluxDB]

Among my data, there are a couple strings in the "_value" column. This means that when I use aggregateWindow() I get this error: unsupported input type for mean aggregate: string. I want to know how I can filter out data of type string, before…
Keldan Chapman
  • 665
  • 5
  • 21
6
votes
1 answer

When organising an InfluxDB database, which of these two approaches would be most preferred?

I am trying to decide how measurements should be organised in an InfluxDB the database (which I believe they call schema design and data layout) but I think this may be a more general database type question. Let's say as a simple example that I am…
teeeeee
  • 641
  • 5
  • 15
6
votes
1 answer

Streaming InfluxDB data

I've used influxDB for a while now, but never had to continuously stream data from it. A simple GET /query was sufficient. But now I need a way to stream data to the frontend to draw pretty graphs and such. So far we've been running GET /query…
pinkstone
  • 111
  • 2
  • 10
6
votes
1 answer

How to set the time precision of the telegraf statsd (influxdb)?

I'm using telegraf with influxdb, and in the telegraf I'm using the statsd_input plugin. The statsd_input.conf: [[inputs.statsd]] ## Address and port to host UDP listener on service_address = ":8126" ## The following configuration options…
Yuval Pruss
  • 8,716
  • 15
  • 42
  • 67
6
votes
1 answer

InfluxDB Group By Field (Not Tag) and Get Top 10

i am very new to influxdb. I have a dataset like this; (Every row/point is a connection) time dest_ip source_ip ---- ------- --------- 2018-08-10T11:42:38.848793088Z…
Mete Gergen
  • 63
  • 1
  • 1
  • 3
6
votes
1 answer

InfluxDB how to get the last recorded values

There is an Inflix DB database in which values are written. How do I get the last recorded data (for example, protocol number and time in long) for a device named "test"? I tried to get it through query, but it returns only one point, although…
Egor Vasilyev
  • 303
  • 2
  • 14
6
votes
2 answers

Influxdb for a financial application

I'm migrating my financial analysis application data from MongoDB to InfluxDB because the data and the analysis is growing exponentially. My current scenario is: 1) Get the tick every second from the exchanges and store it in a measurement called…
c0nf1ck
  • 359
  • 3
  • 14
6
votes
1 answer

How can I tell if there is more data after a query with LIMIT?

I am using LIMIT and OFFSET in InfluxQL queries to handle pagination. For example, in a measurement with 3 rows. > SELECT *::field FROM i2QYtZBVSnuXjLhQhuAV6w; name: i2QYtZBVSnuXjLhQhuAV6w time hello ---- …
LodeRunner
  • 7,975
  • 3
  • 22
  • 24
1 2 3
…
99 100