Questions tagged [influx-db]
For posts about InfluxDB from InfluxData.
26
questions
0
votes
0
answers
27
views
InfluxDB InfluxQL v1.8 : Wrong timestamps used for writing to database
I wrote a bash script for inserting the summary of the daily energy database "xxx_d" into the monthly database "xxx_m" - triggered on every 1st day of the month at 02 o'clock by a ...
- 1
0
votes
1
answer
71
views
Database to save measurements
I am creating an infrastructure to save measurements coming from a fleet of around 2000 cars.
Each car contains about 60 sensors (depending from car) with a sum of about 800 values par second coming ...
- 1
0
votes
0
answers
53
views
Should related data points be separate measurements in InfluxDB or part of a single measurements?
I have two databases at home, one for temperature and and one for electrical consumption. They are populated by different tools (electricity data is coming from a simple Python script which I can ...
- 565
1
vote
1
answer
698
views
Choosing the right database for stock price history
The model is [(stock_id, period, ts), open, high, low, close, last, volume]
We write new prices for all stocks (120,000) each minute and delete old once when they go out of retention time. It doesn't ...
- 153
0
votes
1
answer
481
views
Transition from MongoDB Time Series Collections to InfluxDB
With version 5.0 MongoDB's specialized Time Series Collections were introduced to deal with such data. As I already stored some sensor meta data (configuration, specification ...) in MongoDB, I ...
- 103
0
votes
0
answers
798
views
InfluxDB on Raspberry Pi 3 and load issues
first of all, I'm not an database expert at all, but I managed to set up a system fitting my monitoring needs for more than one year now. Unfortunately, now the problem arises. Short summary of my ...
- 101
1
vote
0
answers
143
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 ...
- 121
1
vote
1
answer
3k
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 ...
- 21
0
votes
1
answer
2k
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 ...
- 53
1
vote
1
answer
1k
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 (...
- 11
2
votes
1
answer
2k
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 ...
- 173
1
vote
0
answers
226
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 ...
- 111
3
votes
1
answer
667
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 ...
- 179
0
votes
2
answers
2k
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 ...
- 101
1
vote
0
answers
345
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"
...
- 11
1
vote
1
answer
116
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 ...
2
votes
1
answer
593
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
1
answer
265
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 ...
- 23
5
votes
1
answer
427
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
0
answers
134
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 ...
- 11
1
vote
0
answers
223
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
1
answer
168
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 ...
- 11
1
vote
1
answer
5k
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" ...
- 401
0
votes
1
answer
535
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 ...
- 101
0
votes
1
answer
491
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.
...
- 1
17
votes
3
answers
29k
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 ...
- 271