Research On Connection Pool Optimization Of Online Registration System Based On M/M/n/m Model

Web applications requiring higher interactive performance,the greater amount of concurrent,the higher performance requirements of system.If the design of database is unreasonable,it will result in client and server programming and maintenance becoming more difficult,but also affect system performance.Connection pool is an important part of database,it's efficiency directly affects the efficiency of the whole system.Connection pooling is a technique,in order to solve waste of resources caused by frequently creating and closing connections when the system is running.It avoids reducing performance of Web system.When we configure the connection pool's parameters,one of the questions is how to make the connection pool more efficient.On this basis,with the purpose of providing a mathematical basis for the optimization system,in this paper,we will analyze the performance of connection pool with multi-server hybrid queuing model firstly,then analyze the relationship between system performance and configuration parameters by using the desire model.For the sake of reducing system's response time,this paper will model and analyze the connection pool configuration of online registration system with queuing method.On the basis of connection pool's working principle connection pool,the connection is abstracted as a service window,and the connection request is abstracted as a customer.Then,a model of multi-server hybrid M/M/n/m is established to calculate the stationary distribution and key performance indicators of this queuing system.Then,we execute stress tests on the online registration system with JMeter and get the log files that record database connection information.According to the log files,we collect experimental data so as to calculate input intensity of connection request and service strength of system.Next,we validate the two data,use Lingo to model and calculate the system's key performance indicators.At the same time,record the system test results.Finally,we set the desire model.According to this model,the minimum number of connections in the connection pool is calculated at a loss rate of less than 2%.In the meantime,we take into account the utilization of connection in connection pool,select the appropriate parameters.Under the same test conditions,comparing the pre-optimized and optimized test data,verifing limit concurrent of Web application.we can conclude that this model is not only significantly to improve the efficiency of the connection pool,but also improve system performance too.