Sorry for the late reply. Looking at the data, I don't see anything wrong. As
you pointed out, with taking a snapshot every minute your could have missed the
time when the ConnectionCount == InUseConnectionCount.
Your database might also keep track of connection counts in one way or another,
Peter, thanks for the reply.
View the original post :
http://www.jboss.org/index.html?module=bbop=viewtopicp=4217937#4217937
Reply to the post :
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=4217937
___
jboss-user mailing list
PeterJ wrote :
| You could always post the raw data for your graph and I could replot it.
Hopefully you have it as a CSV file or something like that.
I have some data in csv format. The data was taked with a process every minute.
If you graph the data you can see what I see.
The ConnectionCount is the total number of connections that have been
established since JBoss AS started. Consider this scenario. An app accesses the
database so 5 connections (min-pool-size) are created. Then the app gets busy
and it needs more connections, let's say a total of 20 connections.
Oh, and is the above scenario plays out several times (in use connections
increasing and decreasing) you could end up with a ConnectionCount of 50 or 100
or 200...
View the original post :
http://www.jboss.org/index.html?module=bbop=viewtopicp=4216309#4216309
Reply to the post :
PeterJ wrote : The ConnectionCount is the total number of connections that
have been established since JBoss AS started. Consider this scenario. An app
accesses the database so 5 connections (min-pool-size) are created. Then the
app gets busy and it needs more connections, let's say a total of
You are correct. I didn't look at all of the properties of the mbean before I
replied, and instead replied based on my memory which is apparently
deteriorating faster than I care to admit! ;-)
In your graph, what is the highest that InUseConnectionCount goes?
You could always post the raw data
Right now, the propertie MaxConnectionsInUseCount is 34.
I have to flush the pool to initilize all the pool properties in 0 and give you
correct data.
Thanks
View the original post :
http://www.jboss.org/index.html?module=bbop=viewtopicp=4216347#4216347
Reply to the post :
jguser wrote :
| We have a average of a 16.88 of difference between de ConnectionCount and
InUseConnectionCount
|
What does 16.88 mean here ?
jguser wrote :
| Anyone can tell me wich is the behavior of the connection pool?? When he
creates new connection that re don't realy needs?
|