hello all
I am loading the following 10 modules that use an oracle database
through unixodbc.
modparam("usrloc|acc", "db_url",
"unixodbc://user:pass@/OracleODBC-10g")
modparam("auth_db|alias_db|uri_db|group|permissions|lcr|domain",
"db_url", "unixodbc://user:pass@/OracleODBC-10g")
modparam("avpops", "avp_url",
"unixodbc://user:pass@/OracleODBC-10g")
In my config I have fork=yes and tcp is enabled
With 5 listen addresses and
children=1 : 10 connections in the database.
children=2 : 16 connections
children=3 : 22 connections
With 4 listen address and
children=1 : 9 connections in the database.
children=2 : 14 connections
children=3 : 19 connections
Could anyone help me understand the relation between listen addresses,
number of children and number of modules that use the db?
Also these numbers are the same whether I use MySQL both through the
mysql module and the unixodbc module. Looking into the code, it seems
like there is connection pooling into the unixodbc module. However I get
all these connections. What am I doing wrong?
thank you for any help
George
Disclaimer
The information in this e-mail and any attachments is confidential. It is intended solely
for the attention and use of the named addressee(s). If you are not the intended
recipient, or person responsible for delivering this information to the intended
recipient, please notify the sender immediately. Unless you are the intended recipient or
his/her representative you are not authorized to, and must not, read, copy, distribute,
use or retain this message or any part of it. E-mail transmission cannot be guaranteed to
be secure or error-free as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses.