On 2006.02.03, Nima <[EMAIL PROTECTED]> wrote: > > What basically happens is that once I have more than 150 users logged in > the response time for a page takes a minute or more which is very > frustrating for users. [...] > We have three linux boxes. One for an aolserver with database connection, > one for a static aolserver and one for the database. > > The database box never goes above 5-10%. The static server is also not > very busy but the dynamic server can go upt to 99% and a load of 10 and > more. [...]
Sounds like you already answered your question: you need more dynamic servers and do load balancing across them. > AOLServer config.tcl > ... > ns_section ns/server/${server} > ns_param directoryfile $directoryfile > ns_param pageroot $pageroot > ns_param maxconnections 100 > ns_param keepalivetimeout 15 > ns_param maxdropped 0 > ns_param maxthreads 65 > ns_param minthreads 65 > ns_param threadtimeout 3600 If you have 150 concurrent users, maxconnections = 100 could be a factor. maxthreads = 65 ... do you have that many concurrent connections? I'd suggest raising maxconnections to, say, 500 (just to rule that out entirely) and observe the effects. I might raise maxthreads to 120, too. Of course, all of this tweaking and tuning won't have as much impact as actually optimizing your application code. Unfortunately, I'm not very familiar with dotlrn or OpenACS to be able to speak to specific things you should look at. Maybe someone else can speak up about those things? > ns_section ns/db/pool/pool1 > ... > ns_param connections 100 > ... > > ns_section ns/db/pool/pool2 > ... > ns_param connections 60 > ... > > ns_section ns/db/pool/pool3 > ... > ns_param connections 30 > ... Do you have any kind of statistics from the DB side? What's the max number of concurrent connections you've actually seen, according to the DB? -- Dossy -- Dossy Shiobara | [EMAIL PROTECTED] | http://dossy.org/ Panoptic Computer Network | http://panoptic.com/ "He realized the fastest way to change is to laugh at your own folly -- then you can let go and quickly move on." (p. 70) -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.