Opened 6 years ago

Last modified 6 years ago

#2176 new task

Trac database connections should be pooled

Reported by: strk Owned by: strk
Priority: normal Milestone:
Component: SysAdmin/Trac Keywords:
Cc:

Description

Right after starting PostgreSQL 200 connections get filled by Trac. We want to use some database pooling instead.

Change History (3)

comment:1 by strk, 6 years ago

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

comment:2 by strk, 6 years ago

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

comment:3 by strk, 6 years ago

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)

Note: See TracTickets for help on using tickets.