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 <[email protected]> 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 > [email protected] > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users -- --Mojtaba Esfandiari.S _______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
