How to Optimize a TiDB Cluster? High Memory and CPU Usage

Translated
1

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

Original topic: 请问TiDB集群如何进行优化？内存和cpu占比很高，

| username: TiDBer_vJpITQ5J

How can I optimize a TiDB cluster? The memory and CPU usage are very high. The cluster is set up on an 8-core, 60GB Linux server.

2
| username: Billmay表妹 | Original post link

Refer to this~

3
| username: TiDBer_vJpITQ5J | Original post link

Still don’t understand the meaning.

4
| username: xiaohetao | Original post link

Which components have high memory and CPU usage?

5
| username: xiaohetao | Original post link

Is the resource usage consistently high or only high during certain periods? If it suddenly spikes, troubleshoot as follows:

  1. Check for slow SQL queries;
  2. Large transactions;
  3. Large result sets;

If the usage is consistently high and stable:
It is likely due to overall resource insufficiency.

  1. Expand resources;
  2. If you don’t want to expand resources but want to lower the resource usage, adjust the relevant resource configuration parameters.

Specific parameter adjustments: Based on the components with high resource usage and the current resource configuration.

6
| username: dbsid | Original post link

If convenient, you can use the clinic service to upload monitoring information, which can help with diagnosis.

7
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.