CN111147282A - Device, method and storage medium for automatically maintaining DRCP connection pool - Google Patents
Device, method and storage medium for automatically maintaining DRCP connection pool Download PDFInfo
- Publication number
- CN111147282A CN111147282A CN201911234459.7A CN201911234459A CN111147282A CN 111147282 A CN111147282 A CN 111147282A CN 201911234459 A CN201911234459 A CN 201911234459A CN 111147282 A CN111147282 A CN 111147282A
- Authority
- CN
- China
- Prior art keywords
- parameter
- value
- current value
- connections
- drcp
- 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
Links
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/08—Configuration management of networks or network elements
- H04L41/0803—Configuration setting
- H04L41/0813—Configuration setting characterised by the conditions triggering a change of settings
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/08—Configuration management of networks or network elements
- H04L41/0803—Configuration setting
- H04L41/0823—Configuration setting characterised by the purposes of a change of settings, e.g. optimising configuration for enhancing reliability
- H04L41/0836—Configuration setting characterised by the purposes of a change of settings, e.g. optimising configuration for enhancing reliability to enhance reliability, e.g. reduce downtime
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/08—Configuration management of networks or network elements
- H04L41/0876—Aspects of the degree of configuration automation
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L43/00—Arrangements for monitoring or testing data switching networks
- H04L43/16—Threshold monitoring
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/14—Session management
- H04L67/143—Termination or inactivation of sessions, e.g. event-controlled end of session
- H04L67/145—Termination or inactivation of sessions, e.g. event-controlled end of session avoiding end of session, e.g. keep-alive, heartbeats, resumption message or wake-up for inactive or interrupted session
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Health & Medical Sciences (AREA)
- Cardiology (AREA)
- General Health & Medical Sciences (AREA)
- Automation & Control Theory (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention provides a device, a method and a storage medium for automatically maintaining a DRCP connection pool, and relates to the field of database management. The device comprises: a baseline file generation module, configured to generate a baseline file of the DRCP connection pool in a specified directory; a monitoring module for monitoring a current value of a first parameter; the parameter adjusting module is used for acquiring the current value and the historical value of the first parameter, comparing the current value and the historical value of the first parameter according to the comparison logic of the first parameter, and calling a parameter adjusting work package to adjust a second parameter of the DRCP connection pool or give a prompt according to the comparison result; an update module to update a historical value of the first parameter in the baseline file according to a current value of the first parameter; and the timing triggering module is used for triggering the parameter adjusting module and the updating module to process at fixed time. The invention can automatically adjust and maintain the related parameters of the DRCP connection pool, shorten the processing time and avoid the risk caused by manual misoperation.
Description
Technical Field
The invention relates to the field of database management, in particular to a device, a method and a storage medium for automatically maintaining a DRCP connection pool.
Background
In the prior art, an application system usually uses a connection pool provided by a middleware to connect a database, that is, a long connection is usually said, and the use of the connection pool provided by the middleware can omit the process of establishing and releasing a connection, thereby reducing the consumption of system resources during connection. However, many application systems cannot use the connection pool mechanism of the middleware for various reasons, and can only access the database using short connections. During the peak period of service, the number of short connections is very frequent, the bottleneck of the TNS (transparent network infrastructure) connection is reached, which far exceeds the upper limit of 300 times/min recommended by Orcle, so that the peak period monitoring cannot respond, a large number of connection failures occur, a large number of TNS-12535 (database server TNS operation timeout alarm code) and ORA-3136 (client terminal connection timeout code) appear in the alarm log, and the sys.
In the face of this scenario, a DRCP (Database resource Connection pool) Resident Connection pool serves a user. At present, after most enterprises use the DRCP connection pool, a DBA (database administrator) usually maintains relevant parameters manually, adjusts the parameters manually after an abnormality is found, and then observes an adjustment effect. Such manual processing is inefficient and requires a long time from the discovery of the exception to the completion of the processing. Moreover, in order to obtain the performance index, a database administrator logs in the target device each time, inputs a corresponding query command to query relevant information, manually executes a specific script, observes an output result, and then manually modifies the result, which is tedious in process. Moreover, the labor cost is increased along with the increase of the number of the monitored databases, and the complicated manual processing is easy to cause errors, thereby causing problems.
Disclosure of Invention
In view of the above technical problems in the prior art, embodiments of the present invention provide an apparatus, a method, and a storage medium for automatically maintaining a DRCP connection pool.
A first aspect of an embodiment of the present invention provides an apparatus for automatically maintaining a DRCP connection pool, where the apparatus may include:
the base line file generating module is used for generating a base line file of the DRCP connection pool under a specified directory, wherein the base line file comprises a historical value of a first parameter of the DRCP connection pool;
a monitoring module for monitoring a current value of the first parameter;
the parameter adjusting module is used for acquiring a current value and a historical value of the first parameter, comparing the current value and the historical value of the first parameter according to the comparison logic of the first parameter, and calling a parameter adjusting work package to adjust a second parameter of the DRCP connection pool or give a prompt according to the comparison result;
an update module to update a historical value of the first parameter in the baseline file according to a current value of the first parameter;
and the timing triggering module is used for triggering the parameter adjusting module and the updating module to process at fixed time.
In one embodiment of the present invention, the first parameter includes: connection pool open number, number of waiting connections, total number of connections, number of unreused connections.
In an embodiment of the present invention, when the first parameter is an open number of connection pools, the parameter adjusting module includes:
a first adjusting unit for performing the following operations: and acquiring the current value and the historical value of the connection pool opening number, judging whether the current value of the connection pool opening number is larger than the historical value, and calling a parameter adjustment tool package to increase the step length of the DRCP connection pool if the current value of the connection pool opening number is larger than the historical value.
In an embodiment of the present invention, the first adjusting unit is further configured to invoke a parameter adjustment toolkit to increase the maximum pool number of the DRCP connection pool when the current value of the connection pool open number is greater than a set threshold.
In an embodiment of the present invention, when the first parameter is a number of waiting connections, the parameter adjusting module includes:
and the second adjusting unit is used for acquiring the current value and the historical value of the number of the waiting connections, judging whether the current value of the number of the waiting connections is larger than the historical value of the number of the waiting connections, and if so, calling a parameter adjusting tool package to increase the maximum pool number of the DRCP connection pool and simultaneously adjusting the minimum pool number and the step length.
In one embodiment of the present invention, when the first parameter includes a total number of connections and a number of unreused connections, the parameter adjusting module includes:
a session reuse monitoring unit to perform the following operations: acquiring a first difference value between a current value and a historical value of the total number of the connections and a second difference value between the current value and the historical value of the number of the unreused connections; and judging whether the ratio of the first difference to the second difference is higher than a first set threshold and lower than a second set threshold, if so, acquiring the first difference and the second difference again, judging whether the ratio of the first difference and the second difference acquired again is higher than the first set threshold and lower than the second set threshold, and if so, informing operation and maintenance personnel to optimize the application code.
In an embodiment of the present invention, the session reuse monitoring unit is further configured to notify the operation and maintenance personnel to optimize the application code when a ratio of the first difference to the second difference is lower than a first set threshold.
A second aspect of an embodiment of the present invention provides a method for automatically maintaining a DRCP connection pool, where the method may include:
s1: generating a baseline file of a DRCP connection pool under a specified directory, wherein the baseline file comprises a historical value of a first parameter of the DRCP connection pool;
s2: monitoring a current value of the first parameter;
s3: acquiring a current value and a historical value of the first parameter, comparing the current value and the historical value of the first parameter according to the comparison logic of the first parameter, and calling a parameter adjustment work package to adjust a second parameter of the DRCP connection pool or give a prompt according to the comparison result;
s4: updating the historical value of the first parameter in the baseline file according to the current value of the first parameter;
wherein the processes S3-S4 are executed regularly.
In one embodiment of the present invention, the first parameter includes: connection pool open number, number of waiting connections, total number of connections, number of unreused connections.
In an embodiment of the present invention, when the first parameter is the connection pool open number, the process S3 includes:
acquiring a current value and a historical value of the number of open connection pools;
judging whether the current value of the connection pool opening number is larger than the historical value of the connection pool opening number;
and if so, calling a parameter adjustment tool package to increase the step length of the DRCP connection pool.
In one embodiment of the present invention, the process S3 further includes:
and when the current value of the connection pool opening number is larger than a set threshold value, calling a parameter adjustment tool package to increase the maximum pool number of the DRCP connection pool.
In one embodiment of the present invention, when the first parameter is the number of waiting connections, the process S3 includes:
acquiring a current value and a historical value of the number of waiting connections;
judging whether the current value of the number of the waiting connections is larger than the historical value of the number of the waiting connections;
if the number of the DRCP connection pools is larger than the preset value, calling a parameter adjusting tool package to increase the maximum pool number of the DRCP connection pools, and adjusting the minimum pool number and the step length at the same time.
In one embodiment of the present invention, when the first parameter includes a total number of connections and a number of unreused connections, the process S3 includes:
acquiring a first difference value between a current value and a historical value of the total number of the connections and a second difference value between the current value and the historical value of the number of the unreused connections;
and judging whether the ratio of the first difference to the second difference is higher than a first set threshold and lower than a second set threshold, if so, acquiring the first difference and the second difference again, judging whether the ratio of the first difference and the second difference acquired again is higher than the first set threshold and lower than the second set threshold, and if so, informing operation and maintenance personnel to optimize the application code.
In an embodiment of the present invention, when a ratio of the first difference to the second difference is lower than a first set threshold, the operation and maintenance personnel is notified to optimize the application code.
A third aspect of embodiments of the present invention provides a computer storage medium having stored thereon computer instructions executable by a processor to implement any one of the methods for automatically maintaining a DRCP connection pool described in the above embodiments.
Compared with the prior art, the invention has the following technical effects:
the embodiment of the invention automatically adjusts and maintains the related parameters of the DRCP connection pool, can avoid the misoperation risk possibly brought by manual maintenance, and improves the stability of the server. In addition, the device of the embodiment of the invention can quickly respond after the deployment is finished, and can process in time, thereby shortening the processing time of modification and maintenance, improving the processing efficiency and reducing the labor cost.
Drawings
FIG. 1 is a block diagram of an apparatus for automatically maintaining a DRCP connection pool in accordance with one embodiment of the present invention;
FIG. 2 is a flowchart of the operation of a first adjustment unit according to one embodiment of the invention;
FIG. 3 is a flowchart of the operation of a first adjustment unit according to another embodiment of the invention;
FIG. 4 is a flowchart of the operation of a second adjustment unit according to an embodiment of the invention;
FIG. 5 is a flow diagram of the operation of a session reuse monitoring unit according to one embodiment of the present invention;
fig. 6 is a flowchart of a method for automatically maintaining a DRCP connection pool according to an embodiment of the present invention.
Detailed Description
To facilitate an understanding of the various aspects, features and advantages of the present inventive subject matter, reference is made to the following detailed description taken in conjunction with the accompanying drawings. It should be understood that the various embodiments described below are illustrative only and are not intended to limit the scope of the invention.
A first aspect of an embodiment of the present invention provides an apparatus for automatically maintaining a DRCP connection pool. Fig. 1 shows a schematic diagram of a device module for automatically maintaining a DRCP connection pool according to an embodiment of the present invention. As shown in fig. 1, the device for automatically maintaining a DRCP connection pool (hereinafter, referred to as a DRCP automatic maintenance device) 10 may include, but is not limited to: the device comprises a baseline file generation module 11, a monitoring module 12, a parameter adjustment module 13, an updating module 14 and a timing trigger module 15.
The DRCP automatic maintenance apparatus 10 may be implemented by a script, and may be deployed to a database server of a DRCP connection pool that needs to be maintained. The database server is a special server for operating the database system, and can provide hardware support and guarantee for high-performance operation of the database system. The DRCP automatic maintenance device of this embodiment can be deployed to the database server to be maintained by one-touch script, and after deployment is completed, the device can automatically complete adjustment and maintenance of the parameters related to the DRCP connection pool of the database server, quickly respond to system abnormality, and perform processing in time, thereby greatly shortening the time for handling faults.
After deployment is completed, the baseline file generating module 11 may generate a baseline file of the DRCP connection pool needing maintenance under a specified directory, where the baseline file may include historical values of first parameters of the DRCP connection pool needing monitoring, where the first parameters may include, but are not limited to, a number of OPEN connection pools (NUM _ OPEN _ SERVERS), a number of pending connections (NUM _ wait), a total number of connections (NUM _ REQUESTS), a number of unused connections, etc. (NUM _ miss), a number of BUSY connection pools (NUM _ BUSY _ SERVERS), a historical maximum number of connections (histaric _ MAX), and the like. The monitoring module 12 may monitor the current value of the first parameter. The parameter adjusting module 13 may obtain a current value and a historical value of the first parameter, compare the current value and the historical value of the first parameter according to the comparison logic of the first parameter, and invoke a parameter adjusting toolkit to adjust a second parameter of the DRCP connection pool, such as a step size, a maximum pool number, a minimum pool number, and the like, according to a comparison result. After the adjustment, update module 14 updates the historical value of the first parameter in the baseline file based on the current value of the first parameter. The timing trigger module 15 can trigger the parameter adjustment module 13 and the update module 14 to perform processing at regular time.
In an embodiment of the present invention, when the first parameter is the open number of the connection pool, the parameter adjusting module 13 may include a first adjusting unit. Fig. 2 shows a workflow of a first adaptation unit according to an embodiment of the invention. As shown in fig. 2, the first adjusting unit may obtain a current value of the connection pool opening number through the monitoring module 12, obtain a history value of the connection pool opening number (NUM _ OPEN _ SERVERS) from the baseline file, compare the current value with the history value, and determine whether the current value of the connection pool opening number is greater than the history value, so as to determine whether the connection pool opening number has a growing trend all the time, if so, it indicates that the service is continuously growing, and invoke the parameter adjustment toolkit to increase the step size (increment) of the DRCP connection pool.
In an embodiment of the present invention, in addition to adjusting the step size parameter, the first adjusting unit may adjust the maximum pool number of the DRCP connection pool, and the work flow is as shown in fig. 3. The first adjusting unit may compare the current value of the connection pool opening number with a set threshold, determine whether the current value of the connection pool opening number is greater than the set threshold, and invoke the parameter adjustment toolkit to increase the maximum pool number (MAXSIZE) of the DRCP connection pool when the current value of the connection pool opening number is greater than the set threshold. Wherein the set threshold may be a value less than but close to the current maximum pool number.
In an embodiment of the present invention, the first parameter may be a number of waiting connections (NUM _ wait), and the parameter adjusting module 13 may include a second adjusting unit. Fig. 4 shows a work flow diagram of a second adjustment unit according to an embodiment of the invention. As shown in fig. 4, the second adjusting unit may obtain a historical value of the number of waiting connections from the baseline file, obtain a current value of the number of waiting connections through the monitoring module 12, compare the current value with the historical value, and determine whether the current value of the number of waiting connections is greater than the historical value thereof, thereby determining whether the number of waiting connections is increasing. If so, indicating that the service is continuously increasing and the current connection pool cannot meet the service requirement, the parameter adjustment toolkit is called to increase the maximum pool number (MAXSIZE) and simultaneously adjust the minimum pool number (MINSIZE) and the step size (INCREASIZE) of the DRCP connection pool.
In an embodiment of the present invention, the first parameter includes a total number of connections and a number of connections that are not reused, and the parameter adjusting module 13 may include a session reuse monitoring unit 133, configured to monitor a session reuse situation, and prompt an operation and maintenance worker to optimize an application code according to the session reuse situation. The session reuse case may be represented by the ratio of the total number of connections in the view v $ cpool _ status (NUM _ REQUESTS parameter) minus the total number of unreused connections (NUM _ MISSES parameter) to the total number of connections, i.e. the waiting connection reuse case (NUM _ REQUESTS-NUM _ MISSES)/NUM _ REQUESTS.
Fig. 5 shows a flow diagram of the operation of a session reuse monitoring unit according to an embodiment of the present invention. As shown in fig. 5, the session reuse monitoring unit 133 may obtain a historical value of the total number of connections (NUM _ REQUESTS) and a historical value of the number of unreused connections (NUM _ miss) from the baseline file, obtain, by the monitoring module 12, a current value of the total number of connections and a current value of the number of unreused connections, obtain a first difference value (NUM _ REQUEST _ CUR-NUM _ REQUEST _ HIS) between the current value and the historical value of the total number of connections according to the current value and the historical value of the total number of connections, and obtain a difference value (NUM _ miss _ CUR-NUM _ miss _ HIS) between the current value and the historical value of the total number of unreused connections according to the current value and the historical value of the total number of unreused connections. If the ratio of the first difference to the second difference ((NUM _ REQUEST _ CUR-NUM _ REQUEST _ HIS)/(NUM _ MISSES _ CUR-NUM _ MISSES _ HIS)) is below the first set threshold A, the operation and maintenance personnel are notified to optimize the application code. If the ratio of the first difference to the second difference is higher than the first set threshold a and lower than the second set threshold B, the current value of the total number of connections and the current value of the number of connections not reused are obtained again through the monitoring module 12, so that the first difference and the second difference are obtained again, and if the ratio of the first difference to the second difference is still higher than the first set threshold a and lower than the second set threshold B, the operation and maintenance personnel is notified to optimize the application code.
A second aspect of an embodiment of the present invention provides a method for automatically maintaining a DRCP connection pool. Fig. 6 shows a flowchart of a method for automatically maintaining a DRCP connection pool according to an embodiment of the present invention. As shown in fig. 6, the method for automatically maintaining a DRCP connection pool according to this embodiment may include the following processes:
s1: generating a baseline file of the DRCP connection pool under a specified directory, wherein the baseline file comprises a historical value of a first parameter of the DRCP connection pool;
s2: monitoring a current value of the first parameter;
s3: acquiring a current value and a historical value of the first parameter, comparing the current value and the historical value of the first parameter according to the comparison logic of the first parameter, and calling a parameter adjustment work package to adjust a second parameter of the DRCP connection pool or give a prompt according to the comparison result;
s4: and updating the historical value of the first parameter in the baseline file according to the current value of the first parameter.
In this embodiment, the processes S3 and S4 may be executed in a timed manner.
In one embodiment of the present invention, the first parameter may include: connection pool open number, number of waiting connections, total number of connections, number of unreused connections.
In an embodiment of the present invention, when the first parameter is the connection pool opening number, the process S3 may include:
acquiring a current value and a historical value of the number of open connection pools;
judging whether the current value of the connection pool opening number is larger than the historical value of the connection pool opening number;
and if so, calling a parameter adjustment tool package to increase the step length of the DRCP connection pool.
In one embodiment of the present invention, the process S3 further includes:
and when the current value of the connection pool opening number is equal to a set threshold value, calling a parameter adjustment tool package to increase the maximum pool number of the DRCP connection pool.
In an embodiment of the present invention, when the first parameter is the number of waiting connections, the process S3 may include:
acquiring a current value and a historical value of the number of waiting connections;
judging whether the current value of the number of the waiting connections is larger than the historical value of the number of the waiting connections;
if the number of the DRCP connection pools is larger than the preset value, calling a parameter adjusting tool package to increase the maximum pool number of the DRCP connection pools, and adjusting the minimum pool number and the step length at the same time.
In one embodiment of the present invention, when the first parameter includes a total number of connections and a number of unreused connections, the process S3 includes:
acquiring a first difference value between a current value and a historical value of the total number of the connections and a second difference value between the current value and the historical value of the number of the unreused connections;
and judging whether the ratio of the first difference to the second difference is higher than a first set threshold and smaller than a second set threshold, if so, acquiring the first difference and the second difference again, judging whether the ratio of the first difference and the second difference acquired again is higher than the first set threshold and lower than the second set threshold, and if so, informing operation and maintenance personnel to optimize the application code.
In an embodiment of the present invention, when a ratio of the first difference to the second difference is lower than a first set threshold, the operation and maintenance personnel is notified to optimize the application code.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the above method for automatically maintaining the DRCP connection pool may refer to the corresponding process in the foregoing embodiment of the apparatus, and is not described herein again.
A third aspect of embodiments of the present invention provides a computer storage medium, such as RAM/ROM, magnetic disk, optical disk, etc., having stored thereon computing instructions executable by a processor to implement a method for automatically maintaining a DRCP connection pool as described in any of the above embodiments.
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.
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.
The terms and expressions used in the specification of the present invention have been set forth for illustrative purposes 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 (15)
1. An apparatus for automatically maintaining a DRCP connection pool, the apparatus comprising:
the base line file generating module is used for generating a base line file of the DRCP connection pool under a specified directory, wherein the base line file comprises a historical value of a first parameter of the DRCP connection pool;
a monitoring module for monitoring a current value of the first parameter;
a parameter adjusting module, configured to perform the following processing: acquiring a current value and a historical value of the first parameter, comparing the current value and the historical value of the first parameter according to the comparison logic of the first parameter, and calling a parameter adjustment work package to adjust a second parameter of the DRCP connection pool or give a prompt according to the comparison result;
an update module to update a historical value of the first parameter in the baseline file according to a current value of the first parameter;
and the timing triggering module is used for triggering the parameter adjusting module and the updating module to process at fixed time.
2. The apparatus of claim 1, wherein the first parameter comprises: connection pool open number, number of waiting connections, total number of connections, number of unreused connections.
3. The apparatus of claim 2, wherein when the first parameter is a connection pool opening number, the parameter adjusting module comprises:
a first adjusting unit for performing the following operations: and acquiring the current value and the historical value of the connection pool opening number, judging whether the current value of the connection pool opening number is larger than the historical value, and calling a parameter adjustment tool package to increase the step length of the DRCP connection pool if the current value of the connection pool opening number is larger than the historical value.
4. The apparatus of claim 3,
the first adjusting unit is further configured to invoke a parameter adjustment toolkit to increase the maximum pool number of the DRCP connection pool when the current value of the connection pool open number is greater than a set threshold.
5. The apparatus of claim 2, wherein when the first parameter is a number of waiting connections, the parameter adjusting module comprises:
and the second adjusting unit is used for acquiring the current value and the historical value of the number of the waiting connections, judging whether the current value of the number of the waiting connections is larger than the historical value of the number of the waiting connections, and if so, calling a parameter adjusting tool package to increase the maximum number of the DRCP connection pools and simultaneously adjusting the minimum number of the pools and the step length.
6. The apparatus of claim 2, wherein when the first parameter comprises a total number of connections and a number of unreused connections, the parameter adjustment module comprises:
a session reuse monitoring unit to perform the following operations: acquiring a first difference value between a current value and a historical value of the total number of the connections and a second difference value between the current value and the historical value of the number of the unreused connections; and judging whether the ratio of the first difference to the second difference is higher than a first set threshold and lower than a second set threshold, if so, acquiring the first difference and the second difference again, judging whether the ratio of the first difference and the second difference acquired again is higher than the first set threshold and lower than the second set threshold, and if so, informing operation and maintenance personnel to optimize the application code.
7. The apparatus of claim 6,
and the session reuse monitoring unit is further used for notifying operation and maintenance personnel to optimize the application codes when the ratio of the first difference to the second difference is lower than a first set threshold.
8. A method for automatically maintaining a DRCP connection pool, the method comprising:
s1: generating a baseline file of a DRCP connection pool under a specified directory, wherein the baseline file comprises a historical value of a first parameter of the DRCP connection pool;
s2: monitoring a current value of the first parameter;
s3: acquiring a current value and a historical value of the first parameter, comparing the current value and the historical value of the first parameter according to the comparison logic of the first parameter, and calling a parameter adjustment work package to adjust a second parameter of the DRCP connection pool or give a prompt according to the comparison result;
s4: updating the historical value of the first parameter in the baseline file according to the current value of the first parameter;
wherein the processes S3-S4 are executed regularly.
9. The method of claim 8, wherein the first parameter comprises: connection pool open number, number of waiting connections, total number of connections, number of unreused connections.
10. The method according to claim 9, wherein when the first parameter is the connection pool opening number, the process S3 includes:
acquiring a current value and a historical value of the number of open connection pools;
judging whether the current value of the connection pool opening number is larger than the historical value of the connection pool opening number;
and if so, calling a parameter adjustment tool package to increase the step length of the DRCP connection pool.
11. The method of claim 10, wherein the process S3 further comprises:
and when the current value of the open number of the connection pools is larger than a set threshold value, calling a parameter adjustment tool package to increase the maximum pool number of the DRCP connection pools.
12. The method according to claim 9, wherein when the first parameter is the number of waiting connections, the process S3 includes:
acquiring a current value and a historical value of the number of waiting connections;
judging whether the current value of the number of the waiting connections is larger than the historical value of the number of the waiting connections;
if the number of the DRCP connection pools is larger than the preset value, calling a parameter adjusting tool package to increase the maximum pool number of the DRCP connection pools, and adjusting the minimum pool number and the step length at the same time.
13. The method of claim 9, wherein when the first parameter comprises a total number of connections and a number of unreused connections, the process S3 comprises:
acquiring a first difference value between a current value and a historical value of the total number of the connections and a second difference value between the current value and the historical value of the number of the unreused connections;
and judging whether the ratio of the first difference to the second difference is higher than a first set threshold and lower than a second set threshold, if so, acquiring the first difference and the second difference again, judging whether the ratio of the first difference and the second difference acquired again is higher than the first set threshold and lower than the second set threshold, and if so, informing operation and maintenance personnel to optimize the application code.
14. The method of claim 13,
and when the ratio of the first difference to the second difference is lower than a first set threshold, notifying operation and maintenance personnel to optimize the application code.
15. A computer storage medium having stored thereon computer instructions executable by a processor to perform the method of any one of claims 8 to 14.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911234459.7A CN111147282B (en) | 2019-12-05 | 2019-12-05 | Device, method and storage medium for automatically maintaining DRCP connection pool |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911234459.7A CN111147282B (en) | 2019-12-05 | 2019-12-05 | Device, method and storage medium for automatically maintaining DRCP connection pool |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111147282A true CN111147282A (en) | 2020-05-12 |
| CN111147282B CN111147282B (en) | 2022-09-20 |
Family
ID=70517711
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911234459.7A Active CN111147282B (en) | 2019-12-05 | 2019-12-05 | Device, method and storage medium for automatically maintaining DRCP connection pool |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111147282B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112181652A (en) * | 2020-09-25 | 2021-01-05 | 北京天融信网络安全技术有限公司 | Method and device for adjusting capacity of connection pool, storage medium and electronic equipment |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105591790A (en) * | 2014-12-30 | 2016-05-18 | 中国银联股份有限公司 | Data communication connection pool management device |
| CN107705149A (en) * | 2017-09-22 | 2018-02-16 | 平安科技（深圳）有限公司 | Data method for real-time monitoring, device, terminal device and storage medium |
-
2019
- 2019-12-05 CN CN201911234459.7A patent/CN111147282B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105591790A (en) * | 2014-12-30 | 2016-05-18 | 中国银联股份有限公司 | Data communication connection pool management device |
| CN107705149A (en) * | 2017-09-22 | 2018-02-16 | 平安科技（深圳）有限公司 | Data method for real-time monitoring, device, terminal device and storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112181652A (en) * | 2020-09-25 | 2021-01-05 | 北京天融信网络安全技术有限公司 | Method and device for adjusting capacity of connection pool, storage medium and electronic equipment |
| CN112181652B (en) * | 2020-09-25 | 2023-11-28 | 北京天融信网络安全技术有限公司 | Method and device for adjusting capacity of connection pool, storage medium and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111147282B (en) | 2022-09-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107678907B (en) | Database service logic monitoring method, system and storage medium | |
| CN111782360B (en) | Distributed task scheduling method and device | |
| CN107451040B (en) | Method and device for positioning fault reason and computer readable storage medium | |
| CN107016480B (en) | Task scheduling method, device and system | |
| JP3370276B2 (en) | Method of managing semiconductor manufacturing equipment management system | |
| US20120144234A1 (en) | Automatic error recovery mechanism for a database system | |
| WO2020248708A1 (en) | Method and device for submitting spark work | |
| CN111611137A (en) | Alarm monitoring method and device, computer equipment and storage medium | |
| CN105487924A (en) | Batch processing controlling method and device | |
| US7434204B1 (en) | Method and apparatus for managing software processes | |
| CN111147282B (en) | Device, method and storage medium for automatically maintaining DRCP connection pool | |
| CN113157411A (en) | Reliable configurable task system and device based on Celery | |
| CN114371975A (en) | Big data component parameter adjusting method and device, electronic equipment and storage medium | |
| CN112383507A (en) | Firewall policy management method, device and system and computer readable storage medium | |
| EP3905591A1 (en) | Server abnormality processing method and management device | |
| CN115001990A (en) | Cross-region openstack cluster management method and system based on declarative API | |
| CN105988886A (en) | Fault processing method and device in operation and maintenance process | |
| CN117389843A (en) | Intelligent operation and maintenance system, method, electronic equipment and storage medium | |
| US20050114867A1 (en) | Program reactivation using triggering | |
| CN111710403B (en) | Medical equipment supervision method, equipment and readable storage medium | |
| CN114595075A (en) | Network scheduling asynchronous task execution method based on distributed scheduling | |
| CN111967975A (en) | Service problem processing system and working method | |
| CN107092528A (en) | A kind of distributed task dispatching method, apparatus and system | |
| CN114880157B (en) | Fault injection method and device | |
| US20090168092A1 (en) | Job management and scheduling method for network 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 |