[c3p0-users] c3p0 count spikes on possible database update/insert

[Charles R. <cha...@th...>]

Hi,

We have had issues in the past with slowness or outages on our site and
whenever this happened, c3p0 connections were usually high on one tomcat
instance (>100).

Today, I noticed the count went up above 100 around the time a script
performed a few updates/inserts on some large tables (1 of the tables > 20
GBs and 2nd table > 5 GBs).

I created a tomcat thread dump to see if anything was blocking but nothing
looked like it was. However, it is very unusual with the lower traffic this
time of year for us for c3p0 connections to jump that high.

I believe something spiked those c3p0 connections and whatever that is, is
causing us issues when it does.

Any thoughts?

Cheers!