Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: TiDB从4.0版本升级到6.5.0版本为什么内存消耗增加1倍
[Test/Poc Environment] TiDB
[TiDB Version] 6.5.0
[Reproduction Path] Only installation and deployment, same business
[Encountered Problem: Phenomenon and Impact] Running version 6.5.0, with almost no business, memory increased by 1~2G compared to version 4.0
[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]
tikv 4.0.1 around 700M
tikv 6.5.0 around 1.6G
tidb-server 4.0.1 around 200M
tidb-server 6.5.0 around 600M
You can compare the parameter configurations.
Some parameter configurations will have their default values changed.
How should I put it, the higher the version of the app on your phone, the more features it will have, and the more memory it will occupy…
Do some parameter tuning.
Or, if conditions permit, upgrade the host.
The person above makes a good point, considering the increasing memory usage of WeChat.
The parameter configuration should basically remain unchanged. Most of the default configurations are used.
The default will also be increased, you can compare it.
The example above is pretty good, haha.
Is it only possible to see all default configurations in the documentation? Is there any way to view all default configurations?
This isn’t much higher either. You need to check the consumption when there is business activity.
You can use “show variable” and “show config” to check. By comparing the old and new settings, you can see the differences. At the same time, you can learn about the parameters by referring to the official documentation.
It is estimated that some new features are occupying memory. The main focus should be on whether there is an improvement in performance.
Only responsible for TiDB itself, not for hardware costs 
There will definitely be an increase in hardware overhead.
After running the business, there shouldn’t be too many queries.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
|
username: TiDBer_G64jJ9u8
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: