Re: [SR-Users] Database connection handles vs. processes

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 wrote: > Hello, > > Sorry for the delay in following up

Re: [SR-Users] Database connection handles vs. processes

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" wrote: > Hello, > > Sorry for the delay in following up on

Re: [SR-Users] Database connection handles vs. processes

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

Re: [SR-Users] Database connection handles vs. processes

On 11.07.17 09:13, Alex Balashov wrote: > On Tue, Jul 11, 2017 at 09:12:51AM +0200, Daniel-Constantin Mierla wrote: > >> Hello, >> >> >> On 11.07.17 08:49, Alex Balashov wrote: >>> On Tue, Jul 11, 2017 at 08:41:24AM +0200, Daniel-Constantin Mierla wrote: >>> are the connections to the same

Re: [SR-Users] Database connection handles vs. processes

No -- if the database url is the same, sqlops should reuse existing connections. Cheers, Daniel On 11.07.17 08:57, Alex Balashov wrote: > I do use sqlops extensively, both in the main processes and rtimer > processes. Does that make a difference? > > On Tue, Jul 11, 2017 at 02:49:19AM -0400,

Re: [SR-Users] Database connection handles vs. processes

On Tue, Jul 11, 2017 at 09:12:51AM +0200, Daniel-Constantin Mierla wrote: > Hello, > > > On 11.07.17 08:49, Alex Balashov wrote: > > On Tue, Jul 11, 2017 at 08:41:24AM +0200, Daniel-Constantin Mierla wrote: > > > >> are the connections to the same database or to different databases? Even > >>

Re: [SR-Users] Database connection handles vs. processes

Hello, On 11.07.17 08:49, Alex Balashov wrote: > On Tue, Jul 11, 2017 at 08:41:24AM +0200, Daniel-Constantin Mierla wrote: > >> are the connections to the same database or to different databases? Even >> on the same server, the database name matters. > Hi, > > Same database, same server, same

Re: [SR-Users] Database connection handles vs. processes

I do use sqlops extensively, both in the main processes and rtimer processes. Does that make a difference? On Tue, Jul 11, 2017 at 02:49:19AM -0400, Alex Balashov wrote: > On Tue, Jul 11, 2017 at 08:41:24AM +0200, Daniel-Constantin Mierla wrote: > > > are the connections to the same database or

Re: [SR-Users] Database connection handles vs. processes

On Tue, Jul 11, 2017 at 08:41:24AM +0200, Daniel-Constantin Mierla wrote: > are the connections to the same database or to different databases? Even > on the same server, the database name matters. Hi, Same database, same server, same database name. -- Alex Balashov | Principal | Evariste

Re: [SR-Users] Database connection handles vs. processes

Hello, are the connections to the same database or to different databases? Even on the same server, the database name matters. Cheers, Daniel On 10.07.17 22:23, Alex Balashov wrote: > Hi, > > By way of illustration, I have one server with children=8, a single UDP > listener, and 23 processes

Re: [SR-Users] Database connection handles vs. processes

On Mon, Jul 10, 2017 at 05:04:32PM -0400, E. Schmidbauer wrote: > some modules can have child processes that each maintain a database > connection. the number of child processes for a module can sometimes be set > using a modparam() for that module Well, indeed, and that is germane. However, it

Re: [SR-Users] Database connection handles vs. processes

some modules can have child processes that each maintain a database connection. the number of child processes for a module can sometimes be set using a modparam() for that module On Mon, Jul 10, 2017 at 4:23 PM, Alex Balashov wrote: > Hi, > > By way of illustration, I

[SR-Users] Database connection handles vs. processes

Hi, By way of illustration, I have one server with children=8, a single UDP listener, and 23 processes total: -- 21117 attendant 21118 udp receiver child=0 sock=xxx.xxx.xxx.xxx:5060 21119 udp receiver child=1 sock=xxx.xxx.xxx.xxx:5060 21120 udp receiver child=2 sock=xxx.xxx.xxx.xxx:5060