Hi Stefan I did use cache mode. However during recovery it uses up 1G memory, I suspects that is because result set of hsqldb do not get cached to disk (http://hsqldb.org/web/hsqlFAQ.html#BIGRESULTS).
Regards Francis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stefan Lischke Sent: Thursday, January 17, 2008 5:46 PM To: Sequoia general mailing list Subject: Re: [Sequoia] Recovery Log Hi, The main error when using hsqldb as recovery log db is to use it in memory mode. Thats why the controller process increases the memory usage after each write. If you switch to cached mode and set the memory for the hsqldb in the configuration, everything works perfect and 512MB is much more than enough. hth Stefan Francis Chong wrote: > Hi > > I got out of memory problem when using hsqldb as recovery log, but since I > change to Derby it do not show again. > > Regards > Francis > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Stuart > James > Sent: Thursday, January 17, 2008 5:14 PM > To: sequoia@lists.forge.continuent.org > Subject: Re: [Sequoia] Recovery Log > > Hi Dave, > > > >> Although this is slightly off topic it is important that Sequoia has >> at least 512MB of memory. One time we managed to screw up the memory >> settings for the JVM and revert to the defaults of 64MB. Due to the >> caching of parsed requests and the caching that is done of intra >> cluster messages we ran into ugly out of heap mempory errors that >> would kill one of the threads so the controller would effectively >> hang. >> >> > > We actually experienced the same thing which is why we decided to go > with 768 to be safe. > > Regards > > Stuart > _______________________________________________ > Sequoia mailing list > Sequoia@lists.forge.continuent.org > https://forge.continuent.org/mailman/listinfo/sequoia > > _______________________________________________ > Sequoia mailing list > Sequoia@lists.forge.continuent.org > https://forge.continuent.org/mailman/listinfo/sequoia > > > _______________________________________________ Sequoia mailing list Sequoia@lists.forge.continuent.org https://forge.continuent.org/mailman/listinfo/sequoia
