How to monitor DBCP Connection Pool usage in Konakart

[Shaiju B]

Hi All,

We are using the konakart for an online eCommerce store. We are facing issues with connection usage in MySQL side. For troubleshooting the issue I need to monitor the connection usage from the app server (DBCP Connection Pool). I have tried to get the connection usage using JMX attribute but I failed to get, since the connection usage is not exposed to JMX.

I would like to know your feedback/experience on monitoring the DBCP connection pool usage. Can I get the pool usage by writing a piece of code? The configuration I am using in konakart.properties & server details are given below:

Code Select Expand


torque.database.store1.adapter              = mysql
torque.dsfactory.store1.connection.driver   = com.mysql.jdbc.Driver
torque.dsfactory.store1.connection.url      = jdbc:mysql://XX.XX.XX.XX:XXXX/XXXX?zeroDateTimeBehavior=convertToNull
torque.dsfactory.store1.connection.user     = XXX
torque.dsfactory.store1.connection.password = XXX!
....

# Using commons-dbcp

torque.dsfactory.store1.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory


Web Server: Apache 2.2
App Server: Tomcat 7
DB Server: MySQL 5.5

Thanks,
Shaiju B