TiKV monitoring CPU fails to display when selecting a larger time range

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

Original topic: tikv监控cpu选择时间范围大一些就无法显示

| username: 路在何chu

[TiDB Usage Environment] Production Environment 4013
[Reproduction Path] What operations were performed when the issue occurred
Monitoring cannot be displayed

[Encountered Issue: Issue Phenomenon and Impact], query processing would load too many samples into memory in query execution
Queries older than 2 hours cannot be displayed due to insufficient memory, but other monitoring items can be queried. Does this CPU monitoring require a lot of memory?

| username: oceanzhang | Original post link

Yes, it is needed. As more data is added later, its memory usage will increase, and a lot of data needs to be processed.

| username: DBAER | Original post link

What configuration? Try adding some resources.

| username: tidb狂热爱好者 | Original post link

The original version was outdated, you should use 8.0 now.

| username: 呢莫不爱吃鱼 | Original post link

I suggest trying to increase the memory.

| username: 这里介绍不了我 | Original post link

How is the machine configuration for this monitoring service?

| username: TiDBer_QYr0vohO | Original post link

If you don’t have enough memory, just add more. It’s possible that your other monitoring items have already been cached into buff/cache, leaving no memory available when you check the CPU. If you want to verify this, you can clear the buff/cache and then check the CPU monitoring chart from 2 hours ago.

| username: shigp_TIDBER | Original post link

Try adding more memory.

| username: dba远航 | Original post link

It should be caused by insufficient memory.

| username: zhang_2023 | Original post link

Increase memory

| username: TiDBer_JUi6UvZm | Original post link

What is the configuration of the monitoring environment?

| username: 有猫万事足 | Original post link

Go into edit mode and check if the formula has been modified by someone else.
Editing formulas in Grafana is indeed very frustrating. Sometimes there are inexplicable encoding issues, resulting in invisible characters after editing, making it unusable.