Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [influx-db]

For posts about InfluxDB from InfluxData.

1
vote
1answer
14 views

InfluxDB batch insert only inserts the last line

I'm trying to insert some lines into a InfluxDB instance (running on Windows 7 x64) from both a .txt and a .csv file, but it's only inserting the last line on the file. I'm currently using the ...
0
votes
0answers
11 views

And-combine values of grouped subquery in influxdb not working

In my homeassistant setup, I want to show all times where noone is home. So I was thinking about running the following query: SELECT max("max_value") FROM ( SELECT max("value") AS "max_value" FROM "...
0
votes
0answers
28 views

what is the difference between duration and shardGroupDuration in influxdb

> SHOW RETENTION POLICIES ON telegraf name duration shardGroupDuration replicaN default ---- -------- ------------------ -------- ------- autogen 0s 168h0m0s 1 true ...
1
vote
0answers
20 views

InfluxDB Downsampling

I have a InfluxDB that is limited to 40 GB, it's being filled by AppMetrics .NET integration performance metrics on each event in the code, usually hundreds of events per second. My problem is that ...
0
votes
0answers
25 views

Timestamp of last influx database and measurements modification

How to get timestamp of last influx database and measurements modifications (last change timestamp)? For example, records adds to measurements of some database one day ago. And field "time" in each ...
0
votes
0answers
19 views

Why influxDB is good to save visits of a site?

I'm implementation a database for a site, and i make the table visits(For analytics purpose), whenever a user visits a page, will be a INSERT in my database. A friend my tell me it's no a problem, ...
0
votes
0answers
29 views

Skewed timestamp variation

I use InfluxDB as a time series database. It is quite nice to play with that type of infrastructure. However, I faced an annoying problem I don't know how to solve it. It seems hard to query the ...
1
vote
0answers
60 views

Store regular MySQL query results in a timeseries DB

I'm looking into installing a timeseries database like InfluxDB or Prometheus to handle data for our Grafana monitoring system. One of the things I like to do is run a couple of MySQL queries every ...
1
vote
0answers
35 views

Most effective way of logging user query activity

We are logging and permanently storing all the queries performed about private persons in our database. Due to GDPR we need to be able to show all the entities who have requested personal data and the ...
1
vote
0answers
65 views

InfluxDB - How to get start timestamp of alternating series

I have these data series in an influx database, alternating between 0 and 1. 2018-10-02T07:12:00Z 0 2018-10-02T07:15:00Z 0 2018-10-02T07:18:00Z 0 2018-10-02T07:21:00Z 0 2018-10-02T07:24:00Z 0 2018-10-...
0
votes
1answer
38 views

Unable to see measurements in influxdb

I am new to influxdb and I am having this trouble to show measurements. Our setup is that prometheus(aws ec2) is writing data to Influxdb(aws ec2). When I execute 'SHOW MEASUREMENT' I cannot see ...
1
vote
1answer
406 views

Influxdb and grafana: howto create series that is the sum of two other series

I have these three queries. They show the average upload speed of three different docker containers over time: The difference() call is needed, because the data contains cumulative "bytes_sent" ...
0
votes
1answer
164 views

Which database is best for storing mouse movement data for analytic stuff? [closed]

Problem I want to track the user behavior on website. I am tracking the mouse movement and after tracking certain number of mouse movements, i am planning to send this data to my server, where i will ...
0
votes
1answer
303 views

how to configure influx properly [closed]

I am storing some data in influx and it is quite confusing that influx is 4-5 times slow as Mysql. I try to test by inserting 10000 rows in mysql and then in influxdb. and the stats are below. ...
3
votes
1answer
8k views

Understanding how to choose between fields and tags in InfluxDB

What are some good rules and examples of how to choose between storing data in fields vs. tags when designing InfluxDB schemas? What I have so far is that a measurement that changes over time ...