influxdata / influxdata/influxdb
Influxql on v2.0.6 slower than on v1.7.8 on windows
Nobody has claimed this yet.
- Dominant language
- Rust
- Stars
- 31.7k
- Forks
- 3.7k
- Avg merge
- 13h 37m
- Merged PRs (30d)
- 8
Description
Steps to reproduce:
List the minimal actions needed to reproduce the behavior.
- Configured windows InfluxDB 1.7.8 and 2.0.6 on similar EC2 instances, Replicated some of the data from the 1.7.8 database to the new 2.0.6 database.
- Run simple influxql query from Grafana 7.5, returning 240,000 data points.
- Using the Grafana query stats, it appears that the 1.7.8 version is about 2 times faster than the 2.0.6 version for the exact same query with the same data. Similar experience when running 2.X on linux.
Expected behavior:
InfluxQL in v 2.X should be no slower than in 1.X
Actual behavior:
InfluxQL in 2.0.6 is about 2 times slower than on 1.7.8 on windows with similar hardware.
Environment info:
Similar EC2 instances with 16 GB ram.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by comparing the same InfluxQL query and dataset through Grafana 7.5 on Windows against InfluxDB 1.7.8 and 2.0.6, using the reported similar EC2 instances and query stats. The issue does not name a query, test, or source entry point; done would require isolating and correcting the performance regression, then demonstrating comparable results.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- grafana
- Domain
- databases, observability, performance
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100