<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>it seems that interaction with mysql is a bottleneck. What is the
value of children parameter in kamailio.cfg?</p>
<p>Cheers,<br>
Daniel<br>
</p>
<br>
<div class="moz-cite-prefix">On 28.09.17 04:00, Jiankai Zhu wrote:<br>
</div>
<blockquote type="cite"
cite="mid:f238679b-3261-463b-b55b-9a18944ac37a@me.com">
<div><strong>My goal:</strong></div>
<div><br data-mce-bogus="1">
</div>
<div>make sure when using kamailio as engine I can achieve:</div>
<div>
<ul style="box-sizing: border-box; margin: 16px 0px; padding:
0px 0px 0px 40px; list-style-type: square; color: #575757;
font-family: 'Open Sans', Helvetica, sans-serif; font-size:
14px; font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: 2; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px;
background-color: #ffffff; text-decoration-style: initial;
text-decoration-color: initial;" data-mce-style="box-sizing:
border-box; margin: 16px 0px; padding: 0px 0px 0px 40px;
list-style-type: square; color: #575757; font-family: 'Open
Sans', Helvetica, sans-serif; font-size: 14px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; font-weight: normal; letter-spacing: normal; orphans:
2; text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: #ffffff;
text-decoration-style: initial; text-decoration-color:
initial;">
<li style="box-sizing: border-box;"
data-mce-style="box-sizing: border-box;">on systems with 4GB
memory, Kamailio can serve a population over 300 000 online
subscribers</li>
<li style="box-sizing: border-box;"
data-mce-style="box-sizing: border-box;"><from:
<a class="moz-txt-link-freetext" href="https://www.kamailio.org/w/features/">https://www.kamailio.org/w/features/</a> ></li>
</ul>
<div><br data-mce-bogus="1">
</div>
<div><strong>Test bed:</strong></div>
<div>CPU: 4 cores , 4G RAM</div>
<div><br data-mce-bogus="1">
</div>
<div>Kamailio 5 with Mysql. </div>
<div><br>
</div>
<div>Test source：another server running SIPp</div>
<div><br data-mce-bogus="1">
</div>
<div>10k subscriber in Mysql . 6000 Register Per Second ,
reuse 10k user to register , it works fine. If register 50
every second for per user it seem 300 k subscribers should
work. </div>
<div>(about 300% cpu used of totally 400% cpu. All requests
finished without retransmit and fail. )</div>
<div><br data-mce-bogus="1">
</div>
<div>add 90k subscriber into Mysql .</div>
<div>100k subscirbers in Mysql . 1000 Register Per Second , a
lot of failure and can not work . </div>
<div><br data-mce-bogus="1">
</div>
<div>(cpu are not used much at that time. IO is not high.)</div>
<div><br data-mce-bogus="1">
</div>
<div><strong>My question : </strong></div>
<div>What is the root cause of bad performance when there is
100k subscribers' data in the Mysql database. </div>
<div><br data-mce-bogus="1">
</div>
<div>How can I deploy a kamailio with 300k subscriber in
database, and support 6000 register per second at the same
time ?</div>
<div>Maybe use ram database instead of Mysql? </div>
<div><br data-mce-bogus="1">
</div>
<div>Thanks with regards,</div>
<div>David</div>
<div><br>
</div>
<div><br data-mce-bogus="1">
</div>
<div><br data-mce-bogus="1">
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training - <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
Kamailio World Conference - <a class="moz-txt-link-abbreviated" href="http://www.kamailioworld.com">www.kamailioworld.com</a></pre>
</body>
</html>