<html><body><div>Thank you guys for your quick response.</div><div><br data-mce-bogus="1"></div><div>I am new to Kamailio so all your information are very helpful for me. </div><div><br data-mce-bogus="1"></div><div><strong>My setting:</strong> </div><div>children=8 in kaimailio.cfg . I did not change it and leave it by default on my 4 cores system. </div><div><br data-mce-bogus="1"></div><div><strong>My thought:</strong></div><div>I think it may related to Mysql since cpu and iowait is low and the problem happens only when I add more subscribers to mysql database.</div><div><br data-mce-bogus="1"></div><div>I will try according to :</div><div><br data-mce-bogus="1"></div><div>1: Dmitri combination of mysql and htable as mysql cache<br>2: Mathias tune MySQL server</div><div><br data-mce-bogus="1"></div><div>3: I think ram database should help on this. But it seems these is little document on redis.</div><div>I am looking into SQLite3 memory mode but if there is any related reference / link will be appreciated.</div><div><br data-mce-bogus="1"></div><div>Thanks with regards,</div><div>David</div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div class="x-apple-signature">David</div><div><br>2017年9月28日 下午02:59，Daniel-Constantin Mierla <miconda@gmail.com> 写道：<br><br></div><div><blockquote type="cite"><div class="msg-quote" 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"><div><strong>My goal:</strong></div><div><br></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/" data-mce-href="https://www.kamailio.org/w/features/">https://www.kamailio.org/w/features/</a> ></li></ul><div><br></div><div><strong>Test bed:</strong></div><div>CPU: 4 cores , 4G RAM</div><div><br></div><div>Kamailio 5 with Mysql. </div><div><br></div><div>Test source：another server running SIPp</div><div><br></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></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></div><div>(cpu are not used much at that time. IO is not high.)</div><div><br></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></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></div><div>Thanks with regards,</div><div>David</div><div><br></div><div><br></div><div><br></div></div><br><fieldset class="mimeAttachmentHeader"></fieldset><br><pre>_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org" data-mce-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" data-mce-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">--
Daniel-Constantin Mierla
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" data-mce-href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" data-mce-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" data-mce-href="http://www.asipto.com">www.asipto.com</a>
Kamailio World Conference - <a class="moz-txt-link-abbreviated" href="http://www.kamailioworld.com" data-mce-href="http://www.kamailioworld.com">www.kamailioworld.com</a></pre></div></blockquote></div></body></html>