Recommendations for using system memory

To regulate memory consumption when creating a storage on systems with limited memory, we recommend determining the current memory usage and increasing the max_server_memory_usage value. This setting determines the maximum amount of memory that the server can use. This value is specified in bytes.

By default, max_server_memory_usage is set to 0, which allows the server to use all available memory.

The max_server_memory_usage value is usually further limited by the max_server_memory_usage_to_ram_ratio value (the maximum amount of memory that a server can use as a ratio to all available memory). For example, the default value of 0.9 means that the server can consume 90% of the available memory.

When determining the current memory usage, keep in mind the following limitations:

Page top