Sampath,
On 8/12/21 07:02, Sampath Rajapakshe wrote:
Hi Chris,
Thanks for the detailed explanation, yes, we tried with abandoned true logs
and found an issue with our code base as well.
It seems we had a case where a single thread creates a new connection and
before closing that connection
Hi Chris,
Thanks for the detailed explanation, yes, we tried with abandoned true logs
and found an issue with our code base as well.
It seems we had a case where a single thread creates a new connection and
before closing that connection creates a new connection and closes that new
connection and
Sampath,
On 8/9/21 01:45, Sampath Rajapakshe wrote:
In our case, we know the reason for the pool exhausted behaviour,
there are slow queries and also due to high TPS where pool is not
enough. So we are expected to get pool exhaustion with current
configurations.
Ok.
What we wanted to verify
Hi Chris,
Thanks for the clarification. I've gone through the blog, In our case, we
know the reason for the pool exhausted behaviour, there are slow queries
and also due to high TPS where pool is not enough. So we are expected to
get pool exhaustion with current configurations. What we wanted to
Sampath,
On 8/6/21 08:37, Sampath Rajapakshe wrote:
Hi All,
In my local setup before pool exhaustion exception is thrown, all the
connections seem to be in freezed and when checking processList in mysql,
those connections are in sleep state and doesn't execute any queries. After
waiting for
Hi All,
In my local setup before pool exhaustion exception is thrown, all the
connections seem to be in freezed and when checking processList in mysql,
those connections are in sleep state and doesn't execute any queries. After
waiting for maxWait period the pool exhausted exception gets thrown
10"
>>>>> maxWait="3"
>>>>> timeBetweenEvictionRunsMillis="5000"
>>>>> minEvictableIdleTimeMillis="6"
>>>>> removeAbandonedTimeout="600"
&
stOnBorrow="true"
testOnReturn="false"
validationQuery="/* ping */ SELECT 1"
validationInterval="30000"
jmxEnabled="true"
jdbcInterceptors="Connect
t; timeBetweenEvictionRunsMillis="5000"
>>> minEvictableIdleTimeMillis="6"
>>> removeAbandonedTimeout="600"
>>> removeAbandoned="true"
>>> logAbandoned="false
nEvictionRunsMillis="5000"
>>> minEvictableIdleTimeMillis="6"
>>> removeAbandonedTimeout="600"
>>> removeAbandoned="true"
>>> logAbandoned="false"
>
removeAbandoned="true"
> > logAbandoned="false"
> > testWhileIdle="true"
> > testOnBorrow="true"
> > testOnReturn="false"
> > validationQuery="/*
removeAbandonedTimeout="600"
> > removeAbandoned="true"
> > logAbandoned="false"
> > testWhileIdle="true"
> > testOnBorrow="true"
> > testOnR
On 8/27/20 2:47 AM, Gokhan Akgul wrote:
Hi ,
I have been facing the deadlock issue for the last 2 months about
JDBCPoolCleaner Thread .
Following config set in context.xml
Thread dump
Tomcat JDBC Pool Cleaner[63445188:1598345711425] id=16 state=BLOCKED
- waiting to lock
removeAbandoned="true"
> logAbandoned="false"
> testWhileIdle="true"
> testOnBorrow="true"
> testOnReturn="false"
> validationQuery="/* ping */ SELECT 1"
> valid
t; removeAbandonedTimeout="600"
> > removeAbandoned="true" logAbandoned="false" testWhileIdle="true"
> > testOnBorrow="true" testOnReturn="false" validationQuery="/* ping
> > */ SELECT 1" validationInterval="3" jmxEn
illis="6" removeAbandonedTimeout="600"
> removeAbandoned="true" logAbandoned="false" testWhileIdle="true"
> testOnBorrow="true" testOnReturn="false" validationQuery="/* ping
> */ SELECT 1" validationIn
Hi ,
I have been facing the deadlock issue for the last 2 months about
JDBCPoolCleaner Thread .
Following config set in context.xml
Thread dump
Tomcat JDBC Pool Cleaner[63445188:1598345711425] id=16 state=BLOCKED
- waiting to lock <0x57dcb0b7> (a com.mysql.jdbc.JDBC4PreparedSta
> From: Felix Schumacher [mailto:felix.schumac...@internetallee.de]
> Subject: Re: Tomcat JDBC Pool memory leak when using StatementFinalizer
interceptor
> Am 11.07.2018 um 16:22 schrieb Martin Knoblauch:
> > Now it might be, that we are just using the StatementFinalizer in a
w
Am 11.07.2018 um 16:22 schrieb Martin Knoblauch:
Hi,
while analyzing some heap dump for other reasons, I found that our
application is apparently aggregating a considerable amount of memory in
"org.apache.tomcat.jdbc.pool.TrapException", which is never cleaned by GC.
Digging deeper, it
Hi,
while analyzing some heap dump for other reasons, I found that our
application is apparently aggregating a considerable amount of memory in
"org.apache.tomcat.jdbc.pool.TrapException", which is never cleaned by GC.
Digging deeper, it seems that the entries of the "statements" linked list
in
On 6 November 2014 05:36, Vasily Kukhta v.b.kuk...@gmail.com wrote:
I have received additional details - the application starts getting
java.sql.SQLException: Listener refused the connection with the following
error: ORA-12519, TNS:no appropriate service handler found, although the
amount of
...@pivotal.io
wrote:
On Wed, Nov 5, 2014 at 9:13 AM, Vasily Kukhta v.b.kuk...@gmail.com
wrote:
Hello all!
I have developed an application using Tomcat JDBC pool. Everything is
fine
except that the pool leaves hundreds of TCP connections in TIME_WAIT
state
Hello all!
I have developed an application using Tomcat JDBC pool. Everything is fine
except that the pool leaves hundreds of TCP connections in TIME_WAIT state,
which kills the server sooner or later... Could you please suggest what to
fix, my configuration is below:
PoolProperties
On Wed, Nov 5, 2014 at 9:13 AM, Vasily Kukhta v.b.kuk...@gmail.com wrote:
Hello all!
I have developed an application using Tomcat JDBC pool. Everything is fine
except that the pool leaves hundreds of TCP connections in TIME_WAIT state,
I have to ask, but are you sure it's the pool? TCP
at 7:36 AM, Daniel Mikusa dmik...@pivotal.io wrote:
On Wed, Nov 5, 2014 at 9:13 AM, Vasily Kukhta v.b.kuk...@gmail.com
wrote:
Hello all!
I have developed an application using Tomcat JDBC pool. Everything is
fine
except that the pool leaves hundreds of TCP connections in TIME_WAIT
state
:36 AM, Daniel Mikusa dmik...@pivotal.io wrote:
On Wed, Nov 5, 2014 at 9:13 AM, Vasily Kukhta v.b.kuk...@gmail.com
wrote:
Hello all!
I have developed an application using Tomcat JDBC pool. Everything is
fine
except that the pool leaves hundreds of TCP connections in TIME_WAIT
Hi friends,
I have a question regarding the ability of Tomcat JDBC pool to reconnect
automatically to a database in case of temporarily network failures.
I'm developing a high-load application which uses Oracle 11g database. It
may happen that the DB can become unavailable for several minutes
On Fri, Oct 10, 2014 at 9:51 AM, Vasily Kukhta v.b.kuk...@gmail.com wrote:
Hi friends,
I have a question regarding the ability of Tomcat JDBC pool to reconnect
automatically to a database in case of temporarily network failures.
I'm developing a high-load application which uses Oracle 11g
:36 AM, Christopher Schultz
ch...@christopherschultz.net wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Todd,
On 9/23/14 11:41 AM, Todd Chapman wrote:
My application uses the Tomcat JDBC pool. While using netstat and
tcpdump to diagnose connection problems I noticed that the client
wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Todd,
On 9/23/14 11:41 AM, Todd Chapman wrote:
My application uses the Tomcat JDBC pool. While using netstat and
tcpdump to diagnose connection problems I noticed that the client
side occasionally closes a DB connection
:
My application uses the Tomcat JDBC pool. While using netstat and
tcpdump to diagnose connection problems I noticed that the client
side occasionally closes a DB connection and opens a new one. That
is unexpected based on my configuration.
poolProperties.setInitialSize(10
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Todd,
On 9/23/14 11:41 AM, Todd Chapman wrote:
My application uses the Tomcat JDBC pool. While using netstat and
tcpdump to diagnose connection problems I noticed that the client
side occasionally closes a DB connection and opens a new one
uses the Tomcat JDBC pool. While using netstat and tcpdump
to diagnose connection problems I noticed that the client side occasionally
closes a DB connection and opens a new one. That is unexpected based on my
configuration.
poolProperties.setInitialSize(10
Hi,
My application uses the Tomcat JDBC pool. While using netstat and tcpdump
to diagnose connection problems I noticed that the client side occasionally
closes a DB connection and opens a new one. That is unexpected based on my
configuration.
poolProperties.setInitialSize(10
2 years later ...
OK this sounds like the best approach as it lets you scale things out as
you grow and actually need more servers (then you just have to manage which
database to switch too).
The cons of this approach is that most ORM's don't support this.
On Fri, Jun 1, 2012 at 2:37 PM,
Thank you, I have changed timeBetweenEvictionRunsMillis value and it is
working properly now. Another problem has appeared: although the timeout is
handled correctly, no exception is thrown. I thought an SQLException would
be thrown if query takes too long. Maybe pool does not throw exceptions at
Vasily, the exception depends on where the timeout occurs.
If the timeout is triggered by the driver, because you hit the
setQueryTimeout limit
http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#setQueryTimeout(int)
then yes, as per javadoc, it is up to the JDBC driver to throw an
So, it means that if the timeout is detected not using setQueryTimeout
method, but by the tomcat pool settings (setMaxAge or
setTimeBetweenEvictionRunsMillis), it means that no exception can be thrown
at all?
Vasily
2014-07-23 12:14 GMT+04:00 Filip Hanik fi...@hanik.com:
Vasily, the
maxAge is not a timeout setting. It simply means the connection gets
retired(closed) instead of returned to the pool after a certain amount of
time
timeBetweenEvictionRunsMillis is not a timeout either. It is the interval
that the thread checks for timeouts, but not query, connection checkout
Hello, dear tomcat users!
I am developing high-load application using tomcat jdbc connection pool and
Oracle database. It is very important to ensure my app to have very small
DB query timeouts (no longer than 3 seconds) to prevent long-running
queries or database slowness from blocking all my
On Mon, Jul 21, 2014 at 11:05 AM, Vasily Kukhta v.b.kuk...@gmail.com
wrote:
Hello, dear tomcat users!
I am developing high-load application using tomcat jdbc connection pool and
Oracle database. It is very important to ensure my app to have very small
DB query timeouts (no longer than 3
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Vasily,
On 7/21/14, 11:05 AM, Vasily Kukhta wrote:
Oracle database. It is very important to ensure my app to have very
small DB query timeouts (no longer than 3 seconds) to prevent
long-running queries or database slowness from blocking all my
: PooledConnection.getConnection - Tomcat JDBC Pool
From: Christopher Schultz [mailto:ch...@christopherschultz.net]
Subject: Re: PooledConnection.getConnection - Tomcat JDBC Pool
On 3/25/14, 10:53 AM, Pierce, Jonathan D wrote:
In the Aries class, the expectation is that
XAConnection.getConnection().close
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Jonathan,
On 3/26/14, 9:16 AM, Pierce, Jonathan D wrote:
I agree that it is counter-intuitive. I also agree that the
application should not need to use the PooledConnection interface.
However, XAConnection is needed to be used by a
Jonathan opened up the following bug
https://issues.apache.org/bugzilla/show_bug.cgi?id=56310
and I do believe our pool is incorrectly implementing the
ConnectionPoolDatasource. I do believe it shouldn't implement that
interface at all.
On Wed, Mar 26, 2014 at 10:41 AM, Christopher Schultz
I am trying to use the tomcat jdbc pool library (outside of tomcat)
along with the Apache Aries Transaction library in an OSGi environment
to handle distributed transactions.
One of the classes (XADataSourceEnlistingWrapper) provided by the
Aries Transaction wrappers library is a DataSource
If that is the case the tomcat jdbc
pooling library handling the call incorrectly and its a bug.
I'd be suspect of this. Are you actually using *org.apache.tomcat.jdbc.pool*?
Since it's a Tomcat module it seems an odd choice to use outside of Tomcat.
...@gmail.comwrote:
I am trying to use the tomcat jdbc pool library (outside of tomcat)
along with the Apache Aries Transaction library in an OSGi environment
to handle distributed transactions.
One of the classes (XADataSourceEnlistingWrapper) provided by the
Aries Transaction wrappers library
(); ?
Jonathan, Filip,
If it is a bug then my answer is way off the mark. I'm sorry. If it's not a
problem, could you explain, in this case, what acts as the connection pool
manager when the Tomcat jdbc pool library is used outside of Tomcat?
Best,
John
I've created Bug 56310 for this issue.
Jonathan
-Original Message-
From: Pierce, Jonathan D
Sent: Tuesday, March 25, 2014 10:54 AM
To: Tomcat Users List
Subject: RE: PooledConnection.getConnection - Tomcat JDBC Pool
In the Aries class, the expectation is that
XAConnection.getConnection
: Tuesday, March 25, 2014 10:42 AM
To: Tomcat Users List
Subject: Re: PooledConnection.getConnection - Tomcat JDBC Pool
On Tue, Mar 25, 2014 at 9:54 AM, Filip Hanik fi...@hanik.com wrote:
Please open a bug, and we will get this taken care of. I do have one
question,Aries library, on which call does
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Jonathan,
On 3/25/14, 10:53 AM, Pierce, Jonathan D wrote:
In the Aries class, the expectation is that
XAConnection.getConnection().close() will return the connection to
the pool, and that XAConnection.close() would close the physical
From: Christopher Schultz [mailto:ch...@christopherschultz.net]
Subject: Re: PooledConnection.getConnection - Tomcat JDBC Pool
On 3/25/14, 10:53 AM, Pierce, Jonathan D wrote:
In the Aries class, the expectation is that
XAConnection.getConnection().close() will return the connection
Hello,
I've been trying to figure this problem out for some time now and I'm
totally stuck. The Exception in question is the following:
Caused by: java.lang.NullPointerException
at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7009)
at
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Henning,
On 10/10/13 10:01 AM, Henning Rohlfs wrote:
I've been trying to figure this problem out for some time now and
I'm totally stuck. The Exception in question is the following:
Caused by: java.lang.NullPointerException at
.nabble.com/Fwd-Tomcat-Jdbc-Pool-NumActive-vs-actual-Established-Connections-tp4997798p4997845.html
Sent from the Tomcat - User mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional
2013/4/16 Kiren Pillay kirenpill...@gmail.com
Hi All,
I am using the tomcat-jdpc-pool from within my spring application. I am
noticing a discrepancy between the numActive/numIdle values that the pool
reports versus the actual number of established connections to the
database.
For example,
.
Regards
Kiren
--
View this message in context:
http://tomcat.10.x6.nabble.com/Fwd-Tomcat-Jdbc-Pool-NumActive-vs-actual-Established-Connections-tp4997798p4997849.html
Sent from the Tomcat - User mailing list archive at Nabble.com
Hi All,
I am using the tomcat-jdpc-pool from within my spring application. I am
noticing a discrepancy between the numActive/numIdle values that the pool
reports versus the actual number of established connections to the database.
For example, the pool reports 0 active and 4 idle connections
Am 19.03.2013 22:20, schrieb Bertrand Guay-Paquet:
On 19/03/2013 5:05 PM, Felix Schumacher wrote:
Have you looked at
http://grokbase.com/t/openejb/users/13135d2a0v/jdbc-connection-pool-memory-leak
? It seems like your problem. Regards Felix
Indeed, this is extremely similar to my issue.
Bug reported at https://issues.apache.org/bugzilla/show_bug.cgi?id=54732
Due to another bug in TomEE, StatementCache is always enabled. That bug
is reported here: https://issues.apache.org/jira/browse/TOMEE-837
Thanks for your help
On 20/03/2013 7:28 AM, Felix Schumacher wrote:
Am
Bug reported at https://issues.apache.org/bugzilla/show_bug.cgi?id=54732
Due to another bug in TomEE, StatementCache is always enabled. That bug
is reported here: https://issues.apache.org/jira/browse/TOMEE-837
Thanks for your help
On 20/03/2013 7:28 AM, Felix Schumacher wrote:
Am
Hello,
I'm using Tomcat 7.0.34 via TomEE 1.5.1 with MySQL. I noticed a memory
leak in my web application which uses jdbc connection pooling with
Tomcat's jdbc-pool.
The com.mysql.jdbc.JDBC4Connection class has a field named
openStatements which holds, as you can imagine, open sql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Bertrand,
On 3/19/13 3:48 PM, Bertrand Guay-Paquet wrote:
I'm using Tomcat 7.0.34 via TomEE 1.5.1 with MySQL. I noticed a
memory leak in my web application which uses jdbc connection
pooling with Tomcat's jdbc-pool.
The
Can you post some example of your code? Can you also post your pool's
configuration?
Here is my configuration from tomee.xml. I'm not 100% sure how it maps
to Tomcat values though.
Resource id=jdbc/my-db type=javax.sql.DataSource
JdbcDriver=com.mysql.jdbc.Driver
Bertrand Guay-Paquet ber...@step.polymtl.ca schrieb:
Hello,
I'm using Tomcat 7.0.34 via TomEE 1.5.1 with MySQL. I noticed a memory
leak in my web application which uses jdbc connection pooling with
Tomcat's jdbc-pool.
The com.mysql.jdbc.JDBC4Connection class has a field named
On 19/03/2013 5:05 PM, Felix Schumacher wrote:
Have you looked at
http://grokbase.com/t/openejb/users/13135d2a0v/jdbc-connection-pool-memory-leak
? It seems like your problem. Regards Felix
Indeed, this is extremely similar to my issue. Thanks for sharing this.
It does seem however like the
the tomcat jdbc pool independently by placing the jars in my
web-application. We use glassfish as our application server. So what you
suggest is not an option.
--**--**-
To unsubscribe, e-mail:
users-unsubscribe@tomcat
On 12.03.2013, at 17:14, Christopher Schultz ch...@christopherschultz.net
wrote:
On 3/12/13 7:54 AM, amit shah wrote:
I am using Oracle. Oracle JDBC Driver provides the Oracle
Universal Connection Pool (UCP) which includes this
Rainer Frey wrote:
On 12.03.2013, at 17:14, Christopher Schultz ch...@christopherschultz.net
wrote:
On 3/12/13 7:54 AM, amit shah wrote:
I am using Oracle. Oracle JDBC Driver provides the Oracle
Universal Connection Pool (UCP) which includes this
:
Hello, I would like to know if the tomcat jdbc pool (7.0.34+)
provides connection failover capabilities i.e. to transparently
close all the open database connections and switch to a another
database server on an planned/unplanned database server outage
event. I read through the tomcat
, 2013, at 12:52 AM, amit shah wrote:
Hello,
I would like to know if the tomcat jdbc pool (7.0.34+) provides
connection failover capabilities i.e. to transparently close all the
open
database connections and switch to a another database server on an
planned/unplanned database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Amit,
On 3/12/13 7:54 AM, amit shah wrote:
I am using Oracle. Oracle JDBC Driver provides the Oracle
Universal Connection Pool (UCP) which includes this
featurehttp://docs.oracle.com/cd/E11882_01/java.112/e16548/fstconfo.htmof
connection
amit shah wrote:
Hello,
I would like to know if the tomcat jdbc pool (7.0.34+) provides
connection failover capabilities i.e. to transparently close all the open
database connections and switch to a another database server on an
planned/unplanned database server outage event.
I
On Mar 11, 2013, at 12:52 AM, amit shah wrote:
Hello,
I would like to know if the tomcat jdbc pool (7.0.34+) provides
connection failover capabilities i.e. to transparently close all the open
database connections and switch to a another database server on an
planned/unplanned database
:
Hello,
I would like to know if the tomcat jdbc pool (7.0.34+) provides
connection failover capabilities i.e. to transparently close all the open
database connections and switch to a another database server on an
planned/unplanned database server outage event.
I read through
that even your backup database server would also be unreachable, no ?
Thanks.
On Mon, Mar 11, 2013 at 6:15 PM, Daniel Mikusa dmik...@vmware.com wrote:
On Mar 11, 2013, at 12:52 AM, amit shah wrote:
Hello,
I would like to know if the tomcat jdbc pool (7.0.34+) provides
connection failover
dmik...@vmware.com
wrote:
On Mar 11, 2013, at 12:52 AM, amit shah wrote:
Hello,
I would like to know if the tomcat jdbc pool (7.0.34+) provides
connection failover capabilities i.e. to transparently close all the
open
database connections and switch to a another database server
. Not a great solution, but sounds
similar to what you mentioned.
Dan
Thanks.
On Mon, Mar 11, 2013 at 6:15 PM, Daniel Mikusa dmik...@vmware.com wrote:
On Mar 11, 2013, at 12:52 AM, amit shah wrote:
Hello,
I would like to know if the tomcat jdbc pool (7.0.34+) provides
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Amit,
On 3/11/13 12:52 AM, amit shah wrote:
Hello, I would like to know if the tomcat jdbc pool (7.0.34+)
provides connection failover capabilities i.e. to transparently
close all the open database connections and switch to a another
database
Hi all,
We are using Tomcat 7.0.25 on CentOS 5.5 64b.
After problems with connection leak and deadlocks in DBCP we made a
decision to replace it with Tomcat JDBC-pool. Of course migration was
really simple.
But after deploy it on a production environment I noticed, that load on
a server
://tomcat.apache.org/tomcat-7.0-doc/changelog.html
After problems with connection leak and deadlocks in DBCP we made a decision
to replace it with Tomcat JDBC-pool. Of course migration was really simple.
But after deploy it on a production environment I noticed, that load on a
server
;
: Re: tomcat jdbc pool stackoverflow error used with spring
2012/12/2 ?? 22687...@qq.com:
Hi:
I'm evaluating jdbc pool after reading some blogs on tomcatexpert.com. But
when I try to switch to jdbc pool from dbcp, I'm getting stackoverflow error
like this:
Caused
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ahmed,
On 5/31/12 9:33 AM, S Ahmed wrote:
It would be easier if all databases were hosted by a single
instance of MySQL -- then you could use Tomcat-pool's feature of
being able to provide credentials when obtaining connections from
the pool --
On 30 May 2012, at 23:19, André Warnier a...@ice-sa.com wrote:
On Wed, May 30, 2012 at 10:07 AM, Christopher Schultz
ch...@christopherschultz.net wrote:
..
If my environment and requirements match yours, you'd need 1 *
max_pool_size * 66KiB at peak usage. That's about 640MiB for each
On 31 May 2012, at 00:49, Christopher Schultz
ch...@christopherschultz.net wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
André,
On 5/30/12 6:18 PM, André Warnier wrote:
Taking the same hypothetical case and figures :
Assuming that you need a total of (1 * 4 connections) =
It would be easier if all databases were hosted by a single instance
of MySQL -- then you could use Tomcat-pool's feature of being able to
provide credentials when obtaining connections from the pool -- and
get the right database. That way, a much smaller number of connections
could be maintained
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ahmed,
On 5/29/12 9:29 AM, S Ahmed wrote:
If my requirement for a hosted application is to give each
customer a separate instance of mysql, I am curious how feasible
that would be.
You can certainly do this.
What is the memory footprint for a
Chris,
Great thanks that is exactly what I was looking for, just to get an idea at
this point.
And yes it was for mysql.
I was thinking one could create a smarter pool, one that created more
connections for sites used more often, and less for others.
Much appreciated.
On Wed, May 30, 2012 at
On Wed, May 30, 2012 at 10:07 AM, Christopher Schultz
ch...@christopherschultz.net wrote:
..
If my environment and requirements match yours, you'd need 1 *
max_pool_size * 66KiB at peak usage. That's about 640MiB for each
connection you want in 10k pools. For a (uniform) max pool size of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
André,
On 5/30/12 6:18 PM, André Warnier wrote:
Taking the same hypothetical case and figures :
Assuming that you need a total of (1 * 4 connections) = 4
connections. Assuming that it takes 10ms to set up one such
connection, and that
- Original Message -
From: Colin Ingarfield colin...@gmail.com
To: Tomcat Users List users@tomcat.apache.org
Sent: Thursday, March 22, 2012 8:06:14 AM
Subject: Re: how to enable debug logging for Tomcat jdbc pool (Tomcat
6.0.32)
Ah, Wireshark. My friend calls
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
S Ahmed,
On 3/25/12 6:57 PM, S Ahmed wrote:
Why would you want to use a future?
Say in a web application, I can't really think of a reason why I
would use the future (asych) connection retrieval pattern. The #
of connections is always fixed,
2012/3/26 S Ahmed sahmed1...@gmail.com:
Is the jdbc pool somehow married to tomcat or can I use it with other
containers potentially? (
1. You certainly can use it with other containers.
But it depends on Tomcat version of logging library (That is
tomcat-juli.jar). You have to copy that jar as
Why would you want to use a future?
Say in a web application, I can't really think of a reason why I would use
the future (asych) connection retrieval pattern. The # of connections is
always fixed, I guess in a very high traffic environment where the # of
connections is the pool are used up,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Colin,
On 3/21/12 12:11 PM, Colin Ingarfield wrote:
I added the 3 abandoned settings but I don't see any indication in
the tomcat log that connections are being abandoned. I also made
the max pool size pretty small.. my application would have
Chris,
On Thu, Mar 22, 2012 at 7:40 AM, Christopher Schultz
ch...@christopherschultz.net wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Colin,
On 3/21/12 12:11 PM, Colin Ingarfield wrote:
I added the 3 abandoned settings but I don't see any indication in
the tomcat log that
: Wednesday, March 21, 2012 10:11:43 AM
Subject: Re: how to enable debug logging for Tomcat jdbc pool (Tomcat
6.0.32)
I added the 3 abandoned settings but I don't see any indication in
the
tomcat log that connections are being abandoned. I also made the max
pool
size pretty small.. my
debug logging for Tomcat jdbc pool (Tomcat 6.0.32)
Ah, Wireshark. My friend calls it the universal debugger. :)
I will set the validation interval to 1 and keep an eye on the
network to
see what's going on. I may also install MySql locally so I can kill
it
easily to try and simulation
colin...@gmail.com
To: Tomcat Users List users@tomcat.apache.org
Sent: Thursday, March 22, 2012 8:06:14 AM
Subject: Re: how to enable debug logging for Tomcat jdbc pool (Tomcat
6.0.32)
Ah, Wireshark. My friend calls it the universal debugger. :)
I will set the validation interval
1 - 100 of 192 matches
Mail list logo
