TiFlash

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tiflash

| username: cy6301567

Does TiFlash support multi-table join for correlation analysis? I saw in the documentation that the QPS is not high.

2
| username: 啦啦啦啦啦 | Original post link

Supported, but it’s best not to set the concurrency of TiFlash too high, otherwise it might cause an OOM (Out of Memory) issue.

3
| username: Jellybean | Original post link

TiFlash is very suitable for scenarios involving joins of multiple large tables, and it has MPP and other strategies for specialized optimization, making it very adept at handling large SQL AP analysis. For business scenarios involving large data volume calculations, the focus is mainly on high throughput and large capacity calculations, with high QPS being relatively less important and unnecessary.

There is also a similar post in the forum that you can check out: tidb支持两张一亿级别的数据表进行join关联数据分析？ - TiDB 的问答社区