[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 Thu, Jul 13, 2017 at 5:16 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



-- 
VoIP Embedded, Inc.
http://www.voipembedded.com