Hello,

in this case there are 3 distinct connections per process, so you have to multiply the number of processes by 3 to get the overall number of connections. You can run 'kamctl ps' to see all the processes of a kamailio instance.

Actually a few kamailio processes may not open database connections, a matter of their purpose if they are created by specific modules, but for a rough upper limit, this is the formula.

Cheers,
Daniel

On 01.09.20 16:25, Ali Taher wrote:

Hi Daniel,

 

I meant that I’m defining 3 connection strings using sqlcon parameter of sqlops module as shown below:

 

modparam("sqlops","sqlcon","cb=>postgres://postgres:kamailio@localhost:5432/cataleya")

modparam("sqlops","sqlcon","mi=>postgres://postgres:kamailio@localhost:5432/cataleya_mitto")

modparam("sqlops","sqlcon","sp=>postgres://postgres:kamailio@localhost:5432/cataleya_spactron")

 

regards,

Ali Taher

 

From: Daniel-Constantin Mierla <miconda@gmail.com>
Sent: Tuesday, September 1, 2020 1:52 PM
To: Ali Taher <ataher@vanrise.com>; Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
Subject: Re: [SR-Users] worker processes

 

hello,

what do you mean by "3 connection strings"? Maybe you can give similar example here.

Cheers,
Daniel

On 01.09.20 12:33, Ali Taher wrote:

Thanks for your answer.

 

Please note that I have set 3 connection strings in SQLOPS module for 3 Postgres databases. How many connections per database does Kamailio open? (knowing that children=12 and only one listening interface).

 

Regards,

Ali Taher

 

From: Daniel-Constantin Mierla <miconda@gmail.com>
Sent: Tuesday, September 1, 2020 1:18 PM
To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>; Ali Taher <ataher@vanrise.com>
Subject: Re: [SR-Users] worker processes

 

Hello,

note that other processes are created by kamailio, not only sip worker processes. For example, there will be timer processes.

The dedicated worker processes are only for UDP sockets, not for tcp/tls (here is a single pool of workers for all tcp/tls sockets). If you do not receive traffic on a specific udp socket, then do not listen to it, you have a group of processes not doing anything. If you need to listen on a socket, but have less traffic (e.g., used for monitoring), then use workers parameter before listen, so you get less worker processes for that udp socket.

Cheers,
Daniel

On 01.09.20 12:03, Ali Taher wrote:

Hi,

 

I just want to ask regarding the children number and listening interfaces set in Kamailio configuration.

 

I am given to understand that the total number of worker processes there will be (children_setting * listeners) , so assuming I have set children=12 and listen=udp:172.16.1.12:5060 (which is the interface IP where the SIP packets as received), in this case there will be 12 worker processes and 12 database connections to postgresql (I’m using SQLOPS).

My question is if I set listen=udp:0.0.0.0:5060 , knowing that I have 3 interfaces, in this case the number of worker processes will be 36. Is this good configuration ? will the other 24 processes be used or they are reserved to the 2 other interfaces which are not receiving any SIP packets and then will be useless ?

 

Regards,

Ali Taher




_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Funding: https://www.paypal.me/dcmierla
-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Funding: https://www.paypal.me/dcmierla
-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Funding: https://www.paypal.me/dcmierla