Forum OpenACS Development: Re: NaviServer "breaks" under high load

Collapse
9: Re: NaviServer "breaks" under high load (response to 8)
Posted by Frank Bergmann on 09/28/18 11:50 AM
Hi Gustaf,

urgency

My last set of changes seemed to have worked, but the problems re-surfaced.

nsstats.tcl

Do I have any other option in order to get statistics on the DB-pools?

Yesterday I have increased DB-connections:

In the config.tcl (8 physical cores):

maxconnections 200
maxthreads 32
minthreads 32
connsperthread 10000
highwatermark 100

Pool1:
connections 200

Pool2:
connections 20

Pool3:
connections 20

So again, the server seems to be running fine today.

Thanks for you help!
Frank

Collapse
10: Re: NaviServer "breaks" under high load (response to 9)
Posted by Gustaf Neumann on 09/28/18 02:01 PM
some feedback to suggestions is anticipated.

other option in order to get statistics on the DB-pools?

according to the NEWS file of NaviServer "ns_db stats" was introduced in NaviServer 4.99.9 (jan 2016)