Questions tagged [influx-db]

For posts about InfluxDB from InfluxData.

Filter by
Sorted by
Tagged with
0
votes
0answers
4 views

Merge multiple InfluxDB 1.8 dbs into one + add tags with names of dbs

I have multiple InfluxDB 1.8 databases with same schema but different names of databases. I need to merge them all into one database + add a tag with name of original database the data came from so I ...
1
vote
0answers
6 views

Optimize InfluxQL query for multi core use?

I have an InfluxQL query (Influxdb 1.8) & it takes a lot of time for it to finish even on c5.4xlarge with Intel Xeon Platinum 8000 with Turbo CPU clock speed of up to 3.6 GHz + EBS io2 with 16k ...
1
vote
1answer
43 views

InfluxDB: selecting last() values from different tags

I have a bucket with the raw data of several sensors, things like temperature, air pressure and etc. The sensors don't send their data at the same time, which means that a given timestamp might have ...
0
votes
0answers
22 views

InfluxDB - Get series containing given field

Is it possible to ask Influxdb (1.8 version, using InfluxQL) for all series which contains given fields? I have database which stores results of some research experiments. Each experiment is stored as ...
0
votes
0answers
7 views

Using Aggregate functions on tags influxDB

Is is possible to somehow calculate for example avg on tags? I need to do something like Select mean(tag_1) from myMeasurement where currency = 'currency1' However, mean requires field, not tag value. ...
0
votes
0answers
126 views

Influx + Grafana: Subtract values from two queries

I'm using iobroker to collect data from my smart meter and photovoltaic system and write it to influxdb. Now I'm struggeling with displaying some of the data in grafana. I have the following two ...
0
votes
1answer
253 views

InfluxDB with Zabbix or Telefraf?

I'm considering the use of InfluxDB to store thousands of measurements per second from routers in a network. Each measurement is lightweight (between 10-20 bytes). Now, I'm wondering what is the ...
1
vote
0answers
117 views

InfluxDB - Tag vs Field for simple, time series data

We are new to InfluxDB, and are struggling to understand the query performance difference between a "tag" and a "field" for storing simple, time-stamped measurement values (...
-1
votes
1answer
85 views

Is InfluxDB faster than PostgreSQL [closed]

According to this article the only real benefit influx has over postgres (using time-based indices) is space used. PostgreSQL is more performant, with time indices. Why would one use influx-db over ...
0
votes
0answers
91 views

Sum of last value of multiple measurements in InfluxDB timeseries data

I have a database some_db with multiple measurements first_measurement, second_measurement that contain timeseries data. I want to query the sum of the most recent value of each of these. I tried ...
1
vote
0answers
43 views

Influx:Show field keys based on tag values (or the other way)

I have an influx database with one tag key (called machine) and multiple field key (called cpu and memory). I want to be able to find all unique tag values for each field key or filled field keys for ...
0
votes
0answers
9 views

Are same tag values stored multiple times if tag values are not chaging in points, only field values are changing?

I have a doubt in InfluxDB. When storing multiple points with same tag values and different field values, are tags stored multiple times or just once for each unique combination? My understanding is ...
2
votes
1answer
120 views

Should I use prometheus or influxdb [closed]

I know this has been asked a lot of times and I've checked almost all of the links out there but just want to have a third-party opinion on our use case. So I'm working for an IOT company and we ...
0
votes
2answers
193 views

What is the equivalent of SELECT <certain columns> in Flux Query Language?

What would be equivalent flux query for SELECT address, name FROM addresses ? (I am referring to FluxQL, the new query language developed by InfluxData) I didn't find a clear answer to this in the ...
1
vote
0answers
199 views

adding results of InfluxDB subqueries

I'm trying to get the kWh from multiple entities in InfluxDB in Grafana. I have the following raw query. SELECT ("a" + "b") / 3600000 FROM ( SELECT spread("watt_seconds") AS "a" FROM "W" ...
1
vote
1answer
30 views

Influx - Help to choose in between Tag and Field

I have the following columns: 'datetime', - which gives the time when the sensor values are recorded. 'machineID', - which gives the machine ID of the machine from where the sensor values are ...
1
vote
1answer
362 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 ...
1
vote
1answer
178 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 ...
5
votes
1answer
284 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
51 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
189 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-...
1
vote
1answer
96 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 ...
2
votes
1answer
3k 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
379 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
445 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. ...
12
votes
3answers
17k 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've found so far is: a measurement that changes over time should ...