<div dir="ltr"><div>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 0pt" class="MsoNormal"><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:12pt">Hi,</span></p>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 0pt" class="MsoNormal"><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:12pt"> </span></p>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt" class="MsoNormal"><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:12pt">I made these kinds of tests before. I have two tips for you to pay attention to:</span></p>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt 36pt" class="MsoListParagraphCxSpFirst"><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:12pt"><span style>1.<span style="FONT:7pt 'Times New Roman'"> </span></span></span><span dir="ltr"></span><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:12pt">Read about the [routes] on SIPp, It is tricky to satisfy kamailio with SIPp scenarios.</span></p>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt 36pt" class="MsoListParagraphCxSpLast"><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:12pt"><span style>2.<span style="FONT:7pt 'Times New Roman'"> </span></span></span><span dir="ltr"></span><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:12pt">Make sure your DB table is well build (use less varchars and more integers).</span></p>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt" class="MsoNormal"><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:12pt">I found out that there are many kamailio modules I can use to load data in to memory and I hardly use the DB (only for ACC). I use MTREE, HTABLE, DIALPLAN, CARRIERROUTE, DROUTING, and so to store the information I need. And I get it with the simple functions of the module.</span></p>
<p style="LINE-HEIGHT:normal;MARGIN:0cm 0cm 6pt" class="MsoNormal"><span style="FONT-FAMILY:'Times New Roman','serif';FONT-SIZE:12pt">I load around 6 million numbers and other data which takes about 1.5 Gb of the memory. </span></p>
<p style="MARGIN:0cm 0cm 10pt" class="MsoNormal"><font size="3"><font face="Calibri">For getting around the real-time changes that I need to deal with (In DB the data changes are immediately made on your service…). I have a RTIMER every 120 sec that check is a reload is needed. If so, it reloads the relevant data (very fast).</font></font></p>
<p style="MARGIN:0cm 0cm 10pt" class="MsoNormal"><font size="3"><font face="Calibri">BR,</font></font></p>
<p style="MARGIN:0cm 0cm 10pt" class="MsoNormal"><font size="3"><font face="Calibri">Uri</font></font></p>
<p style="MARGIN:0cm 0cm 10pt" class="MsoNormal"><font size="3"><font face="Calibri"></font></font> </p>
<p style="MARGIN:0cm 0cm 10pt" class="MsoNormal"><font size="3"><font face="Calibri"></font></font> </p></div>
<div>Hello,<br><br>On 3/20/12 12:12 PM, Stephen Dodge (Bistech) wrote:<br>><i><br></i>><i> Hello,<br></i>><i><br></i>><i> I am running Kamailio 3.1.5 with a MySQL backend on CentOS. A <br></i>><i> connection to MySQL (an off box MySQL cluster) is required for every <br>
</i>><i> call, sqlops is used to determine destinations and acc to record CDR </i></div>><i> information.<br></i>><i><br></i>><i> I am planning to load test our server using SIPp to generate calls, I <br></i>><i> was wondering if anyone has done something similar and could provide <br>
</i>><i> advice on what we should monitor on our Kamailio Server. i.e Server <br></i>><i> CPU & Memory<br></i>><i><br></i>><i> Thanks in advance for your help.<br></i>><i><br></i>if you do a lot of direct DB interactions, perhaps latency of the <br>
queries will be relevant. You can use benchmark module to see how long <br>it takes to execute part of the config file.<br><br>I think you don't fetch lot of records from db in config, so memory <br>should be no problem, however you can dump private/shared memory usage <br>
via RPC commands within sercmd cli. CPU is a good metric always and easy <br>to watch with systems tools.<br><br>Cheers,<br>Daniel<br>><i><br></i>><i> Steve.<br></i></div>