Re: [Emerald] Maintenance

Network Operation Centre ( (no email) )
Tue, 21 Sep 1999 12:34:21 +0930

>> 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
>so.

Well I only have about 1300 users active, but all up I think we have about
6000MBRS and as I said the data base has three files which are over 300mb.

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

This is what I can not do. The trim option will not highlight

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart