<div dir="ltr"><div class="gmail_quote">
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">
<div dir="ltr">
<div> </div>
<div>>How do you reload your htable? Is it using the exec( ) function to call the<br>>mi command sht_reload? Or do you have another method?</div>
<div> </div>
<div>I use the exec() to run a shell script with the relevant mi command. the shell script return code is used to make sure all went OK.</div>
<div><br>>Thanks<br><br>>Reda<br><br><br><br>On Mon, Mar 26, 2012 at 14:56, Uri Shacked <<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">ushacked at gmail.com</a>> wrote:<br>
<br>><i> Hi,<br></i>><i><br></i>><i><br></i>><i><br></i>><i> I made these kinds of tests before. I have two tips for you to pay<br></i>><i> attention to:<br></i>><i><br></i>><i> 1. Read about the [routes] on SIPp, It is tricky to satisfy kamailio<br>
</i>><i> with SIPp scenarios.<br></i>><i><br></i>><i> 2. Make sure your DB table is well build (use less varchars and more<br></i>><i> integers).<br></i>><i><br></i>><i> I found out that there are many kamailio modules I can use to load data in<br>
</i>><i> to memory and I hardly use the DB (only for ACC). I use MTREE, HTABLE,<br></i>><i> DIALPLAN, CARRIERROUTE, DROUTING, and so to store the information I need.<br></i>><i> And I get it with the simple functions of the module.<br>
</i>><i><br></i>><i> I load around 6 million numbers and other data which takes about 1.5 Gb of<br></i>><i> the memory.<br></i>><i><br></i>><i> For getting around the real-time changes that I need to deal with (In DB<br>
</i>><i> the data changes are immediately made on your service…). I have a RTIMER<br></i>><i> every 120 sec that check is a reload is needed. If so, it reloads the<br></i>><i> relevant data (very fast).<br></i>><i><br>
</i>><i> BR,<br></i>><i><br></i>><i> Uri<br></i>><i><br></i>><i><br></i>><i><br></i>><i><br></i>><i> Hello,<br></i>><i><br></i>><i> On 3/20/12 12:12 PM, Stephen Dodge (Bistech) wrote:<br></i>><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 *<br></i>><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>><i> *if you do a lot of direct DB interactions, perhaps latency of the<br></i>><i> queries will be relevant. You can use benchmark module to see how long<br>
</i>><i> it takes to execute part of the config file.<br></i>><i><br></i>><i> I think you don't fetch lot of records from db in config, so memory<br></i>><i> should be no problem, however you can dump private/shared memory usage<br>
</i>><i> via RPC commands within sercmd cli. CPU is a good metric always and easy<br></i>><i> to watch with systems tools.<br></i>><i><br></i>><i> Cheers,<br></i>><i> Daniel<br></i>><i> >*<br></i>><i> *>* Steve.<br>
</i>><i> *<br></i></div></div></blockquote></div><br></div>