On 8/14/2019 5:26 PM, Mark Thomas wrote:
On 14/08/2019 23:09, Jerry Malcolm wrote:
In my previous environment, I had a dedicated MySQL install where I
could set the max connections to pretty much anything I wanted. Now I'm
moving to AWS where more connections mean a higher charge. So it's time
to get real about how many connections I really need. BTW, TC 8.5.xx.
I 'thought' I understood defining a datasource. I thought that if I set
a maxTotal of 25 it sets a fixed ceiling and the datasource pool would
never request more than 25 connections from the database. But with the
following datasource definition, mySQL shows 48 connections created.,
and JConsole shows 48 connections for this datasource. In the same
MBean panel, it shows maxTotal=25 (??). My app gets a bunch of "Server
says Too Many Connections" exceptions.
What am I missing?
What is the full path to:
- the file below
- CATALINA_BASE
- CATALINA_HOME
?
Mark
CATALINA_BASE: /usr/share/tomcat8
CATALINA_HOME: /usr/share/tomcat8
/etc/tomcat8/Catalina/<hostname>/context.xml.default
This is running on an AWS Linux EC2.
<Context reloadable="true" crossContext="true" >
<Resource name="jdbc/------"
auth="Container"
type="javax.sql.DataSource"
maxTotal="25"
maxIdle="5"
maxWaitMillis="10000"
removeAbandonedOnBorrow="true"
removeAbandonedTimeout="60"
logAbandoned="true"
username="----"
password="----------"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://---------------------.us-east-1.rds.amazonaws.com
/----------" />
</Context>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
