使用proxool配置连接池-实战配置

1、快速释放连接数配置如下：

 <?xml version="1.0" encoding="UTF-8"?>  
 
<something-else-entirely>  
    <proxool>  
        <alias>mysqlProxool</alias> 
        <driver-url>jdbc:mysql://127.0.0.1/shaiyaya</driver-url>
        <driver-class>com.mysql.jdbc.Driver</driver-class>
        <driver-properties>  
            <property name="user" value="root" />
            <property name="password" value="banpeizhi" />  
        </driver-properties>    
        <!--最大连接数量-->
        <maximum-connection-count>100</maximum-connection-count>
        <!--最小连接数-->    
        <minimum-connection-count>10</minimum-connection-count> 
        <!--连接活跃时间，时间越短，回收连接越快,防止连接数过多释放慢导致超出最大连接数-->   
        <maximum-active-time>6000000</maximum-active-time> 
        <!-- 自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁--> 
        <house-keeping-sleep-time>120000</house-keeping-sleep-time>  
        <maximum-new-connections>10</maximum-new-connections>    
        <prototype-count>1</prototype-count>    
        <house-keeping-test-sql>select sysdate from dual</house-keeping-test-sql>  
    </proxool>  
</something-else-entirely> 

快速释放配置注意：maximum-active-time:配置活跃时间大小，时间越短回收越快，house-keeping-test-sql：测试SQL,house-keeping-sleep-time:检测时间
2、配置proxool连接监控页面：

 <!--使用proxool查看数据库的运行状态-->  
    <servlet>  
        <servlet-name>proxool</servlet-name>  
        <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>  
    </servlet>  
    <servlet-mapping>  
        <servlet-name>proxool</servlet-name>  
        <url-pattern>/proxool</url-pattern>  
    </servlet-mapping>  

访问路径：工程名/proxool，观看Snqpshot中的Connections:active数量