[Users] usrloc, presence etc. cleanup rate: OpenSER mysql backend

Bogdan-Andrei Iancu bogdan at voice-system.ro
Mon Apr 16 12:50:03 CEST 2007

Hi Henning,

do not get me wrong, I was not suggesting to restart just to have that 
bogus records deleted :).....

the basic idea is that such bogus expired records may appear due 
improper DB ops (in db_mode 2) and they will not be removed by openser 
during processing. So you will have to delete them by other means.


Henning Westerholt wrote:
> On Monday 16 April 2007 11:32, Bogdan-Andrei Iancu wrote:
>> Hi,
>> In mode 2, the DB is periodically updated from mem. cache - what is
>> removed from mem, is removed from DB also.
>> At startup, the DB is cleaned of old, expired elements.
>> If you use this db_mode, you should not operate directly on DB, but only
>> via the mem cache (MI functions) to avoid de-synchronization. Even if
>> this happens, after a restart, everything will be cleaned.
> This works for small installations, but not if you have an installation with 
> several millions customers and process 700 millions call minutes per month..
> Here do you want the smallest downtime as possible, it is not feasible to 
> simple restart openser. The cleanup on startup would probably need also 
> several minutes.
> But i don't know what your load requirements are.
> Cheers,
> Henning

More information about the Users mailing list