Method and device for dynamically setting connection parameters

Abstract

The present invention proposes a method and device for dynamically setting connection parameters. The method for dynamically setting connection parameters includes obtaining the current connection value of the connection parameter of the database connection pool and the current time point; obtaining at least one time point before the current time point The actual connection value of the upper connection parameter, and calculate the estimated connection value of the connection parameter according to at least one actual connection value; obtain the load index of the server where the database is located at the current point in time; according to the load index, current connection value and estimated connection value to the database The connection parameters of the connection pool are set dynamically. The invention can dynamically set the connection parameters of the database connection pool in combination with the estimated connection value of the connection parameters and the load index, effectively avoiding the overload of the server where the database is located, and improving 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