<div dir="ltr">Did you check the max_connections in mysql?<div><br><div><a href="https://mariadb.com/docs/reference/mdb/system-variables/max_user_connections/">https://mariadb.com/docs/reference/mdb/system-variables/max_user_connections/</a></div><div>and</div><div><a href="https://mariadb.com/docs/reference/mdb/system-variables/max_connections/">https://mariadb.com/docs/reference/mdb/system-variables/max_connections/</a><br></div><div><br></div><div>Also, what are you doing with the db? how are your modules configured?</div><div><br></div><div><br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div>Regards,</div><div><br></div>David Villasmil<div>email: <a href="mailto:david.villasmil.work@gmail.com" target="_blank">david.villasmil.work@gmail.com</a></div><div>phone: +34669448337</div></div></div></div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, May 31, 2021 at 7:20 PM Stephen Lokker <<a href="mailto:stephen.lokker@bitco.co.za">stephen.lokker@bitco.co.za</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr"><table border="0" cellspacing="0" cellpadding="0"><tbody><tr><td><a href="https://www.bitco.co.za/business-broadband-fibre-fno/" target="_blank"><img border="0" alt="BitCo Business Broadband" src="cid:179c3b8931a2c91aec2"></a></td></tr></tbody></table>
<br>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Good afternoon All,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Im hoping for some advise or direction with the below. We are running a Kamailio SBC used for high call volumes and recently decided to upgrade the Database servers as the existing servers were struggling. Both the old and new databases are using MariaDB(version
details all below), the problem we face is that since migrating to the new database there appears to a limitation to the amount of DB connections that can be processed or accepted. The SBC functions normally until the CPS starts to exceed around 100cps at
which point the SBC stops responding to invites(in bursts which resembles flood prevention). We have checked both the Kamailio logs and the MySQL logs on the DB, both log files have no indication of errors that would cause the problem experienced(the logs
attached are seen when the SBC is cut back to use the old DB, not sure they are related to the fault), the connections/processes in mysql do not drastically increase or get stuck either. The fault points to a db connection limit of some kind but all users
have no limitations set. If anyone has experienced a similar problem or has any advise it would be greatly appreciated.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Some info on the Kamialio and DB versions</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
New DB</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
root@voice-jhb-db01:~# mysql --version<br>
mysql Ver 15.1 Distrib 10.3.27-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Old DB</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
[root@isadb01 ~]# mysql --version<br>
mysql Ver 15.1 Distrib 10.0.36-MariaDB, for Linux (x86_64) using readline 5.1<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Kamailio SBC</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
[root@sbc01 ~]# kamailio -v<br>
<span>version: kamailio 5.1.4 (x86_64/linux)</span><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span>Kind regards,</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<br>
<font style="font-family:Tahoma;font-size:11pt;color:rgb(30,53,199);text-decoration:none">
<b> Stephen Lokker | BitCo Telecoms</b>
<br><font style="font-family:Tahoma;font-size:10pt;color:rgb(31,32,33);text-decoration:none">
<b>Voice Engineer</b>
<br>
<font style="font-family:Tahoma;font-size:10pt;color:rgb(31,32,33);text-decoration:none">
Website: <a href="http://www.bitco.co.za" style="font-family:Tahoma;font-size:10pt" target="_blank">www.bitco.co.za</a>
<br> <font style="font-family:Tahoma;font-size:10pt;color:rgb(31,32,33);text-decoration:none">
Email: <a href="mailto:stephen.lokker@bitco.co.za" target="_blank">stephen.lokker@bitco.co.za</a>
<br><font style="font-family:Tahoma;font-size:10pt;color:rgb(31,32,33);text-decoration:none">
Telephone: 087 135 0000 | EXT: 2404
<br><font style="font-family:Tahoma;font-size:10pt;color:rgb(31,32,33);text-decoration:none">
Softphone Extension: 3468
<br>
<br>
<font style="font-family:Tahoma;font-size:10pt;color:rgb(31,32,33);text-decoration:none">
<table border="0" cellspacing="0" cellpadding="0"><tbody><tr><td><a href="http://www.bitco.co.za" target="_blank"><img border="0" alt="BitCo Telecoms" src="cid:179c3b8931a2bb036b1"></a></td></tr></tbody></table>
<br>
<table border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
</tr>
</tbody></table>
<p style="font-family:Verdana;font-size:8pt;color:rgb(0,0,0)">
<b>Disclaimer</b></p>
<p style="font-family:Verdana;font-size:7pt;color:rgb(0,0,0)">
‘This communication contains confidential information. All information contained in this email remains the intellectual property of BitCo and may not be used for any purpose or made available to any third party without the express written permission of an authorised BitCo representative.’
</p><p></p>
<br>
<br>
</font></font></font></font></font></font></font></div>
__________________________________________________________<br>
Kamailio - Users Mailing List - Non Commercial Discussions<br>
* <a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
Important: keep the mailing list in the recipients, do not reply only to the sender!<br>
Edit mailing list options or unsubscribe:<br>
* <a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote></div>