<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Abdul,<br>
<br>
IF I understand correctly, you use startup route to load (from
DB?) some blacklists into localcache ?<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a>
OpenSIPS Bootcamp 2018
<a class="moz-txt-link-freetext" href="http://opensips.org/training/OpenSIPS_Bootcamp_2018/">http://opensips.org/training/OpenSIPS_Bootcamp_2018/</a>
</pre>
<div class="moz-cite-prefix">On 09/28/2018 04:10 AM, Abdul Basit
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAGQG5MbC1cRcFQ5=phcjQD+SSOMwHNnKixH3H+omor39=Bbv3Q@mail.gmail.com">
<div dir="ltr">
<div>Hi team,</div>
<div><br>
</div>
<div>I have a opensips 2.4 deployed having 4 children and with
mysql configured for loading user blacklist to opensips local
cache on opensips startup.<br>
</div>
<div>Opensips work fine on filtering the call based on user
blacklist records loaded into local cache. </div>
<div><br>
</div>
<div>While blacklist was growing upto 1.3m records, opensips
startup was taking ~60 sec on VM of 16GB RAM and 6 CPU.<br>
</div>
<div>I increased shared memory to <b>6144</b> and package
memory to <b>256.</b><br>
</div>
<div>Filter works fine here yet. Call load is not that much only
blacklist entries are growing.</div>
<div><br>
</div>
<div>But now blacklist has grown to very huge number, up to 10m
records in mysql. Opensips is not starting successfully and
service startup requests timeout after huge CPU spikes while
trying to populate local cache from mysql. <br>
</div>
<div>I increased shared memory to <b>12288</b> and package
memory to <b>1024</b> but no success yet.</div>
<div><br>
</div>
<div>I indexed mysql blacklist table but no luck.</div>
<div><br>
</div>
<div>Please advise what settings I should add to opensips for
successful startup. </div>
<div><br>
</div>
<div>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">
<div><font size="2"><span
style="font-family:verdana,sans-serif"><span
style="color:rgb(39,78,19)">--<br>
regards,</span></span></font></div>
<font size="2"><span style="font-family:verdana,sans-serif"><span
style="color:rgb(39,78,19)"><br>
abdul basit</span></span></font></div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>