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]