#232 Look at upping the db connection limit for TG+SQLAlchemy apps
Closed: Fixed None Opened 16 years ago by toshio.

TG apps with SQLAlchemy have a configurable db connection limit. Smolt is currently hitting that limit which causes tracebacks. I've upped the limit from 10 to 21 which has removed the tracebacks for now. We should look at upping the limit for all our TG+SA apps; smolt is currently the one hit hardest by a low limit because of the combination of it getting so busy when we have a new release and a ton of new clients connect and its database is unoptimized.


These are the config parameters to change:

Initial number of idle db connections

sqlalchemy.pool_size=5

pool_size + max_overflow = maximum number of db connections to hold at a time

Bumped up from the default of 10

sqlalchemy.max_overflow=21

The packagedb is now running with these settings:
{{{
sqlalchemy.pool_size=5 # default
sqlalchemy.max_overflow=21 # Bumped up from 10
}}}

Noticed in the smolt logs that it's occassionally hitting the limit of 5 + 21 db connections. Try upping max_overflow a bit more on Monday.

smolt has been upped to
{{{
sqlalchemy.pool_size=5
sqlalchemy.max_overflow=27
}}}

I'll be watching as the clients start checking in tomorrow to see if there's any further problems with too few connection limits.

smolt currently looks fine. No evidence that the number of db connections is a current bottleneck.

Login to comment on this ticket.

Metadata