[Users] usrloc, presence etc. cleanup rate: OpenSER mysql backend
Henning Westerholt
henning.westerholt at 1und1.de
Mon Apr 16 10:08:51 CEST 2007
On Monday 16 April 2007 06:05, Bernard Chan wrote:
> I would like to know how frequently OpenSER are cleaning up stale
> records with the mysql backend of various modules? For instance,
> active_watchers, location, presentity, watchers etc. mysql tables, or
> are stale records automatically removed at all? As I found a row in the
> location table with an "expires" date more than a month ago, but was
> still not cleaned up today. Or OpenSER takes a different strategy?
Hi Bernard,
Old expired db entries in the usrloc data are only deleted when somebody tries
to access them. There don't exist e.g. a background process that cleans up
these entries.
> This is because we expect to deploy OpenSER on a fairly large network
> and we are estimating database size and related overhead, and we are a
> bit worry that accumulation of these stale records may increase our
> processing costs.
As harddisk space is really cheap today this should normally not be a problem.
You could use for example some kind of cron job to drop once a week these
stale records.
Cheers,
Henning
More information about the sr-users
mailing list