It sounds as if you are indeed opening/closing connections as you need them.
You need to configure a datasource for your db connections: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html Its fairly easy to set up and the gain is significant. I would say it is probably a good practice to use this anyway, even if you do not expect heavy traffic. --- Geoff Peters <[EMAIL PROTECTED]> wrote: > Andoni - thanks for the advice - someone else just > mentioned the same thing in a reply (Riaan) - > setting the datasource connection pool parameter - > where would this parameter go? Is it a parameter at > the server level config or application level? We > have a MySQL person in house, I will ask her about > the maximum concurrent MySQL connections.... > > Thanks, Geoff > > -----Original Message----- > From: Andoni [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 23, 2003 8:54 AM > To: Tomcat Users List > Subject: Re: config help > > > I would recommend you write a tiny java program that > keeps opening > connections to your database and counting the number > of open connections. > Then when it starts getting errors you can shut the > connections but record > the maximum number of open connections. > > Then since your period is so intense you should put > your initial pool of > open connections to very close to this number. e.g. > if your max number of > connections is, 170 (like mine) then set your > initial pool size to 140-150 > so that there is practically no connection > opening/closing done by your > program while it's running. > > Andoni. > > > ----- Original Message ----- > From: "Geoff Peters" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, July 23, 2003 12:38 PM > Subject: config help > > > Hi - I am currently in the process of deploying a > web app using Tomcat > 4.1.18, MySQL 3.23 on a Win2K Server. The app will > be used heavily for a > period of 3 - 4 hours, (probably a couple of > thousand hits per minute), then > never used again. > > I am wondering what exactly I should do to enhance > performace - other than > some changes recommended to the server.xml file > (i.e. setting debug to > zero), I am not 100% sure what some of the other > changes will do, > specifically min and max processors, and other > settings. Can someone please > give me some pointers as to what I can so to > maximize performance over this > 3-4 hour period?? > > Application is a series of MySQL based reports (all > servlets), containing > several select statements and using the MySQL JDBC > driver. > > Thanks for any advice! > > Geoff > > Geoff Peters, SCJP Phone : (441) > 296-9640 > Applications Developer Fax : (441) > 292-1509 > Logic Communications E-mail : > [EMAIL PROTECTED] > 12 Par-La-Ville Road WWW : > http://www.logic.bm > Hamilton, Bermuda HM JX > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]