DBCP数据库连接池的自优化配置

以Apache的一个开源连接池组件Commons DBCP为研究对象,分析它在连接池容量管理上的自优化机制。然后针对连接池参数配置缺少可量化标准的问题,提出一种根据运行日志优化配置参数并通过后台管理接口动态调整配置参数的方法,可以得到最适合当前应用状况的参数取值,能在不重启Web服务器的情况下使新的配置生效。优化的参数配置可以充分发挥DBCP连接池自优化管理机制的功效。

Self-optimized Configuration of DBCP

With an open-source Apache＇s Commons DBCP connection pool component as the study object,its self-optimized mechanism in the pool size management is analyzed.For the lack of quantifiable standards to configure the pool parameters,the methods are given,which optimized parameters according to the running log and dynamically adjusted parameters by the management interface.So the configuration suitable to the current running status is obtained,and the new configuration takes effect without restarting the Web Server.The optimizing configuration can give full play to the efficiency of DBCP self-optimizing management mechanism.