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

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.

| username: xfworld | Original post link

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

| 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.

| username: TiDBer_菜鸟 | Original post link

2 nodes

| username: TiDBer_菜鸟 | Original post link

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

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

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