Kbase P11561: What is the optimal value for the -Mn database startup parameter?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
GOAL:
What is the optimal value for the -Mn database startup parameter?
FACT(s) (Environment):
UNIX
Windows
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
There is no specific answer to this question.
In terms of memory allocation one might say the more server processes, the more memory you'll need.
In terms of performance, it's recommended that you test your client/server configuration. Often it is thought that the more traffic a machine has, you should be considering less clients/server. For example, if you have the following settings:
-Mn 5
-Ma 100
This means 100 clients will being hosted be each server process. This can be somewhat high, especially when there is a lot of traffic on the server.
However, a combination such as:
-Mn 50
-Ma 10
might lead to better performance on this same server.
Please be aware that this is a general guideline. Each Progress database should be tested on their respective host servers to be sure they are taking advantage of the respective server's available resources.