influxdata / influxdata/influxdb

How to query all cross-section data at a time in influxdb?

Open
#19,571 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
31.7k
Forks
3.7k
Avg merge
13h 37m
Merged PRs (30d)
8

Description

Hello Developers, here is a demand about influxdb, please help me.
For example, 10000 node metrics (cpu,mem,..) are collect into influxdb, 1-minute interval , How to design the fastest measurement structure to query all node metrics at certain time points?
```sql
-- Pseudocode
select xxx from xxx where time = '2020-09-16 00:01:00'
```
|node|cpu|mem|time|
|---|---|---|---|
|node1|0.10|0.23|2020-09-16 00:01:00|
|node2|0.21|0.13|2020-09-16 00:01:00|
|node3|0.30|0.53|2020-09-16 00:01:00|
|node4|0.15|0.43|2020-09-16 00:01:00|
|...|...|...|2020-09-16 00:01:00|
|noden|0.xx|0.xx|2020-09-16 00:01:00|

Thank you very much , looking forward to your reply.

Contributor guide

Open the contributing guide

Research direction

The issue provides a pseudocode query and a sample node, cpu, mem, and time table. Start by reviewing the InfluxDB data-modeling and query documentation for querying metrics across nodes at one timestamp; done would be a documented, supported schema and query approach.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Documentation
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.