For posts about InfluxDB from InfluxData.
InfluxDB is a time-series database, written in Go, from InfluxData.
Questions tagged [influx-db]
27 questions
23
votes
3 answers
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 be a field, and metadata about the measurement…
Dan Dascalescu
- 331
- 1
- 2
- 7
5
votes
1 answer
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 few minutes to gather business metrics (like number…
3
votes
2 answers
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 matter if retention cleanup will happen…
Kaplan Ilya
- 173
- 2
- 7
3
votes
1 answer
Should I use prometheus or influxdb
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 already have prometheus installed on our servers.…
mateeyow
- 179
- 6
2
votes
0 answers
Kubernetes: Influxdb 1.8.10 container can’t create users
I deployed on docker InfluxDB v 1.8.10 with command:
docker run --name influxdb -t
-e INFLUXDB_HTTP_AUTH_ENABLED=“true”
-e INFLUXDB_DB=“mydatabase”
-e INFLUXDB_USER=“user”
-e INFLUXDB_USER_PASSWORD=“user”
-e INFLUXDB_ADMIN_USER=“admin”
-e…
Marco Ferrara
- 121
- 2
2
votes
1 answer
Is InfluxDB faster than PostgreSQL
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 postgresql, then?
I heard from someone that…
Tobi Akinyemi
- 193
- 2
- 7
2
votes
0 answers
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"
WHERE ("entity_id" = 'cabana') AND $timeFilter…
martin blitz
- 21
- 2
2
votes
1 answer
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 Insomnia interface to send the file through Influx's…
Segmentation Fault
- 41
- 4
1
vote
0 answers
InfluxDB not returning results when group by time offset at a summer/winter time change
Let's start with an example. I've got an application that logs a point every minute. When I aggregate this data into a query where I'll have the count of logs per day, I get the following result. Keep in mind, that the query and the data is in…
Ron Nabuurs
- 121
- 3
1
vote
1 answer
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 decided to make use of these special collections to…
albert
- 113
- 1
- 6
1
vote
0 answers
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 iops available.
But when I look at htop I see only 1…
GTXBxaKgCANmT9D9
- 131
- 1
- 3
1
vote
1 answer
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 several data points from various sensors or just…
John D.
- 21
- 1
- 4
1
vote
1 answer
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 (literally, time series data). I have to imagine this is one of the most…
lifeofaboat
- 11
- 2
1
vote
0 answers
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 a given tag value.
Here is an example of…
Pierre S.
- 111
- 1
1
vote
1 answer
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 recorded.
'volt', 'rotate', 'pressure', 'vibration' - 4…
