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

[Bogdan-Andrei Iancu]

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.

regards,
bogdan


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
>
>