Unlock instant, AI-driven research and patent intelligence for your innovation.

Connection thread monitoring method and device for connection pool, medium and equipment

A connection pool and thread technology, applied in the computer field, can solve problems such as database downtime, connection pool resource exhaustion, database failure to write information normally, etc., and achieve the effect of improving stability

Pending Publication Date: 2021-12-07
ONE CONNECT SMART TECH CO LTD SHENZHEN
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, since the resources of the connection pool are limited, if the connection thread is occupied for a long time, the resources of the connection pool will be exhausted, and the database will not be able to write information normally, and there may even be a risk of database downtime

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
  • Connection thread monitoring method and device for connection pool, medium and equipment
  • Connection thread monitoring method and device for connection pool, medium and equipment
  • Connection thread monitoring method and device for connection pool, medium and equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0069] figure 1 It is a flow chart of the connection thread monitoring method of the connection pool provided in Embodiment 1 of the present application. This embodiment is applicable to the scene of data access to the database through the connection thread in the connection pool. This method can be provided by the embodiment of the present application. The connection thread monitoring device of the connection pool is executed, and the device can be realized by software and / or hardware, and can be integrated into an electronic device for managing the connection pool or managing the database.

[0070] Such as figure 1 As shown, the connection thread monitoring method of the connection pool includes:

[0071] S110, if it is detected that a connection pool management event occurs to a connection thread in the connection pool, determine an event type of the connection pool management event; the event type includes an abnormal number of connection threads or an abnormal connection...

Embodiment 2

[0086] figure 2 It is a flow chart of the connection thread monitoring method of the connection pool provided by Embodiment 2 of the present invention. This embodiment is optimized on the basis of the foregoing embodiments. The specific optimization is: the abnormal number of connection threads includes that the number of connection threads in the connection pool reaches a preset threshold; correspondingly, according to the event type, determining the target connection thread in the connection pool includes: according to the abnormal number of connection threads event type, determine that the target connection thread in the connection pool is all the connection threads in the connection pool; correspondingly, monitor and process the target connection thread according to the processing mode associated with the event type, including: According to the processing method associated with the above event types, all connection threads in the connection pool are initialized.

[0087]...

Embodiment 3

[0109] image 3 It is a flow chart of the connection thread monitoring method of the connection pool provided by Embodiment 3 of the present invention. This embodiment is optimized on the basis of the foregoing embodiments. The specific optimization is: the connection thread state abnormality includes the connection thread in the connection pool being in the state of being disconnected from the database, the establishment time reaching the set life cycle state, or at least one of the state of no data transmission within the preset time length state; correspondingly, according to the event type, determining the target connection thread in the connection pool includes: determining that the target connection thread in the connection pool is a connection thread with an abnormal connection thread state according to the event type of the abnormal state of the connection thread ; Correspondingly, monitoring and processing the target connection thread according to the processing metho...

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 relates to the technical field of computers. The embodiment of the invention discloses a connection thread monitoring method and device for a connection pool, a medium and equipment. The connection pool is provided by the database and is used for providing a connection thread to be connected with the application server. The method is executed by a connection pool thread management end, and the connection pool thread management end is connected with a database and an application server. The method comprises: if it is detected that a connection pool management event happens to a connection thread in a connection pool, determining the type of the event; determining a target connection thread in a connection pool according to the event type; if the event type is that the number of the connecting threads is abnormal, determining that a processing mode is to initialize a connecting pool to which the target connecting thread belongs; and if the event type is that the state of the connecting thread is abnormal, determining that the processing mode is to reset the target connecting thread. According to the scheme, the connection pool can be managed according to the use condition of the connection thread, and stable operation of the database is ensured by monitoring the connection pool in real time.

Description

technical field [0001] The embodiments of the present application relate to the field of computer technology, and in particular to a connection thread monitoring method, device, medium and equipment of a connection pool. Background technique [0002] With the rapid development of the information age and the extensive advancement of database applications, most online businesses require the support of databases. In order to speed up the connection between the server and the database, after the database is constructed, developers will be required to connect to the database through the connection pool, and then carry out business such as program development, optimization and maintenance. However, since the resources of the connection pool are limited, if the connection thread is occupied for a long time, the resources of the connection pool will be exhausted, the database cannot write information normally, and there may even be a risk of database downtime. Contents of the inve...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/30G06F11/32
CPCG06F11/3034G06F11/327
Inventor 吴宇
Owner ONE CONNECT SMART TECH CO LTD SHENZHEN