1 Sep
2020
1 Sep
'20
7:08 p.m.
Hi Daniel,
So in my case :
* Server vcpus = 24
* Max_worker_processes in postgres = 24
* Max_parallel_workers in postgres = 24
* Children in Kamailio config = 12
* 1 udp listener
I noticed that there is 48 database connections established by Kamailio (16 x 3) , can
this cause an issue knowing that maximum worker processes is 24 ?
Regards,
Ali Taher
From: Daniel-Constantin Mierla <miconda(a)gmail.com>
Sent: Tuesday, September 1, 2020 6:48 PM
To: Ali Taher <ataher(a)vanrise.com>om>; Kamailio (SER) - Users Mailing List
<sr-users(a)lists.kamailio.org>
Subject: Re: [SR-Users] worker processes
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><mailto:miconda@gmail.com>
Sent: Tuesday, September 1, 2020 1:52 PM
To: Ali Taher <ataher@vanrise.com><mailto:ataher@vanrise.com>; Kamailio (SER)
- Users Mailing List
<sr-users@lists.kamailio.org><mailto: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><mailto:miconda@gmail.com>
Sent: Tuesday, September 1, 2020 1:18 PM
To: Kamailio (SER) - Users Mailing List
<sr-users@lists.kamailio.org><mailto:sr-users@lists.kamailio.org>; Ali Taher
<ataher@vanrise.com><mailto: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<mailto:sr-users@lists.kamailio.org>
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla -- www.asipto.com<http://www.asipto.com>
www.twitter.com/miconda<http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda<http://www.linkedin.com/in/miconda>
Funding: https://www.paypal.me/dcmierla
--
Daniel-Constantin Mierla -- www.asipto.com<http://www.asipto.com>
www.twitter.com/miconda<http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda<http://www.linkedin.com/in/miconda>
Funding: https://www.paypal.me/dcmierla
--
Daniel-Constantin Mierla -- www.asipto.com<http://www.asipto.com>
www.twitter.com/miconda<http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda<http://www.linkedin.com/in/miconda>
Funding: https://www.paypal.me/dcmierla