<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Yes. That's right.</div><div dir="ltr">The code I am using is as below. <span style="background-color:rgb(254,254,238);color:rgb(102,102,102);font-family:"Lucida Console","Andale Mono","Courier New",Courier;font-size:11.7072px;white-space:pre">globalblacklist</span> table has complete number as <span style="background-color:rgb(254,254,238);color:rgb(102,102,102);font-family:"Lucida Console","Andale Mono","Courier New",Courier;font-size:11.7072px;white-space:pre">prefix</span><span style="background-color:rgb(254,254,238);color:rgb(102,102,102);font-family:"Lucida Console","Andale Mono","Courier New",Courier;font-size:11.7072px;white-space:pre"> </span>with and <span style="background-color:rgb(245,245,245);color:rgb(102,102,102);font-family:"Lucida Console","Andale Mono","Courier New",Courier;font-size:11.7072px;white-space:pre">whitelist</span> status. </div><div dir="ltr"><div><div><br></div><div><div><div class="hljs bash" style="display:block;overflow-x:auto;padding:0.5em;color:rgb(51,51,51);background:rgb(248,248,248);font-family:monospace"><div>route {</div><div><span style="white-space:pre"> </span>.....</div><div><span style="white-space:pre"> </span><span class="hljs-keyword" style="font-weight:bold">if</span> ( !check_blacklist(<span class="hljs-string" style="color:rgb(136,0,0)">"globalblacklist"</span>) ) {</div><div><span style="white-space:pre"> </span>xlog(<span class="hljs-string" style="color:rgb(136,0,0)">"L_NOTICE"</span>,<span class="hljs-string" style="color:rgb(136,0,0)">"[<span class="hljs-variable" style="color:rgb(188,96,96)">$fU</span>/<span class="hljs-variable" style="color:rgb(188,96,96)">$tU</span>/<span class="hljs-variable" style="color:rgb(188,96,96)">$ci</span>] [<span class="hljs-variable" style="color:rgb(188,96,96)">$rm</span>] Destination [<span class="hljs-variable" style="color:rgb(188,96,96)">$rU</span>] is not Allowed. Dropping call.\n"</span>);</div><div><span style="white-space:pre"> </span>sl_send_reply(<span class="hljs-string" style="color:rgb(136,0,0)">"403"</span>, <span class="hljs-string" style="color:rgb(136,0,0)">"Forbidden"</span>);</div><div><span style="white-space:pre"> </span><span class="hljs-built_in" style="color:rgb(57,115,0)">exit</span>;</div><div><span style="white-space:pre"> </span>}</div><div><span style="white-space:pre"> </span><span class="hljs-keyword" style="font-weight:bold">else</span> {</div><div><span style="white-space:pre"> </span>xlog(<span class="hljs-string" style="color:rgb(136,0,0)">"L_INFO"</span>, <span class="hljs-string" style="color:rgb(136,0,0)">"[<span class="hljs-variable" style="color:rgb(188,96,96)">$fU</span>/<span class="hljs-variable" style="color:rgb(188,96,96)">$tU</span>/<span class="hljs-variable" style="color:rgb(188,96,96)">$ci</span>] [<span class="hljs-variable" style="color:rgb(188,96,96)">$rm</span>] INBOUND CALL for [<span class="hljs-variable" style="color:rgb(188,96,96)">$ru</span>]"</span>);</div><div><span style="white-space:pre"> </span>route(10);</div><div><span style="white-space:pre"> </span><span class="hljs-built_in" style="color:rgb(57,115,0)">exit</span>;</div><div><span style="white-space:pre"> </span>}</div><div><span style="white-space:pre"> </span>.....</div><div>}</div></div></div><br><div></div></div><div><br clear="all"><div><div dir="ltr" class="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><br></div></div></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Mon, 1 Oct 2018 at 19:07, Bogdan-Andrei Iancu <<a href="mailto:bogdan@opensips.org">bogdan@opensips.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div 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="m_2718947286626188160moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="m_2718947286626188160moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a>
OpenSIPS Bootcamp 2018
<a class="m_2718947286626188160moz-txt-link-freetext" href="http://opensips.org/training/OpenSIPS_Bootcamp_2018/" target="_blank">http://opensips.org/training/OpenSIPS_Bootcamp_2018/</a>
</pre>
<div class="m_2718947286626188160moz-cite-prefix">On 09/28/2018 04:10 AM, Abdul Basit
wrote:<br>
</div>
<blockquote type="cite">
<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="m_2718947286626188160gmail_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="m_2718947286626188160mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Users mailing list
<a class="m_2718947286626188160moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a class="m_2718947286626188160moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</blockquote></div>