[pgpool-general: 3202] Re: making sense of the output of "show pool_pools"

Kent Tong kent.tong.mo at gmail.com
Thu Sep 25 18:59:00 JST 2014


Hi Yaron,

Thanks for the clear explanation! Is there any way to find the number of
current connections from pgpool clients?

On Thu, Sep 25, 2014 at 5:43 PM, Yaron Naveh <yaronn01 at gmail.com> wrote:

> Hi Kent
>
> The documentation was updated today (as least in source) to reflect that
> if you have multiple backends then the number of entries will
> be num_init_children*max_pools*num_backends. You probably have 2 backends
> which can be reflected with the backend_id field in pool_pools.
>
> If you have one backend then yes, a pool is a single connection that gets
> reused. So you have exactly num_init_children child processes each
> containing up to max_pool pools (=connections), each one to a different
> db/user combination. If you have multiple backends then each pool will
> contain one connection per backend (for the same db/user combination).
>
> Thanks,
> Yaron
>
> On Thu, Sep 25, 2014 at 12:18 PM, Kent Tong <kent.tong.mo at gmail.com>
> wrote:
>
>> Hi,
>>
>> How to interpret the output of "show pool_pools"? What is a "pool"
>> anyway? Is it a single connection that gets reused? My num_init_children is
>> 50 and max_pool lines is 4, the doc says that it will list 200 entries but
>> 400 were listed. Why? In particular, I found entries with identical
>> pool_pid+pool_id.
>>
>> Thanks in advance!
>>
>> --
>> Kent Tong
>> IT author and consultant, child education coach
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>>
>
>
> --
>
> I'm on Twitter (@YaronNaveh <http://twitter.com/#!/YaronNaveh>)
>



-- 
Kent Tong
IT author and consultant, child education coach
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140925/00166193/attachment.html>


More information about the pgpool-general mailing list