Method and device for dynamically distributing database connections

Abstract

The invention discloses a method and device for dynamically distributing database connection. The method comprises the following steps of: determining each thread in an active state at one or more time points in a predetermined time period in a thread pool; and recovering database connections corresponding to the other threads except each thread in the active state at the one or more time point inthe predetermined time period in the thread pool. According to the method and device, a thread monitoring mechanism and a database connection distribution mechanisms are established to monitor the active state of each thread in the thread pool and then recover the database connections corresponding to the idle threads in the thread pool, so that a function of recovering the idle database connections by an interface program is added, the idle database connections are released to business modules corresponding to other active threads, and the idle database connections are not occupied by the business modules in a long connection mode, thereby realizing dynamic application and using of the business modules and realizing a data connection releasing mechanism so as to achieve the aim of efficiently using the database connections.

Description

technical field [0001] The present invention relates to the computer field, and more specifically relates to a method and device for dynamically allocating database connections. Background technique [0002] Database connections are precious resources in data processing systems, and the management of database connections can significantly affect the scalability and robustness of the entire application, thereby affecting the performance indicators of the program. Establishing and disconnecting a database connection is a resource-consuming operation for a data processing system. At present, the database connection pool is used to solve the resource-consuming problem of establishing and disconnecting the database connection, that is, to put the frequently used database connection into the database connection pool, thereby improving the performance of the data processing system. [0003] Usually, the number of threads of different interface programs and the number of database c...

AI Technical Summary

Problems solved by technology

[0004] However, the database connection used by the interface program is generally a long connection, which leads to the fact that the database connection occupied by the interface program will not be released during the initialization phase of the business module or during the peak business period

Since the total number of database connections is limited, the number of database connections allocated to each business module is also limited

This brings the biggest bottleneck in the interaction between the interface program and the database, that is, the Internet channel requires the interface to provide higher concurrency, but the interface cannot apply for more database connections

Images