[Users] usrloc, presence etc. cleanup rate: OpenSER mysql backend
bogdan at voice-system.ro
Mon Apr 16 12:50:03 CEST 2007
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:
>> 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.
More information about the Users