Help Center/
MapReduce Service/
Component Operation Guide (LTS)/
Using ClickHouse/
ClickHouse Multi-Tenancy/
Modifying the Memory Limit of ClickHouse on a ClickHouseServer Node
Updated on 2024-05-29 GMT+08:00
Modifying the Memory Limit of ClickHouse on a ClickHouseServer Node
![](https://support.huaweicloud.com/intl/en-us/cmpntguide-lts-mrs/public_sys-resources/note_3.0-en-us.png)
This section applies only to MRS 3.2.0 or later.
Scenario
Modify the maximum memory allowed for ClickHouse on a ClickHouseServer node to ensure the normal use of other service instances on the node.
Procedure
- Log in to FusionInsight Manager and choose Cluster > Services > ClickHouse. Click Configuration then All Configurations, click ClickHouseServer(Role), and select Performance.
- Change the value of max_server_memory_usage_to_ram_ratio as required and save the configuration.
- Restart is not required for the modification to take effect.
- The value ranges from 0 to 1, indicating the ratio of the total physical RAM of the server that can be used for ClickHouse. For example, if the physical memory of the server is 10 GB and the value of this parameter is 0.9, the available memory of the ClickHouse service on the current server is 9 GB (10 GB x 0.9). If the value of this parameter is 0, it indicates that the memory is not limited and the ClickHouse service can use all the physical memory of the server. The value of this parameter can contain a maximum of two decimal places.
Parent topic: ClickHouse Multi-Tenancy
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot