Abstract: In order to configure the system parameters of database connection pool effectively,a Geom / Geom / c / c discrete-time queuing model with multi-server is built according to the operation mechanism of its manage process and the thought of discrete-time queuing theory． It uses the embedded Markov chain method, and the matrix of transition probability and matching recursive relations of the stationary queue length are given． The mathematical expressions of system performance measures are derived by the theoretical analysis results of the model,such as request blocking probability,average number of connections,system utilization,and system throughput,etc． Experiments are intuitively given to prove the dependencies between database connection pool performance index and system configuration parameters.

Key words: database connection pool, performance analysis, mathematical modeling, discrete-time queueing theory, Geom / Geom / c / c model, multi-server

摘要： 为有效地配置数据库连接池中的系统参数,根据数据库连接池管理过程的工作原理,引入离散时间排队论 的思想,建立多服务台损失制的Geom / Geom / c / c 离散时间排队模型。采用嵌入马尔科夫链方法,分析系统稳态队 长的转移概率矩阵及其满足的递推关系式。应用模型的理论分析结果,导出请求阻塞概率、系统平均连接数、系统 利用率、系统吞吐量等系统性能指标的数学表达式。通过实验证明了数据库连接池性能指标与系统配置参数之间 的依赖关系。

关键词: 数据库连接池, 性能分析, 数学建模, 离散时间排队论, Geom / Geom / c / c 模型, 多服务台

CLC Number: 

• TP302