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

A database connection pool abnormality monitoring method, device and computer equipment

A connection abnormality and abnormality monitoring technology, applied in the computer field, can solve the problem of not being able to know whether there is abnormality in the database connection pool, and achieve the effect of rapid discovery

Active Publication Date: 2021-03-26
NETWORKBENCH SYST
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the related technology, the database connection is cached in the database connection pool, which can reduce the overhead of system resources, but it is impossible to know whether there is an abnormality in the operation of the database connection pool

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
  • A database connection pool abnormality monitoring method, device and computer equipment
  • A database connection pool abnormality monitoring method, device and computer equipment
  • A database connection pool abnormality monitoring method, device and computer equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

[0025] In the following description, the use of suffixes such as 'module', 'part' or 'unit' for denoting elements is only for facilitating the description of the present application and has no specific meaning by itself. Therefore, 'module', 'part' or 'unit' may be used in combination.

[0026] figure 1 It is a flow chart of an implementation mode of the database connection pool abnormality monitoring method provided by this application, such as figure 1 As shown, the database connection pool abnormality monitoring method includes step S102 to step S116.

[0027] Step S102, monitoring a database connection acquisition request, wherein the database connection acquisition request is configured to acquire a database connection in a database connection pool.

[0028] In the embodiment of the presen...

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 present application relates to a database connection pool abnormality monitoring method, device, and computer equipment, wherein the method includes: recording the start time of the acquisition when the database connection acquisition request is monitored; recording the acquisition end time when the database connection acquisition success message is monitored Time; according to the acquisition start time and acquisition end time corresponding to the database connection acquisition request, determine the acquisition connection time of the database connection acquisition request; determine the average acquisition connection time of the database connection pool according to the acquisition connection time of multiple database connection acquisition requests and the standard deviation of time-consuming to obtain connection; according to the average time-consuming to obtain connection and the standard deviation of time-consuming to obtain connection, determine the abnormal threshold of connection acquisition of the database connection pool; An exception to the database connection pool. Through this application, the monitoring of the database connection pool is realized.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a database connection pool abnormality monitoring method, device and computer equipment. Background technique [0002] In the application system based on JAVA, especially the application system for enterprise users, the database is one of its essential components. In order to solve the performance loss caused by creating and destroying database connections caused by frequent access to the database, the application system introduces the database connection pool technology. The basic idea of ​​the database connection pool is to build a "buffer layer" for the database connection. When the database connection pool is initialized, a certain number of database connections are created and placed in the database connection pool. The number of initially created database connections is determined by the set minimum number of connections. At the same time, the maximum number of ...

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 Patents(China)
IPC IPC(8): G06F11/30
CPCG06F11/302G06F11/3051
Inventor 张鑫
Owner NETWORKBENCH SYST