-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Shawn,
On 3/24/18 12:08 AM, Shawn Heisey wrote: > This message is long. Lots of details, a fair amount of history. Thanks for the back-story and the configurations. It really helps explain what is going on. > Here's a redacted configuration that we have in place for one of > the DB connection pools on the production servers: > > <Resource name="jdbc/REDACTED" auth="Container" > factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" > driverClassName="com.mysql.jdbc.Driver" > type="javax.sql.DataSource" maxActive="60" maxIdle="10" > maxWait="30000" removeAbandoned="true" removeAbandonedTimeout="30" > username="REDACTED" password="REDACTED" testOnBorrow="true" > validationQuery="select 1" > url="jdbc:mysql://REDACTED.REDACTED.com:3306/REDACTED?autoReconnect=tr ue&zeroDateTimeBehavior=round" > > /> Before we go too far, you have said: 1. You have 5 prod servers 2. They have several pools defined 3. The above is an example of a defined pool Just above, that configuration says maxActive=60. 5 * 60 = 300 connections. And that's just for one pool. Perhaps you simply have too many total connections when you add-up all the possible connections your servers can make to your db server? > This is the Tomcat documentation I'm using as a reference: > > https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html That's the wrong pool. You are using DBCP, and the docs are for Tomcat's (non-DBCP) pool. The configurations are roughly the same for simple configs. But make sure you are reading the right docs for the right pool. - -chris -----BEGIN PGP SIGNATURE----- Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQJRBAEBCAA7FiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlq2xHkdHGNocmlzQGNo cmlzdG9waGVyc2NodWx0ei5uZXQACgkQHPApP6U8pFg8ChAAqwt7pUtJZtiuxbdp aVwh9DliMYKBZeyD/X6LOQnXyorgaQYYbhfcQ0RWPRmsk/Bbnpxt5p9bLfrmvlrZ g7wPALxMVLHW/ZSscY+f4yr2PyCb7RycTMlB3mz4YIzQUzfTUptW6ZAghrWfif+H Oi9aV2kFZ7NbAEBCjmhQooMKvd958EGvTHBDEZlaJlgsK6m0RvHqfhVDZCLNzbFW +20/uyjgRiuVwWPR1GBuxT6R7TktGeYCwkSqUxa+FSVIH22vjr61vJSw7+2QifYW dlaPb0ORLPVxS8Kygq2iRKYU6vZzKMazX+Dnf7vXo6CJ4unqjhFgFBimVuNzq7wR 5ZiInmpRXQwofaJVPJ6JBw13u36Okb5+dm5m+NljhF0VNptWwQz9etr3zSZJrQQS JE7QdkRcHd2WbZkoJA2zR15kXYJkdlZsOspcz3VVZOC7yy/WS1oDQ/i7BRDLPnXL vaK3K+2ka+Sgg9JgXepiKtwxb7x/uF05I56lmTLSz6pIs5ZYT0jue4r5yshtt4cH af8pyDf5dbr2OIelhIz9Bh/7Ugfkj+5WkoCKQ1GEmg+I6S/c7rady7+ckovIctwn lL7Anugqdy5bbIpmWjNuYPM6Hwiqetxdu9dMO6PR4QtdiAtNpWqopydS7Og/GSh7 hMyaWAnPZf0GdRGRVGG6yqTwgYg= =TU0a -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
