Hello forum, I was wondering whether there is a fifo command or workaround to load the userblacklist table into memory without restarting. I have a large carrierroute table and it takes about 20 secs to start. best regards, PB
On Tuesday 04 November 2008, Pablo Bertuzzi wrote:
Hello forum, I was wondering whether there is a fifo command or workaround to load the userblacklist table into memory without restarting. I have a large carrierroute table and it takes about 20 secs to start. best regards,
Hi Pablo,
do you refer to the userblacklist module (table globalblacklist), or the carrierroute table? Anyway, both modules have a facility to reload the data on the fly. Take a look to the FIFO command section in the respective module docs.
BTW, the loading times for cr with a huge number of routes were already improved a lot in the trunk version.
Cheers,
Henning
Hello Henning, thank you for your email. I refer to userblacklist module. After reading the documentation the other day "1.5.1. reload_blacklist Reload the internal global blacklist cache. This is necessary after the database tables for the global blacklist have been changed." I thought that globalblacklist table only is loaded into cache. As I am using userblacklist table I concluded that there was some other command missing to load userblacklist.I've just made some test calls and "kamctl fifo reload_blacklist" DOES reload both tables. thank for your help and the fantastic job all of you are doing.
--- On Wed, 11/5/08, Henning Westerholt henning.westerholt@1und1.de wrote: From: Henning Westerholt henning.westerholt@1und1.de Subject: Re: [Kamailio-Users] Load userblacklist table to cache w/o restarting? To: users@lists.kamailio.org, pablo_bertuzzi@yahoo.com Date: Wednesday, November 5, 2008, 6:24 AM
On Tuesday 04 November 2008, Pablo Bertuzzi wrote:
Hello forum, I was wondering whether there is a fifo command or workaround to load the userblacklist table into memory without restarting. I have a large carrierroute table and it takes about 20 secs to start. best regards,
Hi Pablo,
do you refer to the userblacklist module (table globalblacklist), or the carrierroute table? Anyway, both modules have a facility to reload the data on the fly. Take a look to the FIFO command section in the respective module docs.
BTW, the loading times for cr with a huge number of routes were already improved a lot in the trunk version.
Cheers,
Henning
On Wednesday 05 November 2008, Pablo Bertuzzi wrote:
Hello Henning, thank you for your email. I refer to userblacklist module. After reading the documentation the other day "1.5.1. reload_blacklist
Reload the internal global blacklist cache. This is necessary after the database tables for the global blacklist have been changed."I thought that globalblacklist table only is loaded into cache. As I am using userblacklist table I concluded that there was some other command missing to load userblacklist.I've just made some test calls and "kamctl fifo reload_blacklist" DOES reload both tables. thank for your help and the fantastic job all of you are doing.
Hi Pablo,
the userblacklist table is not hold in memory, so its not possible/ necessary to reload it. Normally the userblacklists changes to often and are too large to be meaningful stored into the memory.
Cheers,
Henning
-
Henning Westerholt -
Pablo Bertuzzi