c3p0参数试探

数据库最大连接数为20
经常出现最大连接数错误has exceeded the 'max_user_connections' resource (current value: 20)

c3p0.acquireIncrement=3
c3p0.initialPoolSize=3
c3p0.idleConnectionTestPeriod=60
c3p0.minPoolSize=3
c3p0.maxPoolSize=19
c3p0.maxStatements=100
c3p0.numHelperThreads=10
c3p0.maxIdleTime=60

现改下：

c3p0.acquireIncrement=3
c3p0.initialPoolSize=5

#每60秒检查所有连接池中的空闲连接
c3p0.idleConnectionTestPeriod=60
c3p0.minPoolSize=5
c3p0.maxPoolSize=19
c3p0.maxStatements=100
c3p0.numHelperThreads=10
#最大空闲时间,60秒内未使用则连接被丢弃。若为0则永不丢弃
c3p0.maxIdleTime=5