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 _______________________________________________ Users mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
