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
14
votes
3 answers

Query the most recent timestamp (MAX/Last) for a specific key, in Influx

Using InfluxDB (v1.1), I have the requirement where I want to get the last entry timestamp for a specific key. Regardless of which measurement this is stored and regardless of which value this was. The setup is simple, where I have three…
Juliën
  • 9,047
  • 7
  • 49
  • 80
14
votes
3 answers

Creating tables in InfluxDB via Terminal

Are there tutorials online that teaches you how to create tables and input values in InfluxDB? How would you create a table and insert values into them?
gordon sung
  • 605
  • 2
  • 8
  • 27
14
votes
1 answer

Querying for tag values in a given list

Is there any shortform syntax in influxdb to query for membership in a list? I'm thinking of something along the lines of SELECT * FROM some_measurement WHERE some_tag IN ('a', 'b', 'c') For now I can string this together using ORed =s, but that…
JPC
  • 1,891
  • 13
  • 29
13
votes
2 answers

Docker Daemon stop - Timeout for container defaults 10s

docker stop has a standard timeout of 10s (Reference - Docker Stop). This time window may be to short for the shutdown of mysql or influxdb to reach a consistent state on file system. If I stopped the container by hand, I would shut it down with…
notes-jj
  • 1,437
  • 1
  • 20
  • 33
13
votes
3 answers

How to show "33 minutes ago" on Grafana dashboard with InfluxDB?

I have recently set up Grafana with InfluxDB. I'd like to show a panel that indicates how long it has been since an event took place. Examples: Server last reported in: 33 minutes ago Last user sign up: 17 minutes ago I can get a single metric…
PaulMest
  • 12,925
  • 7
  • 53
  • 50
12
votes
1 answer

Prometheus remote read influxdb

I'm new to Prometheus but familiar with Influx (currently running 1.6). My understanding is it's possible to configure Prometheus to remotely read data from influx with the following configuration in prometheus.yml: remote_read: url:…
musca999
  • 341
  • 2
  • 12
12
votes
3 answers

How to get InfluxDB measurement size?

I have a an InfluxDB measurement named kpi. I want to get the size of that single measurement in MB. So far I have tried: du -sh /var/lib/influxdb/data/demo/ 27M /var/lib/influxdb/data/demo/ But this command gives me the size of the whole…
Shubham Bansal
  • 121
  • 1
  • 1
  • 4
12
votes
2 answers

Rename MEASUREMENT

I am using influxDB instead of MySQL for time series analysis. In my database data, I have a series which is called /HFT/Data_HFT/OrderBook/DCIX_OB. That name is irrelevant and it was created by error. That series has 89 million lines, so it would…
Jeremie
  • 405
  • 1
  • 7
  • 20
12
votes
1 answer

Using InfluxDB subquery to subtract values

I have a Influx database that is getting filled with values. These values are presented by Grafana. What I need is to get the actual values depending on the selected time interval. Currently I have the following query for a single metric: SELECT…
Nhz
  • 131
  • 1
  • 6
12
votes
4 answers

Change tag value in InfluxDB

I have data being inserted that uses host names. Annoyingly I'm about to change a domain from .lan to .mydomain.com Obviously I'd like to be able to search my historical data of a machine as it crosses this change. Can I update a tag definition…
dcole
  • 317
  • 1
  • 4
  • 12
11
votes
2 answers

How do I debug Telegraf?

I'm trying to get Telegraf to work with InfluxDB and I've just hit a wall. I've added the following block to my Telegraf configuration file: [[inputs.win_perf_counters.object]] # Process metrics, in this case for IIS only ObjectName = "Process" …
mrplainswalker
  • 701
  • 4
  • 8
  • 26
11
votes
0 answers

InfluxDB calculating elapsed time between points

I have series of values that specify the status of jobs, either success or failure. Each item in the series has a type, and also a grouping ID. It's a dependent sequence so job bar for ID A will run if job foo was successful. idx time …
Matt
  • 2,153
  • 1
  • 18
  • 29
11
votes
3 answers

InfluxDB data structure & database model

Can you please tell me, which data structure has an InfluxDB und which data model InfluxDB use? Is this key-value model. I read the full documentation and I didn't catch that. Thank you in advance!
Mary Fel
  • 129
  • 1
  • 7
11
votes
2 answers

influxdb query: specify or filter tag by regex

According to the docs, we can... Use a regular expression to specify a tag with a value in the WHERE clause. When I query my influxdb like this, I get the desired results. > SELECT "field" FROM "measurement" WHERE tag = 19 When replacing the…
creimers
  • 4,975
  • 4
  • 33
  • 55
11
votes
4 answers

How to create a measurement in InfluxDB

I am a beginner with InfluxDB and I've read the intro documentation, but cannot find any details on how to create a new measurement. Am I missing something ?
borgmater
  • 658
  • 3
  • 11
  • 35
1 2
3
…
99 100