[Bug] Limiting memory does not degrade query latency
- 主要言語
- Java
- スター
- 6.4k
- フォーク
- 1.2k
- 平均マージ
- 1日 23時間
- マージ済み PR(30日)
- 115
説明
### Search before asking
- [x] I searched in the [issues](https://github.com/apache/iotdb/issues) and found nothing similar.
### Version
1.1.3 and 1.3.4 (tested with standalone Docker image)
### Describe the bug and provide the minimal reproduce step
While testing IoTDB under limited memory configurations, using docker for that effect, it was found that the database's performance won't drop until the threshold of 4GB of memory is hit, despite it always using the maximum amount of memory allocated for the container.
It was expected that progressively constraining the database's available memory would lead to gradual performance degradation, but instead IoTDB maintains virtually identical query latency across the tested memory limits, despite always consuming the maximum amount of memory available to the container.
Minimal reprodution steps:
1. Launch IoTDB in standalone mode with constrained memory using Docker Compose
2. Preload data before executing queries
3. Execue a query workload, using the same for every memory configuration
The queries follow the following templates:
```sql
-- Aggregation
select agg_func(field) from path where time >= start and time <= end
-- Downsampling
select field from path group by ([start, end), step)
-- Outlier-filter
select field from path where time >= start and time <= end and field [>,>=,<,<=] threshold
```
### What did you expect to see?
Either performance degradation as memory limits get increasingly smaller, or the container not using all the memory available to it, if it is able to maintain performance with less memory usage.
### What did you see instead?
Performance didn't degrade until the 4GB memory limit, remaining similar regardless of the limit used, despite the database always using the maximum memory allocated to it.
### Anything else?
The tests were run using [MulletBench](https://github.com/pedropereira98/MulletBench/tree/main), as well as plot generation.
### Are you willing to submit a PR?
- [ ] I'm willing to submit a PR!
コントリビューションガイド
調査の方向性
まず、issue に記載された Docker Compose のメモリ構成を使用して、MulletBench で報告されたワークロードを再現し、クエリのレイテンシとコンテナのメモリ使用量を比較します。各制限値でレイテンシが変わらない原因となっているデータベースの挙動を追跡します。集計、ダウンサンプリング、外れ値フィルタリングのワークロードに対して原因を特定し、修正を検証できれば完了です。
索引モデルが issue の本文から書いたものです。
評価
- 技術スタック
- docker, java, sql
- 領域
- databases, performance
- issue の種類
- バグ
- 難易度
- 4/5
- 見積もり時間
- 3〜5日
- 活発さ
- 停滞
- 明瞭さ
- 説明が足りない
- 初心者へのやさしさ
- 35/100