Dynamic management method and system of database connection pool

A dynamic management and connection pooling technology, applied in the field of database management, can solve the problem of inability to dynamically adjust the connection pool, and achieve the effect of improving performance and dynamic adjustment.

Inactive Publication Date: 2016-12-21
GUANGZHOU PINWEI SOFTWARE
View PDF6 Cites 24 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The present invention provides a dynamic management method and system of a database connection pool, the main purpose of which is to s

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Dynamic management method and system of database connection pool
  • Dynamic management method and system of database connection pool
  • Dynamic management method and system of database connection pool

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0048] As an implementation manner, step S20 may include the following steps:

[0049] When the number of concurrent connections in the connection pool is continuously smaller than the minimum number of connections in the connection pool within a preset time period, the minimum number of connections in the connection pool is reduced.

[0050] If the number of concurrent connections in the connection pool continues to be less than the minimum number of connections in the connection pool within a certain period of time, it means that some database connections are currently idle, resulting in waste of resources. At this time, the minimum number of connections can be reduced to facilitate Idle connections are returned to the database so that the database can be allocated to other applications to avoid waste of resources due to idleness.

[0051] As another implementation manner, step S20 may include the following steps:

[0052] When the connection acquisition time is greater tha...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a dynamic management method of a database connection pool. The method flow comprises the following steps: acquiring running information about database connection in the connection pool at fixed time or in real time, wherein the running information comprises one or more of acquisition connection duration, connection occupation duration, connection concurrency and idle connection number; adjusting configuration parameters of the connection pool according to the acquired running information, wherein the configuration parameters comprise the maximum connection number and the minimum connection number of the connection pool; or adjusting the connection state of the database connection in the connection pool according to the acquired running information. The invention further provides a dynamic management system of the database connection pool. The technical problem that the connection pool cannot be dynamically adjusted is solved, and the performance of the database connection pool is improved.

Description

technical field [0001] The invention relates to the technical field of database management, in particular to a dynamic management method and system for a database connection pool. Background technique [0002] In today's Internet era of massive information, databases have been widely used in all walks of life from simple storage of various data forms to massive data storage. Therefore, the application of database connection pools is becoming more and more extensive, and database connection pools are responsible for allocation and management. And release the database connection, which allows the application to reuse an existing database connection instead of re-establishing one, which can improve the performance of database operations. Therefore, the performance of the connection pool directly determines the performance of accessing the database, which also determines the performance of the entire system. [0003] The existing management scheme of the database connection poo...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
CPCG06F16/25
Inventor 何涛宋威张学诚刘璟宇王军伟韩国忠余倩
Owner GUANGZHOU PINWEI SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap