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

How can I use time series database and visualization frameworks to render growing data with ancient timestamps?

I am gathering time series data from the game "Patrician 3" (inventory of each town and trading office), which takes place in the middle ages (1300+). Since transforming time series data into graphs is a solved problem, I'd like to use an…
Benni
  • 1,030
  • 2
  • 11
  • 18
0
votes
1 answer

InfluxDB convert a difference query from InFluxQL to Flux

I am converting reports from InfluxQL to Flux I cant seem to be able to do this correctly for a difference query. This is my difference query I need to convert SELECT difference(last("value")) / ($__interval_ms/1000) FROM "sqlserver_performance"…
Leo Torres
  • 673
  • 1
  • 6
  • 18
0
votes
0 answers

Influx DB 2 api token use in different container

I want to create an read only influx API token when initializing my influx DB using this command. I want to have the resulting API key of this call available as a docker secret so other containers can use it. My problem is that this command seems…
jonathan-dev
  • 330
  • 1
  • 3
  • 16
0
votes
0 answers

storing float and string in same measurement

I'm using telegraf to receive data via MQTT and output it to an InfluxDB. In my case its data from several Shelly PowerPlugs (for example). I only process specific topics but they include both float and string values. I currently have 2 inputs…
Olli
  • 689
  • 1
  • 6
  • 13
0
votes
0 answers

How to fetch live data from influxDb

We store live data in influxDb, I want to get live data from influxdb at certain intervals and show it in React graphics. For this, I think I need to open a web socket connection to influxDb. But is there such a thing? Can I open a web socket…
emir alp aksungur
  • 21
  • 4
0
votes
0 answers

Telegraf save only last line of csv input

I have a script that print a result like that: somename,bps,running_time AAA,1886,01:35 BBB,6235,01:35 CCC,2532,01:35 Here is my telegraf config : [[inputs.exec]] commands = [ "bash /opt/latency/test.sh" ] timeout = "5s" name_override =…
Elikill58
  • 4,050
  • 24
  • 23
  • 45
0
votes
0 answers

Retention Policy issue in InfluxDB

I've installed influxdb and created a bucket "test" via UI and I selected 1 hour when asked, "Delete data older than?" As in the above image, I added a sample data row. But when I checked after 1 hour, the row still exists. Can someone explain to…
RSSAH
  • 123
  • 14
0
votes
0 answers

how to delete data in influxdb2.0?

how to delete data in influxdb2.0, how to delete in springboot project? I use influxDBClient, it has a api calls getDeleteApi(), but I don't know how to use it , DeleteApi.delete(@Nonnull final DeletePredicateRequest predicate, @Nonnull final String…
lucien
  • 1
0
votes
0 answers

InfluxDB (Flux) Get difference in seconds of last query to calculate mean

I am currently building a Monitoring Application with the help of InfluxDB and Grafana and have come to an issue I couldn't find any solution to. Specifically, I am monitoring the Network Traffic of my Server in rate/s but since my the data source…
Matt
  • 1
0
votes
0 answers

influxdb high volume of data - api optimization

I'm writing about 500k samples per second into influxdb using telegraf and MQTT. Although CPU and memory are in low utilization, influx cannot store the data at this speed. Data is generated locally, so I don't have network problems. HD doesn't have…
Luca Forgiarini
  • 1
0
votes
1 answer

InfluxDB - Unauthorized Access Issue

I'm new to InfluxDB and encountering an "unauthorized access" issue when trying to connect to my InfluxDB instance using the Python influxdb library. I'm receiving the following error message: Reason: Unauthorized HTTP response headers:…
Shounak Basu
  • 1
  • 1
0
votes
0 answers

grafana query to count same values until value changes

Good afternoon. So I am creating a grafana dashboard and I am having a problem with counting a unique number in a list until the number changes. I am counting the number of times a service is unavailable, when the ping rate is 100% loss. The…
Ivyand
  • 1
  • 1
0
votes
1 answer

Correctly organize time series data on InfluxDB

I'm super new to time series database and I've just approached the use of InfluxDB with Python. I'm trying to understand what's the best way to organize data. The system I need to monitor is basically a cluster of sensors. The data acquisition will…
NicoCaldo
  • 1,171
  • 13
  • 25
0
votes
0 answers

How to create single value as "% time a value is positive"

I have a metric in my app which at different times throughout the day pushes a non-negative integer (0,1,2,3,4,5...) to my influxdb database. I can't work out the InfluxQL or Flux query to display a rolling figure for 'the % of time the value is >…
jsstuball
  • 4,104
  • 7
  • 33
  • 63
0
votes
0 answers

Calculate state distribution over time using state change data in influxdb

I have an InfluxDB measurement table, which stores the state of a system over time. Each data point has a tag that represents the state and a duration indicating the time it was in that state. For example: | Time | State |…
DJanssens
  • 17,849
  • 7
  • 27
  • 42
1 2 3
…
99
100