[SR-Users] Database connection handles vs. processes

[Ovidiu Sas]

Try to map each connection to a process and then check which process has
extra connections and what type of process that is. It may shed some light
on this.

-ovidiu

On Jul 13, 2017 5:17 PM, "Alex Balashov" <abalashov at evaristesys.com> wrote:

> Hello,
>
> Sorry for the delay in following up on this.
>
> On Tue, Jul 11, 2017 at 09:20:23AM +0200, Daniel-Constantin Mierla wrote:
>
> > There are some rpc commands that open database connection, do the
> > operation, and then close it. Normally, it still should reuse an
> > existing connection, as the "open connection" should search for existing
> > one first.
>
> I do not think I am using any such RPC commands, however. I have a
> number of RPC commands that I run for routine monitoring and stats
> collection, but they all relate to dialogs, and I use runtime
> memory-only backing for that.
>
> > Can you see if all the connections are in open state or some are pending
> > close? Is the number of connections stable or fluctuates over the time?
>
> It appears to be a stable number and they are all established.
>
> > From your summary, I noticed that the tcp workers (which handle also
> > http) had two db connections, not sure it was only because of what you
> > selected to put in the mail or that's the rule.
>
> It does appear to be the rule, from a cursory examination.
>
> So, what I guess I am trying to figure out is whether this is normal,
> and what exactly is the driver of the greater-than-expected number of
> connections.
>
> -- Alex
>
> --
> Alex Balashov | Principal | Evariste Systems LLC
>
> Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
> Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20170713/b9edeae8/attachment.html>