I’m trying to use C3P0 library to handle connection pooling.
These are my C3P0 settings:
minPoolSize=3 maxPoolSize=20 acquireIncrement=1 maxIdleTime=240 maxStatements=20
In the log I can see that C3P0 seems to be correctly initialized by reading
INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource - Initializing c3p0 pool...
But when I try so see how many connection there are on my MySQL db with
SHOW STATUS WHERE `variable_name` = 'Threads_connected'
I can see that the result is 48, 46, 49 ecc.
I can’t understand if is not correct the way I try to see how many connections there are on the db or I did’t understand the way C3P0 works