Managing Mango

Hi

I have a couple of problems, not directly with Mango but supporting it.

1. The database, how do I manage it ? Currently it is saying its 260 odd Meg in size. This is beacuse I had it logging a lot of data, I've cleared that down but that didn't reduce the size, not surprising as the tables probably have taken the space. Are there any tools available ?

2. Tomcat is taking more and more memory, currently 184MB. Have you any reccommended settings ?

Otherwise everything is working fine and has been for ages.

Thanks

Keith

Derby has a "compress" system procedure that will reclaim allocated but unused table space. That should cause the database size to drop.

There are derby utilities that can be found on the Apache site, but since Mango uses its database in an in-process, single user kind of way you will need to shut Mango down to be able to connect and do any maintenance.

The ideal memory settings for Mango would be to give it as much available memory as you can. Remember that Java will consume all memory that it has available to it before it will run a garbage collection, which will cause the memory utilization to suddenly drop. There are command line settings for telling Java how much memory it is allowed to use, which you can set in the Tomcat startup scripts.

Glad to hear your instance is working out for you.

Regards,
Matthew

Thanks, I'll give that a try