<html><body><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: https://www.kamailio.org/w/features/ ></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></body></html>