[OpenSIPS-Users] opensips will not start while loading huge blacklist

[Bogdan-Andrei Iancu]

Hi Abdul,

IF I understand correctly, you use startup route to load (from DB?) some 
blacklists into localcache ?

Regards,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
   http://www.opensips-solutions.com
OpenSIPS Bootcamp 2018
   http://opensips.org/training/OpenSIPS_Bootcamp_2018/

On 09/28/2018 04:10 AM, Abdul Basit wrote:
> Hi team,
>
> 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.
> Opensips work fine on filtering the call based on user blacklist 
> records loaded into local cache.
>
> While blacklist was growing upto 1.3m records, opensips startup was 
> taking ~60 sec on VM of 16GB RAM and 6 CPU.
> I increased shared memory to *6144* and package memory to *256.*
> Filter works fine here yet. Call load is not that much only blacklist 
> entries are growing.
>
> 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.
> I increased shared memory to *12288* and package memory to *1024* but 
> no success yet.
>
> I indexed mysql blacklist table but no luck.
>
> Please advise what settings I should add to opensips for successful 
> startup.
>
> --
> regards,
>
> abdul basit
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20181001/610cfce4/attachment.html>