-
Notifications
You must be signed in to change notification settings - Fork 292
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Specified logical memory size #3188
Comments
This idea looks cool. We already have many configs related to memory, and will have more in the future. They are useful when one wants to control them precisely to suit different workloads. But are sometimes frustrated if I do not care about that. Those configs have default values, but absolute memory size can hardly be used in various environments. A more flexible way might be providing the default value in a relative way. E.g.: CacheA uses 10%, BufferB uses 25% etc. BTW, |
Can't we let users utilize the resource limitation mechanisms that come with the OS? I specifically asked the PR author to make |
Keep it closed until a better idea comes up. |
Can we obtain a logical memory size here, which should be smaller than the system memory.
Consider the following scenario:
The user deploys our DB on a machine with a large amount of memory, and this machine is also running other processes.
They want our DB to occupy less memory. It would be better if we can provide a parameter to specify the memory size, for example, by specifying it through startup parameters.
Then in the
get_sys_total_memory
method, we return the minimum value between it andsys_total_memory
:Min(logical_total_memory, sys_total_memory)
.The same idea for the
get_cpus()
Originally posted by @fengjiachun in #3165 (comment)
The text was updated successfully, but these errors were encountered: