Optimize la value of pool in database.yml

Rails
1

Hi,
I would like to understand how to calculate optimal value for “pool”
parameter in database.yml

I’m using rails 3, ruby 2, postgres, elasticsearch, unicorn, nginx

My server : 12 coeurs 24 threads ( I dont know if it is necessary for
define pool value)
unicorn : worker_processes 24
I have around 1500 pages requested per minutes, and around 200ms per
request

Is it also useful/necessary to use this ?
allow_concurrency: true

thanks

2

thanks for answer

3

On Sunday, October 20, 2013 11:14:40 PM UTC+1, Oto Iashvili wrote:

Hi,
I would like to understand how to calculate optimal value for “pool”
parameter in database.yml

I’m using rails 3, ruby 2, postgres, elasticsearch, unicorn, nginx

My server : 12 coeurs 24 threads ( I dont know if it is necessary for

define pool value)
unicorn : worker_processes 24
I have around 1500 pages requested per minutes, and around 200ms per
request

Unicorn only dispatches one request at a time to each worker, so the
pool
setting doesn’t matter: each worker will only process one request at a
time

Your numbers suggest you can do 5 requests per second per worker, ie 300
per minute per worker, so it seems that you have ample resources.
However
you’ll probably need to do some testing to confirm this as it would only
be
true if CPU is your bottleneck (as opposed to database concurrency for
example)

Is it also useful/necessary to use this ?
allow_concurrency: true

not sure what that is without some context.

Fred