Unicorn do not close DB connections

Question

I am using rails 3.2 + unicorn + postgres DB and i have a question - how does unicorn handle DB connections ?

How I understand:

unicorn master process forks X child process.
each child process setup DB connection– close in before_fork, establish connection in after_fork.
we use connection per process(if we use rails DB connection pooling, we create Y(from database.yml) DB connections per process) - i.e. If process is working(It always works until we not kill it) we keep connection opened and every web request use the same connection(that was opened in after_fork).
opened connections will be shown in postgres(or any other DB) as idle or active.

Is it correct or I missed something ?

score 8 · Answer 1 · answered Mar 28 '13 at 10:03

8

Yes you are right. If you set "worker_processes 5" in unicorn.conf, and "pool: 4" in database.yml, will be create d 20 connections to database.

answered Mar 28 '13 at 10:03

Alexander Randa

score 3 · Answer 2 · answered Mar 28 '13 at 14:33

3

i wrote to Eric Wong he is founder of unicorn gem, he confirmed that it's correct.

answered Mar 28 '13 at 14:33

Dzmitry

2 Answers2