<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head><body dir="ltr"><table border="0" cellspacing="0" cellpadding="0"><tr><td><a href="https://www.bitco.co.za/business-broadband-fibre-fno/"><IMG border="0" alt="BitCo Business Broadband" src="cid:121060109263601157@za-mta-142.za.mimecast.lan" ></A></td></tr></table>
<br>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi Henning,</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);">
I have not, and this looks useful. Thank you for the response and the information!</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);">
Kind regards,</div>
<br>
<font style="font-family: Tahoma; font-size: 11pt; color: #1e35c7; text-decoration: none;">
<b> Stephen Lokker | BitCo Telecoms</b>
<br><font style="font-family: Tahoma; font-size: 10pt; color: #1f2021; text-decoration: none;">
<b>Voice Engineer</b>
<br>
<font style="font-family: Tahoma; font-size: 10pt; color: #1f2021; 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: #1f2021; text-decoration: none;">
Email: stephen.lokker@bitco.co.za</a>
<br><font style="font-family: Tahoma; font-size: 10pt; color: #1f2021; text-decoration: none;">
Telephone: 087 135 0000 | EXT: 2404
<br><font style="font-family: Tahoma; font-size: 10pt; color: #1f2021; text-decoration: none;">
Softphone Extension: 3468
<br>
<br>
<font style="font-family: Tahoma; font-size: 10pt; color: #1f2021; text-decoration: none;">
<table border="0" cellspacing="0" cellpadding="0"><tr><td><a href="http://www.bitco.co.za"><IMG border="0" alt="BitCo Telecoms" src="cid:121060109263601057@za-mta-142.za.mimecast.lan" ></A></td></tr></table>
<br>
<table border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
</tr>
</tbody></table>
<p style="font-family: Verdana; font-size:8pt; color:#000000;">
<b>Disclaimer</b></p>
<p style="font-family: Verdana; font-size:7pt; color:#000000;">
‘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>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Henning Westerholt <hw@skalatan.de><br>
<b>Sent:</b> Tuesday, 01 June 2021 08:22<br>
<b>To:</b> Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org><br>
<b>Cc:</b> Jordan Brimer <jordan.brimer@bitco.co.za>; Stephen Lokker <stephen.lokker@bitco.co.za><br>
<b>Subject:</b> RE: New MariaDB server "limiting" Kamailio CPS</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:Verdana}
@font-face
{font-family:Tahoma}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:blue;
text-decoration:underline}
span.x_E-MailFormatvorlage20
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:70.85pt 70.85pt 2.0cm 70.85pt}
div.x_WordSection1
{}
-->
</style>
<div lang="DE" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="x_WordSection1">
<p class="x_MsoNormal"><span style="">Hi Stephen,</span></p>
<p class="x_MsoNormal"><span style=""> </span></p>
<p class="x_MsoNormal"><span lang="EN-GB" style="">did you already tried to get some more details e.g. with:
<a href="https://www.kamailio.org/wiki/cookbooks/devel/core#latency_limit_db">https://www.kamailio.org/wiki/cookbooks/devel/core#latency_limit_db</a></span></p>
<p class="x_MsoNormal"><span lang="EN-GB" style=""> </span></p>
<p class="x_MsoNormal"><span lang="EN-GB" style="">Cheers,</span></p>
<p class="x_MsoNormal"><span lang="EN-GB" style=""> </span></p>
<p class="x_MsoNormal"><span lang="EN-GB" style="">Henning</span></p>
<p class="x_MsoNormal"><span lang="EN-GB" style=""> </span></p>
<div>
<p class="x_MsoNormal"><span lang="EN-GB" style="">-- </span></p>
<p class="x_MsoNormal"><span lang="EN-GB" style="">Henning Westerholt – </span><span style=""><a href="https://skalatan.de/blog"><span lang="EN-GB" style="color:#0563C1">https://skalatan.de/blog/</span></a></span><span lang="EN-GB" style=""></span></p>
<p class="x_MsoNormal"><span lang="EN-GB" style="">Kamailio services – </span><span style=""><a href="https://gilawa.com"><span lang="EN-GB" style="color:#0563C1">https://gilawa.com</span></a></span><span style="">
<span lang="EN-GB"></span></span></p>
</div>
<p class="x_MsoNormal"><span lang="EN-GB" style=""> </span></p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0cm 0cm 0cm">
<p class="x_MsoNormal" style="margin-left:35.4pt"><b>From:</b> sr-users <sr-users-bounces@lists.kamailio.org>
<b>On Behalf Of </b>Stephen Lokker<br>
<b>Sent:</b> Monday, May 31, 2021 2:32 PM<br>
<b>To:</b> sr-users@lists.kamailio.org<br>
<b>Cc:</b> Jordan Brimer <jordan.brimer@bitco.co.za><br>
<b>Subject:</b> [SR-Users] New MariaDB server "limiting" Kamailio CPS</p>
</div>
</div>
<p class="x_MsoNormal" style="margin-left:35.4pt"> </p>
<table class="x_MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="627" style="width:470.3pt; margin-left:35.4pt">
<tbody>
<tr>
<td style="padding:0cm 0cm 0cm 0cm">
<p class="x_MsoNormal"><a href="https://www.bitco.co.za/business-broadband-fibre-fno"><span style="text-decoration:none"><img border="0" width="650" height="150" id="x_Bild_x0020_1" alt="BitCo Business Broadband" style="width:6.7708in; height:1.5625in" data-outlook-trace="F:1|T:1" src="cid:image001.png@01D756BF.527CC590"></span></a></p>
</td>
</tr>
</tbody>
</table>
<p class="x_MsoNormal" style="margin-left:35.4pt"> </p>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black">Good afternoon All,</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black">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.</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black">Some info on the Kamialio and DB versions</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black">New DB</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black">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</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black">Old DB</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black">[root@isadb01 ~]# mysql --version<br>
mysql Ver 15.1 Distrib 10.0.36-MariaDB, for Linux (x86_64) using readline 5.1</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black">Kamailio SBC</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black">[root@sbc01 ~]# kamailio -v<br>
version: kamailio 5.1.4 (x86_64/linux)</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black">Kind regards,</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<p class="x_MsoNormal" style="margin-right:0cm; margin-bottom:12.0pt; margin-left:35.4pt">
<br>
<b><span style="font-family:"Tahoma",sans-serif; color:#1E35C7">Stephen Lokker | BitCo Telecoms</span></b><span style="font-family:"Tahoma",sans-serif; color:#1E35C7">
<br>
</span><b><span style="font-size:10.0pt; font-family:"Tahoma",sans-serif; color:#1F2021">Voice Engineer</span></b><span style="font-size:10.0pt; font-family:"Tahoma",sans-serif; color:#1F2021">
<br>
Website: <a href="http://www.bitco.co.za" target="_blank">
www.bitco.co.za</a> <br>
Email: <a href="mailto:stephen.lokker@bitco.co.za">stephen.lokker@bitco.co.za</a>
<br>
Telephone: 087 135 0000 | EXT: 2404 <br>
Softphone Extension: 3468 </span></p>
<table class="x_MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="margin-left:35.4pt">
<tbody>
<tr>
<td style="padding:0cm 0cm 0cm 0cm">
<p class="x_MsoNormal"><a href="http://www.bitco.co.za/"><span style="text-decoration:none"><img border="0" width="370" height="113" id="x_Bild_x0020_2" alt="BitCo Telecoms" style="width:3.8541in; height:1.177in" data-outlook-trace="F:1|T:1" src="cid:image002.png@01D756BF.527CC590"></span></a></p>
</td>
</tr>
</tbody>
</table>
<p class="x_MsoNormal" style="margin-left:35.4pt"><span style="font-size:10.0pt; font-family:"Tahoma",sans-serif; color:#1F2021"> </span></p>
<table class="x_MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="margin-left:35.4pt">
<tbody>
<tr>
<td style="padding:0cm 0cm 0cm 0cm"></td>
</tr>
</tbody>
</table>
<p style="margin-left:35.4pt"><b><span style="font-size:8.0pt; font-family:"Verdana",sans-serif; color:black">Disclaimer</span></b><span style="font-size:8.0pt; font-family:"Verdana",sans-serif; color:black"></span></p>
<p style="margin-left:35.4pt"><span style="font-size:7.0pt; font-family:"Verdana",sans-serif; color:black">‘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.’
</span></p>
<p class="x_MsoNormal" style="margin-right:0cm; margin-bottom:12.0pt; margin-left:35.4pt">
</p>
</div>
</div>
<br>
</font></font></font></font></font></font></font></body></html>