Questions tagged [influxdb]

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

Links

2990 questions
11
votes
2 answers

Issue formatting data for inserting strings into influxdb

I am not understanding the format needed to insert data. Why doesn't test a=dog,b=0,c=nice work? On the site, I see that [,=...] =[,=...] is the format to follow. I…
bagnina
  • 121
  • 1
  • 1
  • 6
11
votes
1 answer

Can I create different retention policy for different measurements in influxdb?

Is it possible to treat different measurements in influxdb with different a retention policy?
p0fi
  • 1,056
  • 12
  • 28
11
votes
1 answer

C3.js - How to specify the timestamp format when plotting timeseries taken from InfluxDB

influxDB timestamps look like this: 2015-01-29T21:55:43.702900257Z The question is what options should I use for the x-axis when I generate the graph with C3.js The error I get: "Failed to parse x '2015-01-29T21:55:43.702900257Z' to Date…
tgogos
  • 23,218
  • 20
  • 96
  • 128
11
votes
1 answer

JS based influxdb graph editors like Grafana, Influga, are there reusable libraries?

I have been working with tools like grafana or influga, which are fantastic projects which facilitate the creation of dashboards with charts and various type of graphs. I was wondering, would it be possible to separate the 2 core features of these…
nemesisdesign
  • 8,159
  • 12
  • 58
  • 97
10
votes
1 answer

Client sent an HTTP request to an HTTPS server

I have a python application running on a virtual machine, were a legacy, and now I'm migrating to a Kubernetes. I use influxdb==5.2.3 package, connecting to this form Influx(host=r'influx_HOST', port=8086, username='MY_USER', password='***',…
Isma90
  • 661
  • 2
  • 14
  • 30
10
votes
4 answers

Influxdb storage folder [windows]

I am trying to check size of db created in influxdb. Where can I find storage folder, or if it is distributed in many places what is the best method to measure size of my db ?
kosnkov
  • 5,609
  • 13
  • 66
  • 107
10
votes
2 answers

InfluxDB - what's shard group duration

I have created one year policy in InfluxDB and shard group duration was automatically set to 168h. This is how my retentions look like now: This is how my shards look like now: What does it mean for my data that shard's end time is set one week…
Slaven Tomac
  • 1,552
  • 2
  • 26
  • 38
10
votes
1 answer

How to select last record in InfluxDB

I have pretty simple measurement in influxDB and have default time column and two other columns as shown below, Select * from measurement gives me this out put. time component_id jkey 2016-09-27T02:49:17.837587671Z …
Ammad
  • 4,031
  • 12
  • 39
  • 62
10
votes
3 answers

How to get the number of entries in a measurement

I am a newbie to influxdb. I just started to read the influx documentation. I cant seem to get the equivalent of 'select count(*) from table' to work in influx db. I have a measurement called cart: time status cartid …
zambro
  • 414
  • 1
  • 6
  • 17
10
votes
5 answers

Exposing Spring Boot metrics to influxDB for grafana visualization

I have a Spring Boot application running on Cloud Foundry that exposes metrics and health info via the /metrics & /health endpoints respectively. I'd like to post these metrics as a continuous stream to an influxDB user provided service for…
citizenBane
  • 337
  • 1
  • 4
  • 13
10
votes
4 answers

Choosing a TSDB for one-off smart-home installation

I'm building a one-off smart-home data collection box. It's expected to run on a raspberry-pi-class machine (~1G RAM), handling about 200K data points per day (each a 64-bit int). We've been working with vanilla MySQL, but performance is starting to…
John Clements
  • 16,895
  • 3
  • 37
  • 52
10
votes
4 answers

Multi-timeseries operations in Grafana

How do I subtract two timeseries in Grafana? Or add two together, divide one by another, etc...? I have found vague hints online about taking differences between timeseries, but nothing that actually tells me how to do so. I'm using Grafana…
staticfloat
  • 6,752
  • 4
  • 37
  • 51
10
votes
2 answers

Left join in influx DB

I am new to influx DB. Now I need to migrate MySQL db into influxDB. I chose influx DB because it support SQL like queries. But I could not found left join in it. I have a series called statistics which contains browser_id and another series…
Sajith
  • 2,842
  • 9
  • 37
  • 49
9
votes
1 answer

Django + Influxdb

I have tseries data that has been stored in influxdb, I would like to serve this data through a web API and therefore are considering Django framework and its REST API framework as a solution. At the moment, there is no known support for Influxdb on…
qboomerang
  • 1,931
  • 3
  • 15
  • 20
9
votes
0 answers

Influxdb: how to convert field to tag

How can I convert field to tag in my measurements? I have a field 'name' which has to to be converted into a tag 'name'.
Maksym Polshcha
  • 18,030
  • 8
  • 52
  • 77