You could set the max-connections in your dbpool
(defined in the datasource) to quite a big number. If
you have this low (eg 16), then chances are good that
you will have a bottleneck here and clients will have
to wait for a connection before they can continue.
Check that the size you configure
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
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
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
not closing them anywhere that they are not
being instantly destroyed.
-Original Message-
From: Riaan Oberholzer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 9:01 AM
To: Tomcat Users List
Subject: RE: config help
It sounds as if you are indeed opening/closing
connections as you
Howdy,
Give at much memory to the heap as your server hardware will allow (-Xmx
java option). I guess Windows doesn't have a ulimit-equivalent so you
probably don't need to worry about that.
Remove all unneeded connectors, valves, services from server.xml.
Remove all unneeded webapps (examples,
be the estimate of required concurrent users? Does
that mean simultaneous HTTP / JDBC requests??
Thanks..
Geoff
-Original Message-
From: Riaan Oberholzer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 9:01 AM
To: Tomcat Users List
Subject: RE: config help
It sounds
: RE: config help
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