[SR-Users] database connections per child process

Mojtaba mespio at gmail.com
Thu Nov 22 11:16:48 CET 2018


Actually No.
Actually the connection to database is done in fork process. So if you
have two fork process with one sqlcon param, You'll have two TCP
connection.
If you add one another sqlcon param in modparam, you will have four
tcp connection. at finally you will have:
(Number_Of_Connection=Fork_no * sqlcon_no)
It is the concept of implementing Kamailio project. So if you want
another treatment in this regards, you have to change in PROC_INIT
process in child_init function.
With Regards.Mojtaba

On Thu, Nov 22, 2018 at 7:32 AM Karthik Srinivasan
<ksriniva2002 at gmail.com> wrote:
>
> Hello,
>
> Is there a formula/algorithm that determines how many TCP connections are made per child process to a database server defined by sqlops' sqlcon parameter?
>
> ex: if i have 1 database on a database server defined by sqlcon, and i have 1 UDP child process, i notice that the child process has made 2 TCP connections to the database server.
> ex: if i have 3 databases on the same database server defined by 3 sqlcon statements (1 pertaining to each database) and i have 4 UDP child processes, i notice that each child process makes 4 TCP connections to the database server.
> ex: if i have 3 databases on the same database server defined by 3 sqlcon statements (1 pertaining to each database) and i have 6 TCP child processes, i notice that each child process makes 4 TCP connections to the database server.
>
> Basically wanting to know what governs the number of tcp connections a child process makes to a particular database server.
>
> Thank you,
>
> Karthik
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users



-- 
--Mojtaba Esfandiari.S



More information about the sr-users mailing list