Why is TiFlash's CPU usage high but memory usage low?

Translated
1

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

Original topic: 为什么tiflash的cpu使用率很高，内存利用率却很低

| username: TiDBer_菜鸟

The configuration is 64 cores and 128GB.

2
| username: xfworld | Original post link

How many nodes did you set up? How many replicas?

3
| username: hey-hoho | Original post link

It’s normal, TiFlash is quite CPU-intensive. I have two TiFlash instances on my 128-core machine, and the CPU usage is close to 50% under normal circumstances, with memory usage around 20GB per instance.

4
| username: TiDBer_菜鸟 | Original post link

2 nodes

5
| username: TiDBer_菜鸟 | Original post link

I feel that TiFlash is a bit of a memory hog. :joy:

6
| username: 我是咖啡哥 | Original post link

Low memory usage indicates that the table is not large enough and the SQL is not bad enough. :joy: