[SAC] [OSGeo] #2176: Trac database connections should be pooled

OSGeoTrac · June 26, 2018, 9:08am

#2176: Trac database connections should be pooled
--------------------+------------------
Reporter: strk | Owner: strk
Type: task | Status: new
Priority: normal | Milestone:
Component: Trac | Keywords:
--------------------+------------------
Right after starting PostgreSQL 200 connections get filled by Trac. We
want to use some database pooling instead.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2176>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.

OSGeoTrac · July 5, 2018, 10:28pm

Comment (by strk):

https://trac.edgewall.org/ticket/4347 may be related.
Right now I see 21 "idle" connections to the "trac_postgis" database and
124 idle connections in total to trac_X databases

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2176#comment:1>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.

OSGeoTrac · July 5, 2018, 10:34pm

Comment (by strk):

We could experiment with TRAC_DB_POOL_SIZE env variable (not sure how to
set in /etc/apache2/includes/trac_env.inc)

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2176#comment:2>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.

OSGeoTrac · July 5, 2018, 10:35pm

Comment (by strk):

was the limit in number of apache processes recently lifted btw ? By
TemporSent if I'm not mistaken ? As that'd probably increase the number of
connections too (pooling is per-process)

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2176#comment:3>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.