一种数据库连接池的动态控制策略

A dynamic control policy for database connection pool

分析了传统数据库连接池的不足,提出了一种能根据连接请求数来动态地改变连接池内连接数目的策略。该策略的核心延迟释放算法能有效地控制每个连接的释放时机,使连接池既能在常规条件下满足正常的连接需求,又能应对大量的突发需求,而且该策略还能有效地节约系统资源和通信资源。测试结果显示,在有大量突发连接需求的环境中,使用该策略的连接池表现出了优于传统连接池的性能。

The disadvantage of connection pool in traditional database is analyzed and a policy by which connection pool can dynamically change the number of connection is presented according to connective request. Every release time of connections can be controlled effectively by this policy that makes the connection pool satisfy normal connective need and the need of abundant paroxysmal; furthermore, the system resources and communication costs can be saved effectively. The testing results show that the capability of connection pool using this policy precedes those traditional ones under circumstance when a great number of paroxysmal connections are needed.