<div dir="ltr"><p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">Hi,</span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">We are deploying OpenSER in a large
infrastructure together with Asterisk to support thousands of current transactions.</span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">We are using udp listener and mysql module
in openser.</span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">We had to increase the children parameter
of the openser.cfg to 200 because Openser couldn't handle the high amount
of concurrent SIP REQUESTs from ASTERISK (Not only INVITES, but also a lot of SIP
OPTIONs), that means that Openser couldn't handle more than 'children'
REQUEST loosing the rest of the concurrent REQUEST.</span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">children=200 </span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">But then, the following error appeared in
the openser:</span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">ERROR:mysql:db_mysql_new_connection:
driver error: Too many connections</span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">This is because the Standard parameter of
mysql "max_connections" is set to 100.</span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">In mysql CLI, we can see that every child process
of openser has a mysql connection. (see in Mysql> SHOW PROCESSLIST)</span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">The recommended max_connections parameter
is 500-1000 => we have a limit of 500-1000 concurrent SIP REQUEST to be
processed by the openser.</span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">Why there is a process for every child?</span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">Why is neccesary a mysql connection for
every child?</span></font></p>
<font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">Can the openser have a pool of mysql
connection to be used by thousands of children?<br><br>Regards<br></span></font></div>