Movatterモバイル変換


[0]ホーム

URL:


CN109726073A - Database monitoring method, device, equipment and readable storage medium storing program for executing - Google Patents

Database monitoring method, device, equipment and readable storage medium storing program for executing
Download PDF

Info

Publication number
CN109726073A
CN109726073ACN201810835443.0ACN201810835443ACN109726073ACN 109726073 ACN109726073 ACN 109726073ACN 201810835443 ACN201810835443 ACN 201810835443ACN 109726073 ACN109726073 ACN 109726073A
Authority
CN
China
Prior art keywords
monitoring
database
subitem
default
monitored
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.)
Pending
Application number
CN201810835443.0A
Other languages
Chinese (zh)
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.)
Ping An Technology Shenzhen Co Ltd
Original Assignee
Ping An Technology Shenzhen Co Ltd
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 Ping An Technology Shenzhen Co LtdfiledCriticalPing An Technology Shenzhen Co Ltd
Priority to CN201810835443.0ApriorityCriticalpatent/CN109726073A/en
Priority to PCT/CN2018/103337prioritypatent/WO2020019405A1/en
Publication of CN109726073ApublicationCriticalpatent/CN109726073A/en
Pendinglegal-statusCriticalCurrent

Links

Classifications

Landscapes

Abstract

The present invention provides a kind of database monitoring method, comprising: receives the connection configuration information of database to be monitored, and according to the connection configuration information, configures to the connecting object in default monitoring template set, to obtain current monitor template set;In the database to be monitored, the monitoring SQL statement that subitem is respectively monitored in the current monitor template set is executed, and the monitored results according to each monitoring subitem determine whether trigger data library alarm command;If trigger data library alarm command, the monitored results according to each monitoring subitem generate warning information, and the warning information is sent to alarm group of contacts according to preset alarm mode.The present invention also provides a kind of database monitoring device, equipment and readable storage medium storing program for executing.The present invention can effectively improve the applicability of database monitoring.

Description

Database monitoring method, device, equipment and readable storage medium storing program for executing
Technical field
The present invention relates to the technical field of database monitoring more particularly to a kind of database monitoring method, device, equipment andReadable storage medium storing program for executing.
Background technique
In the operational process of database, need to monitor the operating status of database in real time, including to dataThe monitoring of library session, database journal, data file fragment, table space and user's access etc., finds the operation of database in real timeAbnormal and resource consumption situation can quickly remind user when database is operating abnormally.
Currently, the monitor mode of PostgreSQL (Object-relational Database) is that operation maintenance personnel uses monitoring tools, configurationMonitoring strategies monitoring data library, for the database used under different application systems, operation maintenance personnel needs to configure different prisonsControl strategy, the applicability of database monitoring are lower.
Therefore, how to improve the applicability of database monitoring is current urgent problem to be solved.
Summary of the invention
The main purpose of the present invention is to provide a kind of database monitoring method, device, equipment and readable storage medium storing program for executing, purportsIn the applicability and reliability for improving database monitoring.
To achieve the above object, the present invention provides a kind of database monitoring method, the database monitoring method include withLower step:
The connection configuration information of database to be monitored is received, and according to the connection configuration information, to default monitoring templateThe connecting object of concentration is configured, to obtain current monitor template set;
In the database to be monitored, the monitoring SQL statement that subitem is respectively monitored in the current monitor template set is executed,And the monitored results according to each monitoring subitem determine whether trigger data library alarm command;
If trigger data library alarm command, the monitored results according to each monitoring subitem generate warning information, and according to pre-If alarm mode the warning information is sent to alarm group of contacts.
Optionally, according to the connection configuration information, the connecting object in default monitoring template set is configured, to obtainThe step of taking current monitor template set include:
The identification field of each connecting object in default monitoring template set, and the identification field according to each connecting object are obtained,The correspondence configuration parameter of each connecting object is obtained from the connection configuration information;
According to the correspondence configuration parameter of each connecting object, the connecting object in default monitoring template set is configured, withObtain current monitor template set.
Optionally, the step of monitored results according to each monitoring subitem determine whether trigger data library alarm command packetIt includes:
It determines in each monitoring subitem and is located in default monitored results group with the presence or absence of the monitored results of at least one monitoring subitem;
If the monitored results that respectively there is at least one monitoring subitem in monitoring subitem are located in default monitored results group, triggerDatabase alarm command, otherwise not trigger data alarm command.
Optionally, the step of monitored results generation warning information according to each monitoring subitem includes:
Default warning information template is obtained, and the monitored results of each monitoring subitem are filled to the default warning information mouldIn plate, to generate warning information.
Optionally, the monitored results by each monitoring subitem are filled into the default warning information template, to generateThe step of warning information includes:
Obtain the location information of each monitoring subitem in the default warning information template;
According to the location information of each monitoring subitem, affiliated filling of each monitoring subitem in default warning information template is determinedPosition;
The monitored results of each monitoring subitem are filled into filling position belonging to the correspondence into default warning information template.
Optionally, the database monitoring method further include:
Currently available cpu resource is obtained, and according to currently available cpu resource, determines the execution side of database monitoring operationFormula is single task executive mode or multitask executive mode;
If the executive mode of database monitoring operation is single task executive mode, the monitoring of a monitoring subitem is executed every timeSQL statement;
If the executive mode of database monitoring operation is multitask executive mode, determined according to currently available cpu resourceIt is synchronous to execute number of tasks, and according to the synchronous execution number of tasks, execute the monitoring SQL statement of the monitoring subitem of corresponding number.
Optionally, described to determine that synchronous the step of executing page number includes: according to currently available cpu resource
The mapping table of the currently available cpu resource that acquisition prestores and synchronous execution number of tasks, and closed from the mappingIt is to inquire synchronous execution number of tasks corresponding with currently available cpu resource in table.
In addition, to achieve the above object, the present invention also provides a kind of database monitoring device, the database monitoring deviceInclude:
Configuration module is right for receiving the connection configuration information of database to be monitored, and according to the connection configuration informationConnecting object in default monitoring template set is configured, to obtain current monitor template set;
Execution module, for executing in the current monitor template set and respectively monitoring subitem in the database to be monitoredMonitoring SQL statement, and according to it is each monitoring subitem monitored results determine whether trigger data library alarm command;
Alarm module, if being used for trigger data library alarm command, the monitored results according to each monitoring subitem generate alarmInformation, and the warning information is sent to alarm group of contacts according to preset alarm mode.
In addition, to achieve the above object, the present invention also provides a kind of database monitoring equipment, the database monitoring equipmentIncluding processor, memory and it is stored in the database monitor that can be executed on the memory and by the processor,When wherein the database monitor is executed by the processor, realize such as the step of above-mentioned database monitoring method.
In addition, to achieve the above object, the present invention also provides a kind of readable storage medium storing program for executing, being deposited on the readable storage medium storing program for executingDatabase monitor is contained, wherein realizing that above-mentioned database such as is supervised when the database monitor is executed by processorThe step of prosecutor method.
The present invention provides a kind of database monitoring method, device, equipment and readable storage medium storing program for executing, and the present invention receives to be monitoredThe connection configuration information of database, and according to connection configuration information, the connecting object in default monitoring template set is configured,To obtain current monitor template set;In database to be monitored, the monitoring SQL that subitem is respectively monitored in current monitor template set is executedSentence, and the monitored results according to each monitoring subitem determine whether trigger data library alarm command;If the alarm of trigger data library refers toIt enables, then the monitored results according to each monitoring subitem generate warning information, and send warning information according to preset alarm modeAlarm group of contacts is given, template set is monitored by setting, monitoring template set is used in PostgreSQL database under each application systemMonitoring, do not need operation maintenance personnel configuration monitoring strategy, only need simple configuration database connecting object, can be realizedThe monitoring of PostgreSQL database, the effective deployment difficulty for lowering monitoring, improves the applicability of database monitoring.
Detailed description of the invention
Fig. 1 is the hardware structural diagram for the database monitoring equipment that various embodiments of the present invention are related to;
Fig. 2 is the flow diagram of database monitoring method first embodiment of the present invention;
Fig. 3 is the flow diagram of database monitoring method second embodiment of the present invention;
Fig. 4 is the functional block diagram of database monitoring device first embodiment of the present invention.
The embodiments will be further described with reference to the accompanying drawings for the realization, the function and the advantages of the object of the present invention.
Specific embodiment
It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, it is not intended to limit the present invention.
The present embodiments relate to database monitoring method be mainly used in database monitoring equipment, the database monitoringEquipment, which can be PC (personal computer personal computer), portable computer, mobile terminal etc., has display and processingThe equipment of function.
Referring to Fig.1, Fig. 1 is the hardware structural diagram of database monitoring equipment involved in the embodiment of the present invention.In the embodiment of the present invention, database monitoring equipment may include (such as the central processing unit Central of processor 1001Processing Unit, CPU), communication bus 1002, user interface 1003, network interface 1004, memory 1005.Wherein,Communication bus 1002 is for realizing the connection communication between these components;User interface 1003 may include display screen(Display), input unit such as keyboard (Keyboard);Network interface 1004 optionally may include that the wired of standard connectsMouth, wireless interface (such as WI-FI interface);Memory 1005 can be high speed RAM memory, be also possible to stable memory(non-volatile memory), such as magnetic disk storage, memory 1005 optionally can also be independently of aforementioned processor1001 storage device.It will be understood by those skilled in the art that hardware configuration shown in Fig. 1 is not constituted to limit of the inventionIt is fixed, it may include perhaps combining certain components or different component layouts than illustrating more or fewer components.
With continued reference to Fig. 1, the memory 1005 in Fig. 1 as a kind of readable storage medium storing program for executing may include operating system, netNetwork communication module and database monitor.In Fig. 1, network communication module is mainly used for connecting server, with serverCarry out data communication;And processor 1001 can call the database monitor stored in memory 1005, and execute this hairThe database monitoring method that bright embodiment provides.
The embodiment of the invention provides a kind of database monitoring methods.
It is the flow diagram of database monitoring method first embodiment of the present invention referring to Fig. 2, Fig. 2.
In the present embodiment, which is realized by database monitoring equipment, which can be withIt is the terminal devices such as PC, palm PC and tablet computer, is chosen as equipment shown in FIG. 1, the database monitoring method includesFollowing steps:
Step S101 receives the connection configuration information of database to be monitored, and according to connection configuration information, to default monitoringConnecting object in template set is configured, to obtain current monitor template set;
Step S102 executes the monitoring SQL language that subitem is respectively monitored in current monitor template set in database to be monitoredSentence, and the monitored results according to each monitoring subitem determine whether trigger data library alarm command;
Step S103, if trigger data library alarm command, the monitored results according to each monitoring subitem generate warning information,And warning information is sent to alarm group of contacts according to preset alarm mode.
Currently, the monitor mode of PostgreSQL database is that operation maintenance personnel uses monitoring tools, configuration monitoring strategy prisonDatabase is controlled, for the database used under different application systems, operation maintenance personnel needs to configure different monitoring strategies, dataThe applicability and reliability of library monitoring are lower, influence the monitoring efficiency of database.In view of the above problem, proposed in the present embodimentA kind of database monitoring method, the specific steps of database monitoring method described in detail below:
Step S101 receives the connection configuration information of database to be monitored, and according to connection configuration information, to default monitoringConnecting object in template set is configured, to obtain current monitor template set;
In the present embodiment, when monitoring the configuration-direct of monitoring data collection of operation maintenance personnel triggering, equipment display connectionObject configuration interface, and receive the connection configuration for the database to be monitored that operation maintenance personnel is inputted based on the connecting object configuration interfaceInformation.Wherein, which includes but is not limited to grouping, system where the said system of database to be monitored, systemAffiliated function or subsidiary, alarm group of contacts, PostgreSQL database host IP, PostgreSQL database host port,Database-name, database login user and database login password, the connecting object configuration interface show object oriented andParameter declaration, and grouping, system affiliated function or subsidiary where the said system of database to be monitored, system and alarm connectionThe parameter declaration of group is alarm satellite information, and PostgreSQL database host IP, PostgreSQL database host port,The parameter declaration of database-name, database login user and database login password is monitoring data library configuration information.
Equipment receives the connection configuration information of database to be monitored, and according to connection configuration information, to default monitoring templateThe connecting object of concentration is configured, to obtain current monitor template set, i.e., to the data to be monitored in default monitoring template setSaid system, the grouping of system place, system affiliated function or the subsidiary in library, alarm group of contacts, PostgreSQL database masterMachine IP, PostgreSQL database host port, database-name, database login user and database login password are matchedIt sets.
Wherein, presetting monitoring template set includes but is not limited to the monitoring SQL statement of database availability monitor subitem, applicationSQL execution efficiency monitors monitoring SQL statement, the database of the monitoring SQL statement of subitem, background job executive condition monitoring subitemConnection number monitors the monitoring SQL statement of subitem and the monitoring SQL statement of Database lock monitoring subitem.Database availability monitorWhether the monitoring SQL statement of subitem can receive external request for monitoring data library, monitors subitem using SQL execution efficiencyMonitoring SQL statement be used to pass through database snapshot information, it is determined whether there are what execution efficiency was lower than default efficiency to apply SQLAnd for obtaining the current execution time for applying SQL by pg_stat_activity view, it is determined whether exist and currently holdThe row time is more than specified duration using SQL;The monitoring SQL statement that background job executive condition monitors subitem is used forFunction quartzchk is created in PostgreSQL database, is recalled function select*from quartzchk inquiry backstage and is madeIndustry executive condition;Current connection sum of the monitoring SQL statement of database connection number monitoring subitem for monitoring data library accounts for numberIt whether is more than given threshold according to the ratio of the maximum allowable connection number in library;The monitoring SQL statement of Database lock monitoring subitem is for supervisingWhen controlling whether database Database lock occurs, and Database lock occur, pass through pg_locks and pg_stat_activity viewIt is associated inquiry, refines each SQL statement lock status.
Specifically, equipment obtains the identification field of each connecting object in default monitoring template set, and according to each connecting objectIdentification field, the correspondence configuration parameter of each connecting object is obtained from the connection configuration information, i.e., connection configuration information inConfiguration parameter and identification field have corresponding relationship, can be inquired by the identification field of each connecting object and get each connecting objectCorrespondence configuration parameter, then according to the correspondence configuration parameter of each connecting object, to the connecting object in default monitoring template setIt is configured, to obtain current monitor template set, i.e., is configured the design parameter of each connecting object in default monitoring template setFor corresponding configuration parameter.
Step S102 executes the monitoring SQL language that subitem is respectively monitored in current monitor template set in database to be monitoredSentence, and the monitored results according to each monitoring subitem determine whether trigger data library alarm command;
In the present embodiment, in configuring default template set after the connecting object of database to be monitored, equipment is wait superviseIt controls in database, executes the monitoring SQL statement for respectively monitoring subitem in current monitor template set, and the monitoring according to each monitoring subitemAs a result determine whether trigger data library alarm command.Specifically, the monitoring SQL statement of database availability monitor subitem is executed,Whether monitoring data library can receive external request, if external request can not be received by monitoring database, monitor knotFruit is that database access is abnormal, if monitoring database can receive external request, monitored results are database accessNormally;
The monitoring SQL statement using SQL execution efficiency monitoring subitem is executed, monitoring data library SNAPSHOT INFO, statistics is recentlySQL executive condition is applied in given number of days, it is determined whether is lower than the application SQL of default efficiency there are execution efficiency and is passed throughPg_stat_activity view obtains the current execution time for applying SQL, it is determined whether there are current execution times more than fingerTiming it is long apply SQL, be lower than the application SQL of default efficiency if there is execution efficiency or there are current execution times to be more thanSpecified duration applies SQL, then monitored results are that execution efficiency is lower than the application SQL of default efficiency or current execution time is more thanSpecified duration applies SQL, i.e. SQL execution efficiency is abnormal, if default effect is respectively above or be equal to using the execution efficiency of SQLRate, and be respectively no more than specified duration using the current execution time of SQL, then monitored results are that SQL execution efficiency is normal;
The monitoring SQL statement for executing background job executive condition monitoring subitem, creates letter in PostgreSQL databaseNumber quartzchk recalls function select*from quartzchk inquiry background job executive condition, and monitored results areBackstage effect executive condition;Wherein, using first create function quartzchk, recall function select*fromWhen the mode of quartzchk inquires background job executive condition, when can avoid system of the monitoring without background job, the SQL of appearanceSentence reports an error phenomenon, improves applicability;
The monitoring SQL statement of database connection number monitoring subitem is executed, the current connection sum in monitoring data library accounts for dataWhether the ratio of the maximum allowable connection number in library is more than preset threshold, if the current connection sum of database accounts for database maximum and permitsPerhaps the ratio of connection number is more than preset threshold, then monitored results are the connection number of each user, and database excess load, if dataThe ratio that the current connection sum in library accounts for the maximum allowable connection number of database is no more than given threshold, then monitored results are databaseNon- excess load;
The monitoring SQL statement of Database lock monitoring subitem is executed, whether there is the SQL language of lock status in monitoring data librarySentence, if there are the SQL statements of lock status for database, is associated by pg_locks and pg_stat_activity viewInquiry, refines the lock status of the SQL statement, and monitored results include the affairs letter of the PID for generating the process locked, latching mode and lockBreath does not generate monitored results if the SQL statement of lock status is not present in database, wherein latching mode includesAccessShareLock、RowShareLock、RowExclusiveLock、ShareUpdateExclusiveLock、ShareLock, ShareRowExclusiveLock, ExclusiveLock and AccessExclusiveLock etc..
Specifically, equipment, which determines in each monitoring subitem, is located at default prison with the presence or absence of the monitored results of at least one monitoring subitemIt controls in result group, if the monitored results that respectively there is at least one monitoring subitem in monitoring subitem are located in default monitored results group,Trigger data library alarm command, otherwise trigger data alarm command, i.e., the monitored results of each monitoring subitem are not located at defaultIn monitored results group, then not trigger data alarm command.It should be noted that above-mentioned default monitored results group can be by this field skillArt personnel are configured based on actual conditions, and the present embodiment is not especially limited this.
Step S103, if trigger data library alarm command, the monitored results according to each monitoring subitem generate warning information,And warning information is sent to alarm group of contacts according to preset alarm mode.
In the present embodiment, if trigger data library alarm command, the monitored results according to each monitoring subitem generate alarmInformation, and the warning information is sent to alarm group of contacts according to preset alarm mode.Specifically, default warning information is obtainedTemplate, and the monitored results of each monitoring subitem are filled into the default warning information template, to generate warning information, that is, obtainThe location information of each monitoring subitem in the default warning information template, and the location information according to each monitoring subitem are taken, is determinedAffiliated filling position of each monitoring subitem in default warning information template, and the monitored results of each monitoring subitem are filled to pre-If filling position belonging to the correspondence in warning information template, to generate warning information.Wherein, warning information includes but is not limited to instituteGrouping, system affiliated function or subsidiary, alarm group of contacts and exception information where category system, system, and the exception information packetInclude but be not limited to database disconnect, the low SQL language using SQL, background job executive condition and lock status of execution efficiencySentence, the alarm mode include but is not limited to mail alarm, short message alarm and warning by telephone.
In the present embodiment, the present invention receives the connection configuration information of database to be monitored, and according to connection configuration information, rightConnecting object in default monitoring template set is configured, to obtain current monitor template set;In database to be monitored, executeThe monitoring SQL statement of subitem is respectively monitored in current monitor template set, and the monitored results according to each monitoring subitem determine whether to touchSend out database alarm command;If trigger data library alarm command, the monitored results according to each monitoring subitem generate warning information,And warning information is sent to alarm group of contacts according to preset alarm mode, template set is monitored by setting, monitors template setIt is used in the monitoring of PostgreSQL database under each application system, does not need operation maintenance personnel configuration monitoring strategy, is only needed simpleConfiguration database connecting object, the monitoring of PostgreSQL database can be realized, the effective deployment difficulty for lowering monitoring,Improve the applicability of database monitoring.
Further, referring to Fig. 3, it is based on above-mentioned first embodiment, proposes the second of database monitoring method of the present inventionEmbodiment, the difference with previous embodiment be, the database monitoring method further include:
Step 104 obtains currently available cpu resource, and according to currently available cpu resource, determines that database monitoring operatesExecutive mode be single task executive mode or multitask executive mode;
In the present embodiment, equipment obtains currently available cpu resource, and according to currently available cpu resource, determines that database is supervisedThe executive mode of control operation is single task executive mode or multitask executive mode, specially determines currently available cpu resourceWhether it is more than default cpu resource, if currently available cpu resource is more than default cpu resource, can determines that database monitoring is graspedThe executive mode of work is multitask executive mode, if currently available cpu resource is less than default cpu resource, can be determinedThe executive mode of database monitoring operation is single task executive mode.
If the executive mode of step 105, database monitoring operation is multitask executive mode, according to currently available CPUResource determines synchronous execution number of tasks, and according to the synchronous execution number of tasks, executes the monitoring of the monitoring subitem of corresponding numberSQL statement.
In the present embodiment, if the executive mode of database monitoring operation is multitask executive mode, foundation currently may be usedWith cpu resource determine it is synchronous execute number of tasks, that is, obtain the currently available cpu resource that prestores and the mapping of synchronous execution page numberRelation table, and from mapping table, synchronous execution number of tasks corresponding with currently available cpu resource is inquired, and according to synchronizationNumber of tasks is executed, executes the monitoring SQL statement of the monitoring subitem of corresponding number, i.e. equipment executes sequence according to default, wait superviseIt controls in database, executes and the monitoring SQL statement of the synchronous monitoring subitem for executing number of tasks corresponding number.If database monitoringThe executive mode of operation is single task executive mode, then executes the monitoring SQL statement of a monitoring subitem every time, i.e., equipment is according to pre-If executing sequence, in database to be monitored, the monitoring SQL statement that subitem is respectively monitored in current monitor template set is executed.It needsIllustrate, above-mentioned default execution sequence can be configured by those skilled in the art based on actual conditions, and the present embodiment is to thisIt is not especially limited.
Wherein, default cpu resource can be arranged according to CPU total resources, or be arranged according to specific needs by user.WhenWhen cpu resource is less than default cpu resource, it can be determined according to the mapping relations that can be used between cpu resource and synchronization page quantityThe synchronization page quantity that can be performed simultaneously, such as in mapping relations, when available cpu resource is less than A, what correspondence can be performed simultaneouslySynchronization page quantity is 2;When available cpu resource is more than or equal to A, is less than B, synchronization page number that correspondence can be performed simultaneouslyAmount is 3;When available cpu resource is more than or equal to B, is less than C, the synchronization page quantity that correspondence can be performed simultaneously is 4,In, A < B < C.
In the present embodiment, the present invention determines the prison of the synchronous monitoring subitem executed by the currently available cpu resource of equipmentSQL statement is controlled, equipment can be performed simultaneously the monitoring SQL statement of multiple monitoring subitems, effective to improve database monitoring efficiency.
In addition, the embodiment of the present invention also provides a kind of database monitoring device.
It is the functional block diagram of database monitoring device first embodiment of the present invention referring to Fig. 4, Fig. 4.
Database monitoring device of the present invention is virtual bench, is stored in the memory of database monitoring equipment shown in Fig. 1It is functional for realizing the institute of database monitor in 1005;Receive the connection configuration information of database to be monitored, and foundationThe connection configuration information configures the connecting object in default monitoring template set, to obtain current monitor template set;?In the database to be monitored, the monitoring SQL statement that subitem is respectively monitored in the current monitor template set is executed, and according to each prisonThe monitored results of control subitem determine whether trigger data library alarm command;If trigger data library alarm command, according to each monitoringThe monitored results of subitem generate warning information, and the warning information is sent to alarm connection according to preset alarm modeGroup.
Specifically, in the present embodiment, the database monitoring device includes:
Configuration module 101 matches confidence for receiving the connection configuration information of database to be monitored, and according to the connectionBreath configures the connecting object in default monitoring template set, to obtain current monitor template set;
Execution module 102, for executing in the database to be monitored, respectively monitoring is sub in the current monitor template setThe monitoring SQL statement of item, and the monitored results according to each monitoring subitem determine whether trigger data library alarm command;
Alarm module 103, if being used for trigger data library alarm command, the monitored results according to each monitoring subitem, which generate, is accusedAlert information, and the warning information is sent to alarm group of contacts according to preset alarm mode.
Further, the configuration module 101 is also used to:
The identification field of each connecting object in default monitoring template set, and the identification field according to each connecting object are obtained,The correspondence configuration parameter of each connecting object is obtained from the connection configuration information;
According to the correspondence configuration parameter of each connecting object, the connecting object in default monitoring template set is configured, withObtain current monitor template set.
Further, the execution module 102 is also used to:
It determines in each monitoring subitem and is located in default monitored results group with the presence or absence of the monitored results of at least one monitoring subitem;
If the monitored results that respectively there is at least one monitoring subitem in monitoring subitem are located in default monitored results group, triggerDatabase alarm command, otherwise not trigger data alarm command.
Further, the alarm module 103 is also used to:
Default warning information template is obtained, and the monitored results of each monitoring subitem are filled to the default warning information mouldIn plate, to generate warning information.
Further, the alarm module 103 is also used to:
Obtain the location information of each monitoring subitem in the default warning information template;
According to the location information of each monitoring subitem, affiliated filling of each monitoring subitem in default warning information template is determinedPosition;
The monitored results of each monitoring subitem are filled into filling position belonging to the correspondence into default warning information template.
Further, the database monitoring device further include:
Determining module determines database monitoring for obtaining currently available cpu resource, and according to currently available cpu resourceThe executive mode of operation is single task executive mode or multitask executive mode;
The execution module 102, if the executive mode for being also used to database monitoring operation is single task executive mode, oftenThe secondary monitoring SQL statement for executing a monitoring subitem;
The execution module 102, if the executive mode for being also used to database monitoring operation is multitask executive mode, according toSynchronous execution number of tasks is determined according to currently available cpu resource, and according to the synchronous execution number of tasks, executes the prison of corresponding numberControl the monitoring SQL statement of subitem.
Further, the execution module, is also used to:
The mapping table of the currently available cpu resource that acquisition prestores and synchronous execution number of tasks, and closed from the mappingIt is to inquire synchronous execution number of tasks corresponding with currently available cpu resource in table.
Wherein, the function of modules is realized and above-mentioned database monitoring method embodiment in above-mentioned database monitoring deviceIn each step it is corresponding, function and realization process no longer repeat one by one here.
In addition, the embodiment of the present invention also provides a kind of readable storage medium storing program for executing.
It is stored with database monitor on readable storage medium storing program for executing of the present invention, wherein the database monitor is processedWhen device executes, realize such as the step of above-mentioned database monitoring method.
Wherein, database monitor, which is performed realized method, can refer to each of database monitoring method of the present inventionA embodiment, details are not described herein again.
It should be noted that, in this document, the terms "include", "comprise" or its any other variant are intended to non-rowHis property includes, so that the process, method, article or the system that include a series of elements not only include those elements, andAnd further include other elements that are not explicitly listed, or further include for this process, method, article or system institute it is intrinsicElement.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including being somebody's turn to doThere is also other identical elements in the process, method of element, article or system.
The serial number of the above embodiments of the invention is only for description, does not represent the advantages or disadvantages of the embodiments.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment sideMethod can be realized by means of software and necessary general hardware platform, naturally it is also possible to by hardware, but in many casesThe former is more preferably embodiment.Based on this understanding, technical solution of the present invention substantially in other words does the prior artThe part contributed out can be embodied in the form of software products, which is stored in one as described aboveIn storage medium (such as ROM/RAM, magnetic disk, CD), including some instructions are used so that terminal device (it can be mobile phone,Computer, server, air conditioner or network equipment etc.) execute method described in each embodiment of the present invention.
The above is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hairEquivalent structure or equivalent flow shift made by bright specification and accompanying drawing content is applied directly or indirectly in other relevant skillsArt field, is included within the scope of the present invention.

Claims (10)

CN201810835443.0A2018-07-262018-07-26Database monitoring method, device, equipment and readable storage medium storing program for executingPendingCN109726073A (en)

Priority Applications (2)

Application NumberPriority DateFiling DateTitle
CN201810835443.0ACN109726073A (en)2018-07-262018-07-26Database monitoring method, device, equipment and readable storage medium storing program for executing
PCT/CN2018/103337WO2020019405A1 (en)2018-07-262018-08-30Database monitoring method, device and apparatus, and computer storage medium

Applications Claiming Priority (1)

Application NumberPriority DateFiling DateTitle
CN201810835443.0ACN109726073A (en)2018-07-262018-07-26Database monitoring method, device, equipment and readable storage medium storing program for executing

Publications (1)

Publication NumberPublication Date
CN109726073Atrue CN109726073A (en)2019-05-07

Family

ID=66294587

Family Applications (1)

Application NumberTitlePriority DateFiling Date
CN201810835443.0APendingCN109726073A (en)2018-07-262018-07-26Database monitoring method, device, equipment and readable storage medium storing program for executing

Country Status (2)

CountryLink
CN (1)CN109726073A (en)
WO (1)WO2020019405A1 (en)

Cited By (9)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN111737233A (en)*2020-06-242020-10-02浙江大华技术股份有限公司 Data monitoring method and device
CN112328449A (en)*2020-11-032021-02-05中国平安财产保险股份有限公司Data monitoring method, device, equipment and storage medium
CN112685251A (en)*2020-12-252021-04-20中国平安人寿保险股份有限公司Historical experience-based database intelligent monitoring method, system and storage medium
CN112787858A (en)*2020-12-302021-05-11浙江三维利普维网络有限公司Data model parameter configuration method and device, electronic device and storage medium
CN113127290A (en)*2019-12-312021-07-16北京金山云网络技术有限公司Service operation index monitoring method and device and server
CN113204565A (en)*2021-05-282021-08-03中国工商银行股份有限公司Database monitoring method and device
CN114510391A (en)*2021-12-312022-05-17安徽海豚新媒体产业发展有限公司 A Converged Infrastructure Monitoring and Management System
CN115118598A (en)*2022-06-232022-09-27三六零科技集团有限公司Information acquisition method, device, equipment and storage medium
CN115202979A (en)*2022-07-202022-10-18武汉物易云通网络科技有限公司 A kind of SQL real-time monitoring method, system, electronic device and storage medium

Citations (7)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN101989283A (en)*2009-08-042011-03-23中兴通讯股份有限公司Monitoring method and device of performance of database
CN105427545A (en)*2015-12-302016-03-23山东中创软件商用中间件股份有限公司Drools-based equipment warning management method and device
CN106385331A (en)*2016-09-082017-02-08努比亚技术有限公司Method and system for monitoring alarm based on log
US20170123890A1 (en)*2015-10-292017-05-04Commvault Systems, Inc.Monitoring, diagnosing, and repairing a management database in a data storage management system
CN107491371A (en)*2016-06-132017-12-19阿里巴巴集团控股有限公司A kind of method and device for monitoring deployment
CN107797866A (en)*2016-05-312018-03-13广东欧珀移动通信有限公司 Method for allocating processor resources and mobile terminal and media products
CN108052553A (en)*2017-11-292018-05-18平安养老保险股份有限公司Method, apparatus, computer equipment and the storage medium of electronic documentation generation

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN101763389B (en)*2008-12-232012-02-08中兴通讯股份有限公司Device and method for controlling database resource
JP5691723B2 (en)*2011-03-252015-04-01富士通株式会社 Monitoring method, information processing apparatus, and monitoring program
US9246777B2 (en)*2012-02-142016-01-26Hitachi, Ltd.Computer program and monitoring apparatus

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN101989283A (en)*2009-08-042011-03-23中兴通讯股份有限公司Monitoring method and device of performance of database
US20170123890A1 (en)*2015-10-292017-05-04Commvault Systems, Inc.Monitoring, diagnosing, and repairing a management database in a data storage management system
CN105427545A (en)*2015-12-302016-03-23山东中创软件商用中间件股份有限公司Drools-based equipment warning management method and device
CN107797866A (en)*2016-05-312018-03-13广东欧珀移动通信有限公司 Method for allocating processor resources and mobile terminal and media products
CN107491371A (en)*2016-06-132017-12-19阿里巴巴集团控股有限公司A kind of method and device for monitoring deployment
CN106385331A (en)*2016-09-082017-02-08努比亚技术有限公司Method and system for monitoring alarm based on log
CN108052553A (en)*2017-11-292018-05-18平安养老保险股份有限公司Method, apparatus, computer equipment and the storage medium of electronic documentation generation

Cited By (12)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN113127290A (en)*2019-12-312021-07-16北京金山云网络技术有限公司Service operation index monitoring method and device and server
CN113127290B (en)*2019-12-312024-05-31北京金山云网络技术有限公司Service operation index monitoring method, device and server
CN111737233A (en)*2020-06-242020-10-02浙江大华技术股份有限公司 Data monitoring method and device
CN112328449A (en)*2020-11-032021-02-05中国平安财产保险股份有限公司Data monitoring method, device, equipment and storage medium
CN112685251A (en)*2020-12-252021-04-20中国平安人寿保险股份有限公司Historical experience-based database intelligent monitoring method, system and storage medium
CN112787858A (en)*2020-12-302021-05-11浙江三维利普维网络有限公司Data model parameter configuration method and device, electronic device and storage medium
CN112787858B (en)*2020-12-302022-05-10浙江三维利普维网络有限公司Data model parameter configuration method and device, electronic device and storage medium
CN113204565A (en)*2021-05-282021-08-03中国工商银行股份有限公司Database monitoring method and device
CN113204565B (en)*2021-05-282024-12-06中国工商银行股份有限公司 Database monitoring method and device
CN114510391A (en)*2021-12-312022-05-17安徽海豚新媒体产业发展有限公司 A Converged Infrastructure Monitoring and Management System
CN115118598A (en)*2022-06-232022-09-27三六零科技集团有限公司Information acquisition method, device, equipment and storage medium
CN115202979A (en)*2022-07-202022-10-18武汉物易云通网络科技有限公司 A kind of SQL real-time monitoring method, system, electronic device and storage medium

Also Published As

Publication numberPublication date
WO2020019405A1 (en)2020-01-30

Similar Documents

PublicationPublication DateTitle
CN109726073A (en)Database monitoring method, device, equipment and readable storage medium storing program for executing
CN111818132B (en)Control method and device of Internet of things equipment, computer equipment and storage medium
CN109471789B (en)Multi-device management method and device for testing, server and storage medium
CN107291547B (en)Task scheduling processing method, device and system
WO2021203979A1 (en)Operation and maintenance processing method and apparatus, and computer device
CN109144559B (en)Update data packet pushing method and server
CN109582466A (en)A kind of timed task executes method, distributed server cluster and electronic equipment
CN110677274A (en)Event-based cloud network service scheduling method and device
CN107870772B (en)Cross-environment application deployment method, platform, system and readable storage medium
CN110308985B (en)Cloud exclusive server resource management method, device, equipment and storage medium
CN112564980B (en)Service monitoring method and system based on micro-service architecture
CN108600034B (en)Service pressure management method, device, equipment, system and storage medium
CN103188088A (en)Equipment information acquisition system and equipment information acquisition method
CN111429083A (en)Web front end and system for realizing batch management of RPA robots
CN110362474A (en)A kind of distributed game test method, system, device and storage medium
CN111143069A (en)Service management method, device, electronic equipment and storage medium
CN110059472A (en)Menu authority configuring method, device, equipment and readable storage medium storing program for executing
CN110827108B (en)Information searching method, searching request control method and system
CN111339194A (en)Automatic scheduling method and device for middleware of database access layer
CN103605575B (en)A kind of Cloud Foundry platform applications dispatch system and method
CN118132232A (en)Method, apparatus, device, storage medium and program product for executing offline tasks
CN111427704B (en)Remote monitoring method, device, equipment and storage medium for configuration instruction
CN109525443B (en)processing method and device for distributed pre-acquisition communication link and computer equipment
CN111343655A (en)Method for implementing wireless network, device for implementing wireless network and storage medium
CN111190828A (en)Industrial robot automatic test system and method

Legal Events

DateCodeTitleDescription
PB01Publication
PB01Publication
SE01Entry into force of request for substantive examination
SE01Entry into force of request for substantive examination
RJ01Rejection of invention patent application after publication

Application publication date:20190507

RJ01Rejection of invention patent application after publication

[8]ページ先頭

©2009-2025 Movatter.jp