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

[Henning Westerholt]

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