Re: [Emerald] Maintenance

Dale E. Reed Jr. ( (no email) )
Mon, 20 Sep 1999 19:43:10 -0700

Network Operation Centre wrote:
> >Network Operation Centre wrote:
> >>
> >> When I goto manual maintenance it will show me expired MBR's but the trim
> >> option is not usable, also for call records it will not show me anything
> at
> >> all. Is there a way of getting it to do this. The emerald database is
> over
> >> 400mb and the log is about 350mb or so. I want to trim this down if
> >> possible.
> >
> >The trim for the MBRs has not been implemented yet. What are you
> >selecting
> >for the date on the calls? 1 Month should basically show you
> >everything.
> So how do I dump a lot of the history because this is what I think is taking
> up so much disk space ?

The only thing that really takes up disk space is the Calls table.
One year of billing history for 10,000 users would be maybe 50mb or

I would trim out calls over 3 months old and then run the checkdb.sql
script to see if it fixes the sizes.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list (including removal) go to: