We have around 18000 registered users, but max unique logins during a fortnight is close to 10000.
Specs:
webserver (~.LRN 1.0/OACS 4.6.3):
dual Xeon CPU 2.8 GHz, 3 GB RAM (dell 2650)
oracleserver (8.1.7.3):
dual Xeon CPU 2.8 GHz, 4 GB RAM (dell 2650)
(Both also has hyperthreading turned on and a dedicated 1 Gbit network between the two)
On heavy loads we find that it's the oracleserver that has the highest load. I'm wondering if the is anything more to gain by tweaking the aolserver-config:
ns_param maxconnections 50
ns_param maxdropped 0
ns_param maxthreads 50
ns_param minthreads 10
ns_param threadtimeout 120
...
ns_section ns/db/pool/pool1
ns_param connections 6
...
ns_section ns/db/pool/pool2
ns_param connections 16
...
ns_section ns/db/pool/pool3
ns_param connections 5
Some pics:
http://elg.uib.no/~edpck/logins-week.gif
http://elg.uib.no/~edpck/load-week.gif (green: webserver, blue: oracleserver)
All feedback appreciated
Cheers