计算机工程
計算機工程
계산궤공정
COMPUTER ENGINEERING
2014年
10期
32-36
,共5页
数据库连接池%性能分析%数学建模%离散时间排队论%Geom/Geom/c/c模型%多服务台
數據庫連接池%性能分析%數學建模%離散時間排隊論%Geom/Geom/c/c模型%多服務檯
수거고련접지%성능분석%수학건모%리산시간배대론%Geom/Geom/c/c모형%다복무태
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離散時間排隊模型。採用嵌入馬爾科伕鏈方法,分析繫統穩態隊長的轉移概率矩陣及其滿足的遞推關繫式。應用模型的理論分析結果,導齣請求阻塞概率、繫統平均連接數、繫統利用率、繫統吞吐量等繫統性能指標的數學錶達式。通過實驗證明瞭數據庫連接池性能指標與繫統配置參數之間的依賴關繫。
위유효지배치수거고련접지중적계통삼수,근거수거고련접지관리과정적공작원리,인입리산시간배대론적사상,건립다복무태손실제적Geom/Geom/c/c리산시간배대모형。채용감입마이과부련방법,분석계통은태대장적전이개솔구진급기만족적체추관계식。응용모형적이론분석결과,도출청구조새개솔、계통평균련접수、계통이용솔、계통탄토량등계통성능지표적수학표체식。통과실험증명료수거고련접지성능지표여계통배치삼수지간적의뢰관계。
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.