Thanks a ton Nichlas. This is really useful & will definitely help me make a better/faster decision.
Best Regards, -Deepak -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Monday, September 04, 2006 10:41 AM To: [email protected] Subject: Re: [magnolia-user] Tomcat server crash because of "too many files open" | Magnolia 3.0 rc2 Hi Deepak, Derby is a terrible (but free) option for live systems. I've tried a bit of everything and here's pretty much my comments. from best backend to worst. - bdb: is the best option if you don't have to redistribute your application (server only). - h2: embedded databaser "a la derby" but with no file problems and way less memory usage: http://www.h2database.com/html/frame.html - postgresql: inconvenience of a remote database, but pretty fast, stable, and not using much memory - mysql: problems to setup (see other people on the list), but working. Overall I found it was less responsive than postgresql - derby: excellent license, free, and already included, but terrible on performance, memory usage, and other corruptions. - cqfs: from what I remember was a really good Return on Investment, but haven't used in a year now. Ask the magnolia team for answers. Note, this is only MY experience of the backends, and the results of MY tests here with Magnolia. I may surely be wrong, and it may surely also depends on which webserver you are using. Anyways, I just hope it helps you. Regards, Nicolas, On Sep 4, 2006, at 2:03 PM, Deepak Mittal wrote: > Thanks for the response John. > > My application is running on Linux. I have increased the open file > limit > to more than 75,000; but that only means that the tomcat server will > take some more time to crash; once the limit is exhausted. > > The root cause of the problem is that there is some component > (probably > derby) in my magnolia application which is not releasing the > file-handles. > > I am already considering migrating my application to a different > database such as mysql or postgres. > > Best Regards, > > ~Deepak > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] > Sent: Monday, September 04, 2006 6:10 AM > To: [email protected] > Subject: Re: [magnolia-user] Tomcat server crash because of "too many > files open" | Magnolia 3.0 rc2 > > On 9/1/06, Deepak Mittal <[email protected]> wrote: >> Hello Magnolians, >> >> I am using Magnolia 3.0 rc2 to host my web-application on tomcat 5.5 >> using derby database (default). >> >> However, my tomcat server keeps crashing after few days because of > "too >> many files open" exception. >> >> Is there anyone else who is facing a similar problem; and any >> tips/work-around for this problem? > > Hi Deepak, > > are you running on a linux/unix system ? > Have you investigated "man ulimit" ? > Have you googled for that problem in the large ? google : 'tomcat "too > many files open"' ? > > > Best regards, > > -- > John Mettraux -///- http://jmettraux.openwfe.org > > ---------------------------------------------------------------- > for list details see > http://www.magnolia.info/en/magnolia/developer.html > ---------------------------------------------------------------- > > ---------------------------------------------------------------- > for list details see > http://www.magnolia.info/en/magnolia/developer.html > ---------------------------------------------------------------- ---------------------------------------------------------------- for list details see http://www.magnolia.info/en/magnolia/developer.html ---------------------------------------------------------------- ---------------------------------------------------------------- for list details see http://www.magnolia.info/en/magnolia/developer.html ----------------------------------------------------------------
