|
Home > Archive > AOL Webserver > December 2005 > Performance-Problems
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Performance-Problems
|
|
| Nima Mazloumi 2005-12-24, 5:48 pm |
| Hi Dani=EBl,
please find below my postgres settings in the config.tcl.
Also I forgot to mention that for outgoing requests from the
nsd we use a proxy:
ns_param proxy www-cache.uni-mannheim.de
ns_param proxy_port 3128
ns_param stacksize [expr 256*1024] ;# Per-thread stack size for hungry C=20
modules. Increased to 256 for PHP.
Where do I find information about :
- performance mode
- memoize cache size
Greetings,
Nima
ns_section ns/db/pools
ns_param pool1 "Pool 1" ;# main
ns_param pool2 "Pool 2" ;# subqueries
ns_param pool3 "Pool 3" ;# log
ns_section ns/db/pool/pool1
ns_param maxidle 1000000000
ns_param maxopen 1000000000
ns_param connections 24
ns_param verbose $debug
ns_param extendedtableinfo true
ns_param logsqlerrors $debug
if { $database =3D=3D "oracle" } {
ns_param driver ora8
ns_param datasource {}
ns_param user $db_name
ns_param password $db_password
} else {
ns_param driver postgres
ns_param datasource ${db_host}:${db_port}:${db_name}
ns_param user $db_user
ns_param password ""
}
ns_section ns/db/pool/pool2
ns_param maxidle 1000000000
ns_param maxopen 1000000000
ns_param connections 24
ns_param verbose $debug
ns_param extendedtableinfo true
ns_param logsqlerrors $debug
if { $database =3D=3D "oracle" } {
ns_param driver ora8
ns_param datasource {}
ns_param user $db_name
ns_param password $db_password
} else {
ns_param driver postgres
ns_param datasource ${db_host}:${db_port}:${db_name}
ns_param user $db_user
ns_param password ""
}
ns_section ns/db/pool/pool3
ns_param maxidle 1000000000
ns_param maxopen 1000000000
ns_param connections 4
ns_param verbose $debug
ns_param extendedtableinfo true
ns_param logsqlerrors $debug
if { $database =3D=3D "oracle" } {
ns_param driver ora8
ns_param datasource {}
ns_param user $db_name
ns_param password $db_password
} else {
ns_param driver postgres
ns_param datasource ${db_host}:${db_port}:${db_name}
ns_param user $db_user
ns_param password ""
}
ns_section ns/server/${server}/db
ns_param pools "*"
ns_param defaultpool pool1
| |
| Don Baccus 2005-12-24, 5:48 pm |
| On Thursday 20 October 2005 09:03 am, you wrote:
> ns_section ns/db/pool/pool1
> ns_param maxidle 1000000000
> ns_param maxopen 1000000000
> ns_param connections 24
Didn't you have more than 24 aolserver connections in your snapshot? (sorry,
I wasn't paying close attention).
If so then threads will wait for DB connections whenever there are more than
24 AOLserver threads trying to access the DB. Given that .LRN accesses the
DB a whole bunch things will wait often.
--
Don Baccus
Portland, OR
http://donb.furfly.net, http://birdnotes.net, http://openacs.org
|
|
|
|
|