Performance Analysis of Database Connection Pool Technology Based on Queueing Model with Mixed Waiting and Loss
Jun Wu, Zhanqiang Huo · Journal of Software Engineering · 2016
Background and Objective: To reveal the dependency relationships between configuration parameters and performance measures of database connection pool technology, Geom/Geom/c/c+m discrete-time queuing model with multi-server and mixed waiting and loss is built according to its studying principles.Materials and Methods: Using the embedded Markov chain method, the one-step transition probability matrix and the recursive formula of this model are derived.The mathematical expressions of system performance measures are calculated by the theoretical analysis results of the model such as request blocking probability, system average waiting time, system utilization and system throughput etc. Conclusion: Finally, numerical examples are intuitively given to discuss the dependence relationships between system performance measures and configuration parameters.The study results can provide theoretical bases for the parameter configuration of database connection pool technology.