mysql pooling_Spring 中 C3p0 connection pooling 连接池的配置

class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

classpath:jdbc.properties

jdbc.properties

# Database URL

jdbc.url=jdbc:mysql://192.168.0.25"3306/db

# Database login information

jdbc.username=root

jdbc.password=

# Time to wait for an open connection before timing out

# (in milliseconds)

cpool.checkoutTimeout=5000

# Connection pool size

cpool.minPoolSize=5

cpool.maxPoolSize=40

# How long to keep unused connections around(in seconds)

# Note: MySQL times out idle connections after 8 hours(28,800 seconds)

# so ensure this value is below MySQL idle timeout

cpool.maxIdleTime=25200

# How long to hang on to excess unused connections after traffic spike

# (in seconds)

cpool.maxIdleTimeExcessConnections=1800

# Acquiring new connections is slow, so eagerly retrieve extra connections

# when current pool size is reached

cpool.acquireIncrement=5

分享到：

2011-06-30 10:14

浏览 1463

评论