Kbase P17068: How to tune database sessions and servers with -Mn, -Ma, -Mi, -n
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/07/2008 |
|
Status: Verified
GOAL:
An Example of how all the "-Mn", "-Ma", "-Mi" and "-n" are used with each other
GOAL:
Tuning with -Mn, -Ma, -Mi and -n parameters
GOAL:
Example of how all the "-Mn", "-Ma", "-Mi" and "-n" are used with each other
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
The parameters that impact the number of sessions are the following:
"-n" Parameter: Sets the maximum numbers of remote and local users connected to the database.
"-Mi" Parameter: Sets the number of connections that are to be connected to one server before spawning another server.
"-Mn" Parameter: Sets the number of servers to be started.
"-Ma" Parameter: Sets the number of users that can be connected to each server.
"-Mpb" Parameter: Sets the maximum number of servers that each broker can spawn.
When running, the database will increase the count of sessions for:
- each process connected to shared memory:
- 1 per remote server
- 1 per auxiliary process (page writer -- biw / apw -- and watchdog)
- 1 per self-service client
- 1 for the broker processes (1 for the main broker + 1 per additional broker)
- each remote client connected to a server.
Which means that the value for -n should be set as follows: (value of -Ma x -Mn) + (value of -Mn) + (number of auxiliary processes) + (number of broker(s)) + (expected number of self-service clients)
Example settings
In this example assume that 40 users are needed and 8 extra connections are given for promon and other background processes like the Watchdog, the Asynchronous Page Writers, etc.
proserve sports2000 -S prosv00 -Mi 3 -Ma 4 -Mn 13 -n 60
The sports2000 should be replaced with the dbname, prosv00 replaced with the correct port number or service name for remote connections. When using multiple brokers, the count of servers (-Mn) can be split across brokers using -Mpb:
proserve sports2000 -S prosv00 -n 60 -Mn 13 -Mi 4 -Mpb 6
proserve sports2000 -m3 -S prosv01 -Mi 4 -Mpb 6
The "-Mpb" setting of 6 for each broker allows each port to spawn a maximum of 6 servers each. -Mn is set to the total number of remote servers that can be spawned [6 for the primary broker + 6 for the secondary broker + 1 for the secondary login broker since each secondary login is counted as a server = 13].