Dynamic setting method and device for connection parameters

Abstract

The invention proposes a dynamic setting method and device for connection parameters, and the method comprises the steps: obtaining a current connection value of a connection parameter of a database connection pool and the current time point; obtaining the actual connection value of connection parameter at at least one time point before the current time point, and calculating the estimated connection value of the connection parameter according to at least one actual connection value; obtaining the load index of a server where a database is located at the current time point; and carrying out the dynamic setting of the connection parameter of the database connection pool according to the load index, the current connection value and the estimated connection value. According to the invention, the method can achieve a purpose of dynamically setting the connection parameter of the database connection pool through combining the estimated connection value of the connection parameter and the load index, effectively prevents the overloading condition of the server where the database is located, and improves the setting effect of the connection parameters.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a method and device for dynamically setting connection parameters. Background technique [0002] In some application scenarios, such as a web application system, the application server generally opens an independent thread for each client (ie, a session, session) access, so as to improve the performance of the application system. At this time, if the database access is established, used, and closed by a single thread, it will seriously block the efficiency of multi-threaded execution, and the establishment of a database access will consume large system resources and time. If the database is frequently established and closed Access will greatly reduce system performance, therefore, the database connection pool came into being. [0003] Generally, when the database connection pool is established, several data connections are initialized and wait for the application program to...

AI Technical Summary

Problems solved by technology

[0004] In related technologies, it is necessary to manually set the parameters of the database connection pool. For example, by manually writing the parameters into a configuration file, the database connection pool loads the configuration file to set the parameters. The parameters of the database connection pool cannot be dynamically adjusted according to the load of the server where the database is located. If the connection pool parameter setting is too high, it will easily cause waste of resources; if the setting is too small, it will affect the number of concurrent accesses, and the setting effect of connection parameters will be poor

Images