CN111767187A - Method for monitoring JDBC connection pool state and related equipment - Google Patents

Method for monitoring JDBC connection pool state and related equipment Download PDF

Info

Publication number
CN111767187A
CN111767187A CN202010424114.4A CN202010424114A CN111767187A CN 111767187 A CN111767187 A CN 111767187A CN 202010424114 A CN202010424114 A CN 202010424114A CN 111767187 A CN111767187 A CN 111767187A
Authority
CN
China
Prior art keywords
connection pool
jdbc connection
jdbc
available
insufficient
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202010424114.4A
Other languages
Chinese (zh)
Other versions
CN111767187B (en
Inventor
吕震
陈洁
李颖
李颢
周政明
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Construction Bank Corp
Original Assignee
China Construction Bank Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Construction Bank Corp filed Critical China Construction Bank Corp
Priority to CN202010424114.4A priority Critical patent/CN111767187B/en
Publication of CN111767187A publication Critical patent/CN111767187A/en
Application granted granted Critical
Publication of CN111767187B publication Critical patent/CN111767187B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/3003—Monitoring arrangements specially adapted to the computing system or computing system component being monitored
    • G06F11/302—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system component is a software system
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/3055—Monitoring arrangements for monitoring the status of the computing system or of the computing system component, e.g. monitoring if the computing system is on, off, available, not available
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/3089—Monitoring arrangements determined by the means or processing involved in sensing the monitored data, e.g. interfaces, connectors, sensors, probes, agents
    • G06F11/3093—Configuration details thereof, e.g. installation, enabling, spatial arrangement of the probes
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/32—Monitoring with visual or acoustical indication of the functioning of the machine
    • G06F11/324—Display of status information
    • G06F11/327—Alarm or error message display
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/80—Database-specific techniques
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/865—Monitoring of software

Abstract

The disclosure provides a method, a device and related equipment for monitoring the state of a JDBC connection pool, and relates to the technical field of operation and maintenance. The method comprises the following steps: acquiring state information of the JDBC connection pool every other designated time period to obtain the state information of the JDBC connection pool at a plurality of time points; judging whether the available connection number of the JDBC connection pool is sufficient or not according to the state information of the continuously set time points up to the current time point; and if the number of the available connections of the JDBC connection pool is insufficient, generating early warning information that the number of the available connections of the JDBC connection pool is insufficient. The method provided by the disclosure can monitor the state of the JDBC connection pool and early warn in advance when the available connection number is insufficient, so that the intervention can be performed in advance.

Description

Method for monitoring JDBC connection pool state and related equipment
Technical Field
The invention relates to the technical field of operation and maintenance, in particular to a method for monitoring the state of a JDBC connection pool and related equipment.
Background
With the gradual expansion of the application scale of the data center, especially the wide application of cloud computing and distributed architecture, the application demands the middleware to be used more and more frequently. Weblogic is one of the best J2EE tools in the current market, has good expansibility and reliability, and can greatly simplify the development of applications and services.
For medium and large OLTP (On-Line Transaction Processing) applications, the Java Data Base Connectivity (JDBC) connection pool of Weblogic can greatly reduce the overhead required by the applications to connect databases. When the application program needs to access the database, only one connection needs to be acquired from the connection pool, and the connection is released after the application program is used, so that frequent creation and closing of database connection are avoided.
However, with more and more complex application logic and more functional modules, when an application program uses the JDBC connection pool of the Weblogic middleware, it often happens that the database connection cannot be released in time due to the situations of large data volume query, table locking waiting between transactions, and untimely closing of an opened connection, and finally a new application request fails due to failure to acquire the database connection. When a problem occurs, the application program cannot provide service completely under most conditions, and the fault site information cannot be retained, and the operation and maintenance personnel of the data center need to spend a lot of time to analyze the fault reason and then carry out fault recovery, thereby not only causing service interruption, but also wasting a lot of energy of the operation and maintenance personnel.
Disclosure of Invention
In order to solve the above technical problems in the prior art, embodiments of the present invention provide a method, an apparatus, and related devices for monitoring a JDBC connection pool state.
In one aspect, an embodiment of the present invention provides a method for monitoring a JDBC connection pool state, where the method includes:
acquiring state information of the JDBC connection pool every other designated time period to obtain the state information of the JDBC connection pool at a plurality of time points;
judging whether the available connection number of the JDBC connection pool is sufficient or not according to the state information of the continuously set time points up to the current time point;
and if the number of the available connections of the JDBC connection pool is insufficient, generating early warning information that the number of the available connections of the JDBC connection pool is insufficient.
In one embodiment of the invention, the method further comprises:
the method comprises the steps of scanning an installation directory and an application deployment directory of the Weblogic, detecting and identifying an application program calling Weblogic service and JDBC connection pool information used by the application program.
In an embodiment of the present invention, the status information includes: current number of available connections, total number of connections.
In an embodiment of the present invention, the determining whether the number of available connections of the JDBC connection pool is sufficient according to the state information of the set time points up to the current time point includes:
and if the number of available connections of the JDBC connection pool to the continuously set time points of the current time point is continuously lower than a set threshold, determining that the number of available connections of the JDBC connection pool is insufficient, wherein the set threshold is a set percentage of the total number of connections of the JDBC connection pool.
In one embodiment of the invention, the method further comprises:
when the available connection number of the JDBC connection pool is insufficient, detecting whether a dump log switch is turned on;
if the file is started, the dump file is automatically generated.
In one embodiment of the invention, the method further comprises:
when the number of available connections of the JDBC connection pool is insufficient, detecting whether a suspicious SQL statement switch is turned on or not;
and if the SQL statement file is started, acquiring the multiple pieces of SQL statement information of the current most consumed database performance, and generating a suspicious SQL statement file.
In one embodiment of the invention, the method further comprises:
when the available connection number of the JDBC connection pool is insufficient, detecting whether an automatic recovery switch is started or not;
and if the JDBC connection pool is started, automatically restarting the application program and recovering the connection between the application program and the JDBC connection pool.
In another aspect, an embodiment of the present invention provides an apparatus for monitoring a JDBC connection pool state, where the apparatus includes:
the state information acquisition module is used for acquiring the state information of the JDBC connection pool every other designated time period to obtain the state information of the JDBC connection pool at a plurality of time points;
the judging module is used for judging whether the available connection number of the JDBC connection pool is sufficient or not according to the state information of the continuously set time points up to the current time point;
and the early warning module is used for generating early warning information that the available connection number of the JDBC connection pool is insufficient when the available connection number of the JDBC connection pool is insufficient.
In one embodiment of the invention, the apparatus further comprises:
and the connection pool detection module is used for scanning the installation directory and the application program deployment directory of the Weblogic, and detecting and identifying the application program calling the Weblogic service and the JDBC connection pool information used by the application program.
In an embodiment of the present invention, the status information includes: current number of available connections, total number of connections.
In an embodiment of the present invention, the determining whether the number of available connections of the JDBC connection pool is sufficient according to the state information of the set time points up to the current time point includes:
and if the number of available connections of the JDBC connection pool to the continuously set time points of the current time point is continuously lower than a set threshold, determining that the number of available connections of the JDBC connection pool is insufficient, wherein the set threshold is a set percentage of the total number of connections of the JDBC connection pool.
In one embodiment of the invention, the apparatus further comprises:
a log generation switch detection module for detecting whether the dump log switch is turned on when the available connection number of the JDBC connection pool is judged to be insufficient,
and the log generation module is used for automatically generating the dump log file when the dump log switch is turned on.
In one embodiment of the invention, the apparatus further comprises:
the suspicious SQL statement switch detection module is used for detecting whether a generated suspicious SQL statement switch is turned on or not when the number of the available connections of the JDBC connection pool is judged to be insufficient;
and the suspicious SQL statement generating module is used for acquiring the plurality of pieces of SQL statement information of the current most consumed database performance when the suspicious SQL statement switch is opened, and generating a suspicious SQL statement file.
In one embodiment of the invention, the apparatus further comprises:
the automatic recovery switch detection module is used for detecting whether an automatic recovery switch is started or not when the available connection number of the JDBC connection pool is judged to be insufficient;
and the automatic recovery module is used for automatically restarting an application program and recovering the connection between the application program and the JDBC connection pool when the automatic recovery switch is started.
In yet another aspect, an embodiment of the present invention provides a computer storage medium having stored thereon computer instructions executable by a processor to implement a method for monitoring JDBC connection pool status according to any one of the foregoing embodiments.
In another aspect, an embodiment of the present invention provides a computer device, including:
a memory having a computer program stored thereon;
a processor configured to execute the computer program to implement the method for monitoring JDBC connection pool status according to any of the foregoing embodiments.
Compared with the prior art, the embodiment of the invention has the following beneficial technical effects:
according to the embodiment of the invention, the state information of the JDBC connection pool is collected at intervals of a specified time period, whether the available connection number of the JDBC connection pool is sufficient or not is judged according to the state information of the continuously set time points from the current time point, and the early warning information is generated when the available connection number is insufficient, so that operation and maintenance personnel can intervene in advance when the application program is not abnormal.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow diagram of a method of monitoring JDBC connection pool status according to one embodiment of the present invention;
FIG. 2 is a flow diagram of a method of monitoring JDBC connection pool status according to another embodiment of the present invention;
fig. 3 is a schematic structural diagram of an apparatus for monitoring JDBC connection pool status according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, embodiments of the present invention will be described in detail with reference to the accompanying drawings. It is to be understood that the following examples are illustrative only and are not intended to limit the scope of the present invention.
Referring to fig. 1, a flowchart of a method for monitoring JDBC connection pool status according to an embodiment of the present invention is shown, and as shown in fig. 1, the method includes:
s101: and collecting the state information of the JDBC connection pool every other specified time period to obtain the state information of the JDBC connection pool at a plurality of time points.
Specifically, the installation directory and the application deployment directory of the Weblogic may be scanned first, the application program calling the Weblogic service and the JDBC connection pool information used by the application program are detected and identified, and then the JDBC connection pool used by the application program is monitored by using the monitoring method described in this embodiment. For example, the JDBC configuration file may be searched according to the installation directory of Weblogic, the user name of the application program, the Weblogic domain name of the application program, and the keyword of the JDBC connection pool filename, so as to detect which application programs are calling the Weblogic service, whether the application programs use the JDBC connection pool, whether multiple JDBC connection pools are used, and multiple JDBC data sources are configured. And if the application program uses a plurality of JDBC connection pools and is configured with a plurality of JDBC data sources, respectively monitoring the plurality of JDBC connection pools used by the application program.
S102: and judging whether the available connection number of the JDBC connection pool is sufficient or not according to the state information of the continuously set time points until the current time point.
The time period for acquiring the JDBC connection pool state information interval may be set as required, and may be 1 minute, 5 minutes, 10 minutes, or the like. The JDBC connection pool state information collected may include, but is not limited to: the number of available connections, the total number of connections in the connection pool (i.e., the upper limit of the number of connections in the connection pool), the number of leaks in the connection pool, the number of currently active connections, etc. When the collected connection pool state information is the available connection number and the total connection number, whether the available connection number of the connection pool is sufficient or not can be judged through the following logics:
and if the number of the available connections of the JDBC connection pool to the continuously set time points of the current time point is continuously lower than the set threshold, determining that the number of the available connections of the JDBC connection pool is insufficient. The set threshold may be a set percentage of the total connection number of the JDBC connection pool, and may be set to 10%, 15%, or the like of the total connection number according to the system requirement. The number of settings of the number of successive settings of the time point up to the current time point may also be set according to system requirements, but empirically, the number of settings of the time point should generally be greater than 5. For example, whether the number of available connections of the JDBC connection pool is sufficient may be determined according to the state information of 5 consecutive time points up to the current time point and 10 consecutive time points up to the current time point.
For example, if the time interval for acquiring the state information of the JDBC connection pool is 1 minute, the set number of set time points up to the current time point is 5, the set threshold is 10% of the total number of connections, and the current time point is 10 th minute, the available number of connections and the total number of connections up to 5 consecutive time points up to the current time point, that is, the available number of connections and the total number of connections in 6 th, 7 th, 8 th, 9 th, and 10 th minutes, may be obtained, and it is determined whether the available number of connections at the 5 time points is less than 10% of the total number of connections, and if so, it is determined that the available number of connections of the JDBC connection pool is insufficient.
Of course, in other embodiments, other state information may be adopted, and other determination logic is adopted to determine whether the available connection number of the JDBC connection pool is sufficient, which is not limited in this invention.
S103: and if the number of the available connections of the JDBC connection pool is insufficient, generating early warning information that the number of the available connections of the JDBC connection pool is insufficient.
In some embodiments, after the early warning information is generated, the early warning information may be output to prompt the operation and maintenance personnel to perform manual intervention in advance. In other embodiments, if an automatic processing scheme is set, the advance intervention may also be performed automatically. For example, when the number of available connections in the JDBC connection pool is insufficient, it may be detected whether the dump log switch is turned on; if the hardware is started, the dump file is automatically generated so as to keep the current states of weblogic execution threads and the like, and the subsequent fault analysis is convenient to perform. For another example, when the number of available connections in the JDBC connection pool is insufficient, it may also be detected whether the generated suspicious SQL statement switch is turned on; if so, multiple pieces of SQL statement information (e.g., SQL statement with performance cost ranking top 5) that currently consumes the most database performance may be obtained to generate an SQL statement file for subsequent analysis. For another example, when the available connection number of the JDBC connection pool is not sufficient, whether the automatic recovery switch is turned on may also be detected; and if the JDBC connection pool is started, automatically restarting the application program and recovering the connection between the application program and the JDBC connection pool so as to recover in advance before the application cannot provide services. Through setting and detecting the switch, the embodiment can flexibly switch between manual intervention and automatic processing schemes, and provides a more flexible and reliable advanced intervention mode for operation and maintenance personnel.
The method for monitoring the JDBC connection pool state according to the present invention is described below with reference to specific examples. Fig. 2 is a flowchart illustrating a method for monitoring JDBC connection pool status according to another embodiment of the present invention, and as shown in fig. 2, the method for monitoring JDBC connection pool status according to this embodiment includes:
s201: scanning an installation directory and an application deployment directory of Weblogic, and detecting and identifying an application program calling Weblogic service and JDBC connection pool information used by the application program;
s202: the JDBC connection pools used by the application program are monitored as described in S203 to S211 below:
s203: collecting the state information of the JDBC connection pool at intervals of a specified time period;
s204: judging whether the available connection number of the JDBC connection pool is sufficient or not according to the state information of the continuously set time points up to the current time point; if sufficient, go to S203; if not, go to S205;
s205: detecting whether a dump log switch is turned on; if the starting is finished, the step goes to S206; if not, go to S207;
s206: generating a dump file;
s207: detecting whether a suspicious SQL statement switch is turned on, if so, turning to S208; if not, go to S209;
s208: acquiring a plurality of SQL sentences with the most consumed database performance at present, and generating suspicious SQL sentence files;
s209: generating early warning information that the available connection number of the JDBC connection pool is insufficient;
s210: detecting whether the automatic recovery switch is turned on, and if so, turning to S211; if not, go to S203;
s211: the application is automatically restarted and connection of the application to the JDBC connection pool is restored, followed by proceeding to S203.
Fig. 3 is a schematic diagram illustrating an apparatus for monitoring JDBC connection pool status according to an embodiment of the present invention. As shown in fig. 3, the apparatus 10 for monitoring JDBC connection pool status according to this embodiment includes:
the state information acquisition module 11 is configured to acquire state information of the JDBC connection pool every specified time period, so as to obtain state information of the JDBC connection pool at multiple time points;
a judging module 12, configured to judge whether the available connection number of the JDBC connection pool is sufficient according to state information of a continuously set time point up to a current time point;
and the early warning module 13 is configured to generate early warning information that the available connection number of the JDBC connection pool is insufficient when the available connection number of the JDBC connection pool is insufficient.
In one embodiment of the present invention, the apparatus 10 further comprises:
and the connection pool detection module 14 is configured to scan the installation directory and the application deployment directory of the Weblogic, and detect and identify an application program calling the Weblogic service and JDBC connection pool information used by the application program.
In an embodiment of the present invention, the status information includes: current number of available connections, total number of connections.
In an embodiment of the present invention, the determining whether the number of available connections of the JDBC connection pool is sufficient according to the state information up to the set number before the current time point includes:
and if the number of available connections of the JDBC connection pool to the continuously set time points of the current time point is continuously lower than a set threshold, determining that the number of available connections of the JDBC connection pool is insufficient, wherein the set threshold is a set percentage of the total number of connections of the JDBC connection pool.
In one embodiment of the present invention, the apparatus 10 further comprises:
a log generation switch detection module 15, configured to detect whether the dump log switch is turned on when determining that the available connection number of the JDBC connection pool is insufficient,
and the log generation module 16 is configured to generate a dump log file when the dump log switch is turned on.
In one embodiment of the present invention, the apparatus 10 further comprises:
a suspicious SQL statement switch detection module 17, configured to detect whether a generated suspicious SQL statement switch is turned on when determining that the available connection number of the JDBC connection pool is insufficient;
and the suspicious SQL statement generating module 18 is configured to obtain the multiple SQL statements consuming the performance of the current database when the suspicious SQL statement switch is turned on, and generate a suspicious SQL statement file.
In one embodiment of the present invention, the apparatus 10 further comprises:
an automatic recovery switch detection module 19, configured to detect whether an automatic recovery switch is turned on when the number of available connections of the JDBC connection pool is determined to be insufficient;
and the automatic recovery module 20 is configured to automatically restart the application program and recover the connection between the application program and the JDBC connection pool when the automatic recovery switch is turned on.
Please refer to the foregoing method embodiments for the workflow of each module in the apparatus described in this embodiment, which is not described herein again.
Although some embodiments have been described herein by way of example, various modifications may be made to these embodiments without departing from the spirit of the invention, and all such modifications are intended to be included within the scope of the invention as defined in the following claims. For example, in the embodiments of the present invention, functions of some of the modules may be combined or integrated to be implemented by one module, or functions of a certain module may be divided to be implemented by a plurality of modules.
Through the above description of the embodiments, those skilled in the art will clearly understand that the present invention can be implemented by combining software and a hardware platform. With this understanding in mind, all or part of the technical solutions of the present invention that contribute to the background can be embodied in the form of a software product, which can be stored in a storage medium, such as a ROM/RAM, a magnetic disk, an optical disk, etc., and includes instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods according to the embodiments or some parts of the embodiments.
Yet another embodiment of the present invention provides a computer storage medium, such as a hard disk, an optical disk, a flash memory, a floppy disk, a magnetic tape, etc., having computer readable instructions stored thereon, which can be executed by a processor to implement the method for monitoring JDBC connection pool status according to any of the above embodiments.
Yet another embodiment of the present invention provides a computer apparatus including:
a memory having a computer program stored thereon,
a processor, which can execute the computer program to implement the method for monitoring JDBC connection pool status according to any of the above embodiments.
The terms and expressions used in the present specification are used as terms of illustration only and are not meant to be limiting. It will be appreciated by those skilled in the art that changes could be made to the details of the above-described embodiments without departing from the underlying principles thereof. The scope of the invention is, therefore, indicated by the appended claims, in which all terms are intended to be interpreted in their broadest reasonable sense unless otherwise indicated.

Claims (16)

1. A method of monitoring JDBC connection pool status, said method comprising:
acquiring state information of the JDBC connection pool every other designated time period to obtain the state information of the JDBC connection pool at a plurality of time points;
judging whether the available connection number of the JDBC connection pool is sufficient or not according to the state information of the continuously set time points up to the current time point;
and if the number of the available connections of the JDBC connection pool is insufficient, generating early warning information that the number of the available connections of the JDBC connection pool is insufficient.
2. The method of claim 1, further comprising:
the method comprises the steps of scanning an installation directory and an application deployment directory of the Weblogic, detecting and identifying an application program calling Weblogic service and JDBC connection pool information used by the application program.
3. The method of claim 1, wherein the status information comprises: current number of available connections, total number of connections.
4. The method of claim 3, wherein the determining whether the number of available connections of the JDBC connection pool is sufficient according to the state information of the set time point up to the current time point comprises:
and if the number of available connections of the JDBC connection pool to the continuously set time points of the current time point is continuously lower than a set threshold, determining that the number of available connections of the JDBC connection pool is insufficient, wherein the set threshold is a set percentage of the total number of connections of the JDBC connection pool.
5. The method of claim 1, further comprising:
when the available connection number of the JDBC connection pool is insufficient, detecting whether a dump log switch is turned on;
if the file is started, the dump file is automatically generated.
6. The method of claim 1, further comprising:
when the number of available connections of the JDBC connection pool is insufficient, detecting whether a suspicious SQL statement switch is turned on or not;
and if the SQL statement is started, acquiring the multiple pieces of SQL statement information of the current most consumed database performance, and automatically generating a suspicious SQL statement file.
7. The method of claim 6, further comprising:
when the available connection number of the JDBC connection pool is insufficient, detecting whether an automatic recovery switch is started or not;
and if the JDBC connection pool is started, automatically restarting the application program and recovering the connection between the application program and the JDBC connection pool.
8. An apparatus for monitoring JDBC connection pool status, said apparatus comprising:
the state information acquisition module is used for acquiring the state information of the JDBC connection pool every other designated time period to obtain the state information of the JDBC connection pool at a plurality of time points;
the judging module is used for judging whether the available connection number of the JDBC connection pool is sufficient or not according to the state information of the continuously set time points up to the current time point;
and the early warning module is used for generating early warning information that the available connection number of the JDBC connection pool is insufficient when the available connection number of the JDBC connection pool is insufficient.
9. The apparatus of claim 8, further comprising:
and the connection pool detection module is used for scanning the installation directory and the application program deployment directory of the Weblogic, and detecting and identifying the application program calling the Weblogic service and the JDBC connection pool information used by the application program.
10. The apparatus of claim 8, wherein the status information comprises: current number of available connections, total number of connections.
11. The apparatus of claim 10, wherein the determining whether the number of available connections of the JDBC connection pool is sufficient according to the state information up to the set number of current time points comprises:
and if the number of available connections of the JDBC connection pool to the continuously set time points of the current time point is continuously lower than a set threshold, determining that the number of available connections of the JDBC connection pool is insufficient, wherein the set threshold is a set percentage of the total number of connections of the JDBC connection pool.
12. The apparatus of claim 8, further comprising:
a log generation switch detection module for detecting whether the dump log switch is turned on when the available connection number of the JDBC connection pool is judged to be insufficient,
and the log generation module is used for automatically generating the dump log file when the dump log switch is turned on.
13. The apparatus of claim 8, further comprising:
the suspicious SQL statement switch detection module is used for detecting whether a generated suspicious SQL statement switch is turned on or not when the number of the available connections of the JDBC connection pool is judged to be insufficient;
and the suspicious SQL statement generating module is used for acquiring the plurality of pieces of SQL statement information of the current most consumed database performance when the suspicious SQL statement switch is opened, and automatically generating a suspicious SQL statement file.
14. The apparatus of claim 8, further comprising:
the automatic recovery switch detection module is used for detecting whether an automatic recovery switch is started or not when the available connection number of the JDBC connection pool is judged to be insufficient;
and the automatic recovery module is used for automatically restarting an application program and recovering the connection between the application program and the JDBC connection pool when the automatic recovery switch is started.
15. A computer storage medium having computer instructions stored thereon, wherein,
the computer instructions are executable by a processor to implement the method of monitoring JDBC connection pool status of any of claims 1-7.
16. A computer device, comprising:
a memory having a computer program stored thereon;
a processor for executing the computer program to implement the method of monitoring JDBC connection pool status according to any of claims 1-7.
CN202010424114.4A 2020-05-19 2020-05-19 Method for monitoring JDBC connection pool state and related equipment Active CN111767187B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010424114.4A CN111767187B (en) 2020-05-19 2020-05-19 Method for monitoring JDBC connection pool state and related equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010424114.4A CN111767187B (en) 2020-05-19 2020-05-19 Method for monitoring JDBC connection pool state and related equipment

Publications (2)

Publication Number Publication Date
CN111767187A true CN111767187A (en) 2020-10-13
CN111767187B CN111767187B (en) 2023-11-14

Family

ID=72719451

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010424114.4A Active CN111767187B (en) 2020-05-19 2020-05-19 Method for monitoring JDBC connection pool state and related equipment

Country Status (1)

Country Link
CN (1) CN111767187B (en)

Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1758606A (en) * 2004-10-08 2006-04-12 国际商业机器公司 Method and device for self managing connetion pool
US20070083526A1 (en) * 2005-10-11 2007-04-12 Rahul Srivastava Monitoring statistics and profile information for JDBC resources
CN101840352A (en) * 2010-04-29 2010-09-22 中兴通讯股份有限公司 Method and device for monitoring database connection pool
CN103034679A (en) * 2012-11-14 2013-04-10 上海百事通信息技术有限公司 Monitoring system for java operational database
CN104980524A (en) * 2015-07-10 2015-10-14 上海新炬网络信息技术有限公司 Method for monitoring failure of weblogic connection pool
CN106250500A (en) * 2016-07-29 2016-12-21 广州唯品会信息科技有限公司 The dynamic management approach of database connection pool and system
US20170161327A1 (en) * 2015-12-04 2017-06-08 Dell Software, Inc. Distributed database driver middleware
US20180046730A1 (en) * 2016-08-12 2018-02-15 Oracle International Corporation System and method for control of maximum connections in a connection pool environment
CN108920322A (en) * 2018-06-04 2018-11-30 郑州云海信息技术有限公司 A kind of method, apparatus and computer storage medium of middleware operational monitoring
CN109783322A (en) * 2018-11-22 2019-05-21 远光软件股份有限公司 A kind of monitoring analysis system and its method of enterprise information system operating status
CN110543402A (en) * 2019-09-09 2019-12-06 上海新炬网络技术有限公司 automatic monitoring and dynamic adjusting method based on WebLogic middleware core parameters

Patent Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1758606A (en) * 2004-10-08 2006-04-12 国际商业机器公司 Method and device for self managing connetion pool
US20070083526A1 (en) * 2005-10-11 2007-04-12 Rahul Srivastava Monitoring statistics and profile information for JDBC resources
CN101840352A (en) * 2010-04-29 2010-09-22 中兴通讯股份有限公司 Method and device for monitoring database connection pool
CN103034679A (en) * 2012-11-14 2013-04-10 上海百事通信息技术有限公司 Monitoring system for java operational database
CN104980524A (en) * 2015-07-10 2015-10-14 上海新炬网络信息技术有限公司 Method for monitoring failure of weblogic connection pool
US20170161327A1 (en) * 2015-12-04 2017-06-08 Dell Software, Inc. Distributed database driver middleware
CN106250500A (en) * 2016-07-29 2016-12-21 广州唯品会信息科技有限公司 The dynamic management approach of database connection pool and system
US20180046730A1 (en) * 2016-08-12 2018-02-15 Oracle International Corporation System and method for control of maximum connections in a connection pool environment
CN108920322A (en) * 2018-06-04 2018-11-30 郑州云海信息技术有限公司 A kind of method, apparatus and computer storage medium of middleware operational monitoring
CN109783322A (en) * 2018-11-22 2019-05-21 远光软件股份有限公司 A kind of monitoring analysis system and its method of enterprise information system operating status
CN110543402A (en) * 2019-09-09 2019-12-06 上海新炬网络技术有限公司 automatic monitoring and dynamic adjusting method based on WebLogic middleware core parameters

Also Published As

Publication number Publication date
CN111767187B (en) 2023-11-14

Similar Documents

Publication Publication Date Title
US10152364B2 (en) Predicting, diagnosing, and recovering from application failures based on resource access patterns
CN110516971B (en) Anomaly detection method, device, medium and computing equipment
US20170116084A1 (en) Method and System for Monitoring Virtual Machine Cluster
US20160154714A1 (en) Fault tolerant architecture for distributed computing systems
US8516499B2 (en) Assistance in performing action responsive to detected event
US7117391B1 (en) Checkpoint model building for data mining
CN107688531A (en) Geo-database integration method of testing, device, computer equipment and storage medium
US7496795B2 (en) Method, system, and computer program product for light weight memory leak detection
EP3591485B1 (en) Method and device for monitoring for equipment failure
Kc et al. ELT: Efficient log-based troubleshooting system for cloud computing infrastructures
CN111930589B (en) Streaming task automatic monitoring system and method
WO2021008029A1 (en) Case execution method, apparatus and device, and computer readable storage medium
CN116089231B (en) Fault alarm method and device, electronic equipment and storage medium
CN115809183A (en) Method for discovering and disposing information-creating terminal fault based on knowledge graph
CN110063042A (en) A kind of response method and its terminal of database failure
WO2020015116A1 (en) Database monitoring method and terminal device
CN111581056A (en) Software engineering database maintenance and early warning system based on artificial intelligence
CN114265857A (en) Query statement processing method and device
CN111930561B (en) Streaming task automatic monitoring alarm restarting system and method
Li et al. Converting unstructured system logs into structured event list for anomaly detection
CN111767187B (en) Method for monitoring JDBC connection pool state and related equipment
CN115114284A (en) Table change processing method and system
CN110427329B (en) Method and system for collecting SQL performance data of database
JP2012203684A (en) It failure symptom detector and program
CN115827393B (en) Server cluster monitoring and alarming system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant