CN105404581A - Database evaluation method and device - Google Patents
Database evaluation method and device Download PDFInfo
- Publication number
- CN105404581A CN105404581A CN201510997679.0A CN201510997679A CN105404581A CN 105404581 A CN105404581 A CN 105404581A CN 201510997679 A CN201510997679 A CN 201510997679A CN 105404581 A CN105404581 A CN 105404581A
- Authority
- CN
- China
- Prior art keywords
- performance
- target database
- database
- testing result
- evaluation
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3409—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
Abstract
The embodiments of the invention provide a database evaluation method and a device. The method specifically comprises the steps of receiving an evaluation instruction sent from a user, wherein the evaluation instruction comprises the parameters of a target database; acquiring the detection result of at least one performance of the target database according to the evaluation instruction; according to the detection result of at least one performance, grading the performance of the target database; and displaying the grading result of the target database. According to the embodiments of the invention, users can timely find out the abnormal phenomenon of the database. Therefore, the hysteresis problem of fault perception during the database maintenance process can be relieved as much as possible, so that the fault scale is reduced. The fault sensing time is also shortened.
Description
Technical field
The present invention relates to field of computer technology, particularly relate to a kind of evaluating method and device of database.
Background technology
Along with developing rapidly of computer and network technologies, data-base cluster is widely used in various field, is particularly useful for storing mass data.In actual applications, data-base cluster is usually in the face of write or the reading of mass data, and this just causes data-base cluster to there is certain failure rate, such as, there will be memory abnormal, hardware fault, network failure etc.
Can normally run to make data-base cluster; usual meeting setting data library manager (DBA) this role; DBA is responsible for the operation and maintenance of database; comprise the groundworks such as the installation of database, monitoring, fault detect, backup, recovery; can fault be solved during to break down in data-base cluster, maintain the normal operation of data-base cluster.
But for a long time, DBA is faced with two problems always, the problem of information delay when namely breaking down and failure cause location difficulty.That is, when breaking down in data-base cluster, DBA can not be known usually the very first time, often due to after fault causes application to block up, by applicating maintenance, personnel inform DBA, and now DBA is very passive, and after failure, database is generally in and stops response or response state extremely slowly, brings puzzlement greatly and inconvenience to DBA between process.In emergency circumstances, DBA may have to select to restart database to recover application as early as possible temporarily.But after database is restarted, due to the disappearance of site environment, problem is difficult to reproduce, and can not fundamentally solve Problems existing in data-base cluster.
Summary of the invention
In view of the above problems, the present invention is proposed to provide a kind of overcoming the problems referred to above or a kind of evaluating method of database solved the problem at least in part and device.
According to one aspect of the present invention, provide a kind of evaluating method of database, comprising:
Receive the evaluation and test instruction of user, wherein, described evaluation and test instruction comprises: the parameter of target database;
Obtain the testing result of at least one performance of target database corresponding to described evaluation and test instruction;
According to the testing result of described at least one performance, the performance of described target database is marked; And
Represent the appraisal result of described target database.
Alternatively, the step of the testing result of at least one performance of the target database that described acquisition described evaluation and test instruction is corresponding, comprises further:
The target database corresponding to described evaluation and test instruction carries out Performance Detection, to obtain the testing result of at least one corresponding performance; And/or
The testing result of at least one performance of described target database is obtained from the Performance Detection record prestored.
Alternatively, described testing result at least comprises the one as follows:
Network performance testing result, hardware performance testing result and database performance testing result.
Alternatively, the described testing result according to described at least one performance, to the step that the performance of described target database is marked, comprises further:
When described testing result meets preset deduction rule, the evaluation and test total score corresponding to described target database deducts mark corresponding to described deduction rule, to obtain final appraisal result.
Alternatively, described method also comprises:
When described testing result meets preset severely subnormal condition, give a warning information;
Wherein, described preset severely subnormal condition comprises at least one in following condition:
Master data base suspension in described target database;
Described target database corresponding master data base place server is delayed machine;
The service stopping of the corresponding master data base of described target database is run.
Alternatively, described in represent the step of the appraisal result of described target database, comprise further:
Carry out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, show the descriptor of the current performance title that detecting and this performance; And/or,
Carry out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, display detects progress bar and current scoring; And/or,
Carry out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, display stops control, stops detecting the performance of target database when this termination control is triggered.
Alternatively, detect at the target database execution performance corresponding to described evaluation and test instruction, after obtaining the testing result of at least one performance, described method also comprises:
Described testing result is saved to Performance Detection record.
Alternatively, the step that the described target database execution performance corresponding to described evaluation and test instruction detects, comprises further:
According to the detected parameters of user's input, determine the destination server that described in described target database correspondence database cluster, detected parameters is corresponding;
By destination server described in Telnet, network performance is performed to described destination server and detects and/or hardware performance detection.
Alternatively, the step that the described target database execution performance corresponding to described evaluation and test instruction detects, comprises further:
Receive detected object parameter and the test item parameter of user's input;
According to described detected object parameter, determine the destination server that described in described target database correspondence database cluster, detected object parameter is corresponding;
After destination server described in Telnet, perform database performance corresponding to described test item parameter and detect.
According to another aspect of the present invention, provide a kind of evaluating apparatus of database, comprising:
Command reception module, for receiving the evaluation and test instruction of user, wherein, described evaluation and test instruction comprises: the parameter of target database;
Result acquisition module, for obtaining the testing result of at least one performance of target database corresponding to described evaluation and test instruction;
Performance Score module, for the testing result according to described at least one performance, marks to the performance of described target database; And
Result display module, for representing the appraisal result of described target database.
Alternatively, described result acquisition module, comprises further:
Online acquisition submodule, carries out Performance Detection for the target database corresponding to described evaluation and test instruction, to obtain the testing result of at least one corresponding performance; And/or
Off-line obtains submodule, for obtaining the testing result of at least one performance of described target database from the Performance Detection record prestored.
Alternatively, described testing result at least comprises the one as follows:
Network performance testing result, hardware performance testing result and database performance testing result.
Alternatively, described Performance Score module, comprises further:
Performance Score submodule, during for meeting preset deduction rule in described testing result, the evaluation and test total score corresponding to described target database deducts mark corresponding to described deduction rule, to obtain final appraisal result.
Alternatively, described device also comprises:
Alarm module, for when described testing result meets preset severely subnormal condition, give a warning information;
Wherein, described preset severely subnormal condition comprises at least one in following condition:
Master data base suspension in described target database;
Described target database corresponding master data base place server is delayed machine;
The service stopping of the corresponding master data base of described target database is run.
Alternatively, described result display module, comprises further:
First shows submodule, for carrying out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, shows the descriptor of the current performance title that detecting and this performance; And/or,
Second shows submodule, and for carrying out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, display detects progress bar and current scoring; And/or,
3rd shows submodule, and for carrying out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, display stops control, stops detecting the performance of target database when this termination control is triggered.
Alternatively, described device also comprises:
Module preserved in record, for described testing result is saved to Performance Detection record.
Alternatively, described online acquisition submodule, comprises further:
First determining unit, for the detected parameters inputted according to user, determines the destination server that described in described target database correspondence database cluster, detected parameters is corresponding;
First detecting unit, for by destination server described in Telnet, performs network performance to described destination server and detects and/or hardware performance detection.
Alternatively, described online acquisition submodule, comprises further:
Parameter receiving element, for receiving detected object parameter and the test item parameter of user's input;
Second determining unit, for according to described detected object parameter, determines the destination server that described in described target database correspondence database cluster, detected object parameter is corresponding;
Second detecting unit, for after destination server described in Telnet, performs database performance corresponding to described test item parameter and detects.
According to evaluating method and the device of a kind of database of the embodiment of the present invention, according to the evaluation and test instruction received, obtain the testing result of at least one performance of target database, and according to the testing result of described at least one performance, the performance of described target database is marked, and represents the appraisal result of described target database; Because this appraisal result can reflect the health status of target database, such as, represent that this target database is in normal condition in this appraisal result higher than during scoring threshold value, or represent that this target database is in abnormality in this appraisal result lower than during scoring threshold value, therefore, the embodiment of the present invention can make user learn the health status of destination server in time; Like this, when this appraisal result is slightly lower than scoring threshold value, the embodiment of the present invention just can make the abnormal occurrence of user's Timeliness coverage database, therefore, it is possible to alleviate the hysteresis quality problem of fault perception in database maintenance as much as possible, thus can reduce fault scale and fault detecting period.
Above-mentioned explanation is only the general introduction of technical solution of the present invention, in order to technological means of the present invention can be better understood, and can be implemented according to the content of instructions, and can become apparent, below especially exemplified by the specific embodiment of the present invention to allow above and other objects of the present invention, feature and advantage.
Accompanying drawing explanation
By reading the detailed description of hereafter Alternate embodiments, various other advantage and benefit will become cheer and bright for those of ordinary skill in the art.Accompanying drawing only for illustrating the object of Alternate embodiments, and does not think limitation of the present invention.And in whole accompanying drawing, represent identical parts by identical reference symbol.In the accompanying drawings:
Fig. 1 shows a kind of according to an embodiment of the invention steps flow chart schematic diagram of evaluating method of database;
Fig. 2 shows a kind of according to an embodiment of the invention steps flow chart schematic diagram of evaluating method of database;
Fig. 3 shows a kind of according to an embodiment of the invention steps flow chart schematic diagram of evaluating method of database;
Fig. 4 shows a kind of according to an embodiment of the invention steps flow chart schematic diagram of evaluating method of database;
Fig. 5 shows a kind of according to an embodiment of the invention steps flow chart schematic diagram of evaluating method of database; And
Fig. 6 shows a kind of according to an embodiment of the invention structured flowchart of evaluating apparatus of database.
Embodiment
Below with reference to accompanying drawings exemplary embodiment of the present disclosure is described in more detail.Although show exemplary embodiment of the present disclosure in accompanying drawing, however should be appreciated that can realize the disclosure in a variety of manners and not should limit by the embodiment set forth here.On the contrary, provide these embodiments to be in order to more thoroughly the disclosure can be understood, and complete for the scope of the present disclosure can be conveyed to those skilled in the art.
With reference to Fig. 1, show a kind of according to an embodiment of the invention steps flow chart schematic diagram of evaluating method of database, specifically can comprise the steps:
The evaluation and test instruction of step 101, reception user, wherein, described evaluation and test instruction specifically can comprise: the parameter of target database;
Step 102, obtain the testing result of at least one performance of target database corresponding to described evaluation and test instruction;
Step 103, testing result according to described at least one performance, mark to the performance of described target database; And
Step 104, represent the appraisal result of described target database.
One of inventive concept of the embodiment of the present invention is, according to the evaluation and test instruction received, marks, and represent appraisal result at least one performance of target database.Particularly, the data messages such as the network state of each server in data-base cluster, hardware state and database running status can be obtained, thus performance evaluating can be carried out to target database, to obtain the health status of target database from aspects such as network performance, hardware performance and database performances.One of object of the embodiment of the present invention is existing database failure to proceed to initiatively precautionary approach from passive processing mode, fundamentally effectively reduces fault perception and processing time.
The embodiment of the present invention is applicable to the evaluation and test of the database of any type, wherein, described database can comprise the database of the type such as ORACLE (inscriptions on bones or tortoise shells), DB2, MySQL, is appreciated that the embodiment of the present invention is not limited for the particular type of database.For convenience of explanation, the embodiment of the present invention is all described for MySQL database, and the database of other type is cross-referenced.
The embodiment of the present invention may operate at the management server side in data-base cluster, and described management server can be used for the server in management database cluster, and performs corresponding Performance Detection according to the present situation of each server managed.Preset administration configuration file can be stored in management server, the information of each server in data-base cluster can be comprised, such as, in data-base cluster master data base place server, information etc. from database place server, proxy server, load-balanced server in this administration configuration file.
In actual applications, master's (Master) database and multiple from (Slave) database can specifically be comprised in data-base cluster.Certainly, in actual applications, those skilled in the art can build the data-base cluster of different framework as required, such as in order to the read and write abruption of fulfillment database, agency (Proxy) server can also be provided with in data-base cluster, and the load-balanced server etc. that can also arrange for increasing handling capacity, Strengthens network data-handling capacity, in a word, the embodiment of the present invention is not limited for the particular type of database and the concrete framework of data-base cluster.
In actual applications, described database goes in arbitrary operating system environment, such as (SuSE) Linux OS, Windows operating system etc., the specific operating system environment that the embodiment of the present invention is applicable to for database is not limited, for convenience of explanation, the embodiment of the present invention is all described for the database under (SuSE) Linux OS environment, and other operating system is cross-referenced.
In a kind of embodiment of the present invention, described testing result at least can comprise at least one in following result: network performance testing result, hardware performance testing result and database performance testing result.
The embodiment of the present invention can be evaluated and tested database, and obtain corresponding appraisal result, described appraisal result can be the appraisal result to above-mentioned wherein a kind of testing result, also can be that the appraisal result that comprehensive evaluating obtains is carried out to multiple testing result, particularly, the embodiment of the present invention can obtain the network state of each server in data-base cluster, hardware state, and the data message such as database running status, from network performance, the many aspects such as hardware performance and database performance carry out comprehensive evaluating to current database, to obtain final appraisal result, this appraisal result can be comprehensive, reflect Problems existing in current database objectively, can be optimized database to make DBA, relative to prior art after breaking down, the insoluble problem of fault, the embodiment of the present invention can before fault occurs, detect Problems existing hidden danger in database, and then the generation of fault can be avoided, prevent trouble before it happens.
In embodiments of the present invention, by showing UI (UserInterface, user interface) to user, can send evaluation and test instruction to make user and input the parameter of target database.In a kind of embodiment of the present invention, the parameter of described target database specifically can comprise: port numbers.Be appreciated that, the present invention is not limited for the concrete form of the parameter of target database, the parameter of above-mentioned target database can also comprise combination of IP (InternetProtocol, Internet protocol address) address or IP address and port numbers etc.In a kind of application example of the present invention, user is by UI input end slogan 3717, and click data storehouse evaluation and test button, then can send the evaluation and test instruction of the target database for port numbers 3717 correspondence.
In a kind of embodiment of the present invention, the step of the testing result of at least one performance of the target database that described acquisition described evaluation and test instruction is corresponding, can comprise further:
The target database corresponding to described evaluation and test instruction carries out Performance Detection, to obtain the testing result of at least one corresponding performance; And/or
The testing result of at least one performance of described target database is obtained from the Performance Detection record prestored.
In embodiments of the present invention, the concrete mode of testing result at least one the performance obtaining target database corresponding to described evaluation and test instruction is not limited, and can obtain corresponding testing result by the mode of on-line checkingi or offline search.Wherein, on-line checkingi mode specifically refers to, after receiving the evaluation and test instruction from user, performs on-line performance detect target database, to obtain the testing result of at least one corresponding performance; Offline search mode specifically refers to, obtains the testing result of at least one performance of target database by inquiring about the Performance Detection record prestored.
In a kind of embodiment of the present invention, described method can also comprise: detect at the target database execution performance corresponding to described evaluation and test instruction, after obtaining the testing result of at least one performance, described testing result is saved to Performance Detection record.By retention detection record, make when follow-up performing database evaluation and test, the testing result of at least one performance of target database directly can be obtained by offline search mode, such as can inquire about the testing result of at least one performance obtaining the last target database of preserving in 3 days, and carry out evaluation and test marking with this, thus the detection time can saved needed for on-line checkingi mode, to improve evaluation and test speed.Alternatively, the embodiment of the present invention can be arranged carries out Performance Detection regularly automatically to database, and preserves detection record, check for DBA, thus the abnormal data that exists in database can be found early, took preventive measures in advance before fault occurs, avoid causing unnecessary loss.
In a kind of embodiment of the present invention, described in represent the step of the appraisal result of described target database, can comprise further:
Carry out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, show the descriptor of the current performance title that detecting and this performance; And/or,
Carry out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, display detects progress bar and current scoring; And/or,
Carry out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, display stops control, stops detecting the performance of target database when this termination control is triggered.
In embodiments of the present invention, by showing the descriptor of the current performance title that detecting and this performance, and/or display detects progress bar and current scoring, make user can understand progress and the detection case of database performance detection in real time, to improve Consumer's Experience; In addition, by increasing control, such as, increasing preset button at reality interface, making to stop the current Performance Detection operation performed when user clicks this preset button, thus increasing the controllability of evaluation and test process.
In a kind of embodiment of the present invention, described appraisal result can be represented by pre-set page mode in display interface, check to facilitate user.Particularly, appraisal result can be represented in pre-set page mode by the UI such as usage log file, form, chart, user can be presented to more intuitively to make appraisal result.Be appreciated that the embodiment of the present invention is not limited for the concrete form of pre-set page.
To sum up, the embodiment of the present invention, according to the evaluation and test instruction received, obtains the testing result of at least one performance of target database, and according to the testing result of described at least one performance, the performance of described target database is marked, and represents the appraisal result of described target database; Because this appraisal result can reflect the health status of target database, such as, represent that this target database is in normal condition in this appraisal result higher than during scoring threshold value, or represent that this target database is in abnormality in this appraisal result lower than during scoring threshold value, therefore, the embodiment of the present invention can make user learn the health status of destination server in time; Like this, when this appraisal result is slightly lower than scoring threshold value, the embodiment of the present invention just can make the abnormal occurrence of user's Timeliness coverage database, therefore, it is possible to alleviate the hysteresis quality problem of fault perception in database maintenance as much as possible, thus can reduce fault scale and fault detecting period.
With reference to Fig. 2, show a kind of according to an embodiment of the invention steps flow chart schematic diagram of evaluating method of database, specifically can comprise the steps:
The evaluation and test instruction of step 201, reception user, wherein, described evaluation and test instruction specifically can comprise: the parameter of target database;
Step 202, obtain the testing result of at least one performance of target database corresponding to described evaluation and test instruction;
Step 203, when described testing result meets preset deduction rule, the evaluation and test total score corresponding to described target database deducts mark corresponding to described deduction rule, to obtain final appraisal result; And
Step 204, represent the appraisal result of described target database.
The present embodiment, on basis embodiment illustrated in fig. 2, according to preset deduction rule, can be marked to the performance of described target database.In actual applications, when evaluating and testing database, can arrange initial evaluation and test total score is full marks such as 100 points, when marking to the testing result of at least one the performance obtained, if wherein the testing result of a certain performance meets preset deduction rule, then can deduct corresponding mark from 100 points, to obtain final appraisal result.
In a kind of application example of the present invention, when carrying out comprehensive evaluating to the testing result of multinomial performance, the score that the testing result of properties can pro rata distributed is corresponding, such as, for network performance testing result, the testing result of hardware performance testing result and these three performances of database performance testing result carries out evaluation and test score, wherein network performance can be pre-set and account for 30 points, hardware performance accounts for 30 points, database performance accounts for 40 points, when carrying out evaluation and test marking to the testing result of properties, if meet preset deduction rule, from 100 points, then deduct corresponding mark, to obtain final appraisal result, in the lower database of descriptions of this appraisal result, Problems existing is more serious.Such as, learnt from the connectedness of database place server by network performance testing result and break down, 5 points can be deducted; Learn that CPU usage exceedes pre-determined threshold by hardware performance testing result, 20 points can be deducted; Learn that slow inquiry duration exceeds preset time range by database performance testing result, 10 points can be deducted; Obtaining final appraisal result is 65 points.When this final appraisal result is presented to user, the deduction situation etc. that the performance title of detection, the descriptor of this performance and this performance are corresponding can also be shown, with to Problems existing in the user intuitively evaluation result in display data storehouse and database to user.
In another kind of application example of the present invention, evaluation and test marking can also be carried out to target database according to seriousness abnormal in testing result, such as, the database performance testing result by obtaining can be learnt, in this target database, the service of master data base is out of service, then this exception belongs to severely subnormal, has had influence on the use of database basic function, therefore, directly appraisal result can be kept to 0 point, and the notice that gives a warning.
Be appreciated that, above by deduction rule, evaluation and test marking is carried out only as a kind of application example of the present invention to target database, the embodiment of the present invention is not limited for concrete marking rule, such as can also be set to 0 point by initially evaluating and testing total score, carry out evaluation and test marking by bonus point rule to target database, in the higher then database of descriptions of final appraisal result, Problems existing is more serious.
In a kind of embodiment of the present invention, DBA can according to the appraisal result of the target database represented, problem in target database is analyzed, to deal with problems and to be optimized database, such as can find the unreasonable part of data-base cluster framework, thus can be optimized database aggregated structure.In a kind of application example of the present invention, can be learnt by the database performance testing result obtained, this testing result comprises a large amount of slow queried access records, inquiry duration of waiting a moment exceeds preset time range, then can think that current business is not suitable for by Proxy accessing database, should adjust database aggregated structure, be adjusted to client directly to the framework that database conducts interviews, to improve business processing efficiency.
With reference to Fig. 3, show a kind of according to an embodiment of the invention steps flow chart schematic diagram of evaluating method of database, specifically can comprise the steps:
The evaluation and test instruction of step 301, reception user, wherein, described evaluation and test instruction specifically can comprise: the parameter of target database;
Step 302, obtain the testing result of at least one performance of target database corresponding to described evaluation and test instruction;
Step 303, testing result according to described at least one performance, mark to the performance of described target database;
Step 304, represent the appraisal result of described target database;
Step 305, when described testing result meets preset severely subnormal condition, give a warning information; Wherein, described preset severely subnormal condition comprises at least one in following condition: the master data base suspension in described target database; Described target database corresponding master data base place server is delayed machine; The service stopping of the corresponding master data base of described target database is run.
The present embodiment, can also when testing result meets preset severely subnormal condition on basis embodiment illustrated in fig. 2, to give a warning information, occur severely subnormal with reminding user database to user.Be appreciated that the embodiment of the present invention does not limit for the execution of step 305 opportunity, such as, can when performing step 302, find that described testing result meets preset severely subnormal condition, can give a warning information, or, after can also terminating evaluating and testing marking, then the information that gives a warning.
In a kind of embodiment of the present invention, Performance Detection is carried out in the target database corresponding to described evaluation and test instruction, to obtain in the process of the testing result of at least one corresponding performance, when finding that described testing result meets preset severely subnormal condition, can to give a warning information to user.In another kind of embodiment of the present invention, the testing result of current performance and the testing result in the Performance Detection prestored record can also be compared, to determine the running status trend of database, and whether there is severely subnormal according to the running status trend evaluation database of database.
Wherein, preset severely subnormal condition can be used for occurring severely subnormal in expression database to such an extent as to any adjustment affecting the normal use of database.Such as, master data base suspension, master data base place server are delayed the service stopping operation etc. of machine, master data base.Be appreciated that above-mentioned preset severely subnormal condition is only as a kind of application example of the present invention, the embodiment of the present invention is not limited for the particular content of preset severely subnormal condition, such as, can also comprise: the free memory of database exceedes preset thresholding etc.
To sum up, the embodiment of the present invention is being evaluated and tested target database, obtain the testing result of at least one performance of described target database, and according to the testing result of described at least one performance, the performance of described target database is marked, while obtaining corresponding appraisal result, can also when described testing result meet preset severely subnormal condition, give a warning information.By the embodiment of the present invention, can in the process that database is evaluated and tested, the severely subnormal existed in user's reminder-data storehouse, stops the abnormal trend worsened further of database with Timeliness coverage.
With reference to Fig. 4, show a kind of according to an embodiment of the invention steps flow chart schematic diagram of evaluating method of database, specifically can comprise the steps:
The evaluation and test instruction of step 401, reception user, wherein, described evaluation and test instruction specifically can comprise: the parameter of target database;
Step 402, the detected parameters inputted according to user, determine the destination server that described in described target database correspondence database cluster, detected parameters is corresponding;
Step 403, by destination server described in Telnet, network performance is performed to described destination server and to detect and/or hardware performance detects, to obtain the testing result of at least one corresponding performance;
Step 404, testing result according to described at least one performance, mark to the performance of described target database;
Step 405, represent the appraisal result of described target database.
The present embodiment, on basis embodiment illustrated in fig. 2, after the evaluation and test instruction receiving user, can perform network performance to target database and detect and/or hardware performance detection, to obtain the testing result of at least one corresponding performance.
Particularly, performance detection module can be provided with in management server, to perform the Performance Detection flow process of database in the embodiment of the present invention.Wherein, described performance detection module can run preset python script, to provide the input interface of detected parameters to user; Further, according to the detected parameters of user's input, the detection list that this detected parameters is corresponding can also be obtained, then by each destination server in detection list described in Telnet, each destination server execution performance be detected, thus obtains testing result.Wherein, described destination server can comprise master data base place server, from database place server and proxy server etc.
Wherein, described Performance Detection specifically can comprise network performance detection and hardware performance detection.When performing network performance to destination server and detecting, python script Telnet destination server can be performed by the performance detection module in management server, after Telnet destination server, can by performing network sense command, the network state of destination server is detected, detects corresponding testing result to obtain network performance.
Detect to perform hardware performance to destination server, hardware detecting module can be set in described destination server, for collecting the hardware state of destination server, detect corresponding testing result to obtain hardware performance, whether the utilization factor of such as CPU exceedes preset thresholding etc.Wherein, the function of the hardware state of described hardware detecting module collection destination server can be realized by shell script.Particularly, python script Telnet destination server can be performed by the performance detection module in management server, after Telnet destination server, this hardware detecting module is called by python script, the hardware state that destination server collected by shell script is performed to make this hardware detecting module, and received the testing result of the hardware performance detection correspondence that shell script returns by python script, to complete the detection of the hardware performance to destination server.
To sum up, by the embodiment of the present invention, can obtain the testing result of at least one performance of target database corresponding to the evaluation and test instruction that receives, wherein, described testing result comprises network performance and to detect and/or hardware performance detects corresponding testing result.The embodiment of the present invention can be marked to database according to the network performance of database and/or hardware performance, and represents the appraisal result of described target database.To make the embodiment of the present invention can carry out comprehensive evaluating according to many factors to database, obtain more accurate, considerable scoring, and can provide for user the foundation solving Problems existing and optimization data in database.
With reference to Fig. 5, show a kind of according to an embodiment of the invention steps flow chart schematic diagram of evaluating method of database, specifically can comprise the steps:
The evaluation and test instruction of step 501, reception user, wherein, described evaluation and test instruction specifically can comprise: the parameter of target database;
Step 502, the detected object parameter receiving user's input and test item parameter;
Step 503, according to described detected object parameter, determine the destination server that described in described target database correspondence database cluster, detected object parameter is corresponding;
Step 504, after destination server described in Telnet, perform database performance corresponding to described test item parameter and detect, to obtain the testing result of at least one corresponding performance;
Step 505, testing result according to described at least one performance, mark to the performance of described target database;
Step 506, represent the appraisal result of described target database.
The present embodiment on basis embodiment illustrated in fig. 2, after the evaluation and test instruction receiving user, can to target database performing database Performance Detection, to obtain the testing result of at least one corresponding performance.
Particularly, performance detection module can be provided with in management server, to perform the Performance Detection flow process of database in the embodiment of the present invention.Wherein, described performance detection module can run preset python script, to provide the input interface of detected object parameter and test item parameter to user; And, can also according to the detected object parameter of user's input, obtain the detection list that this detected object parameter is corresponding, again by each destination server in detection list described in Telnet, perform database performance corresponding to described test item parameter to detect, to obtain the testing result of at least one corresponding performance.Wherein, described destination server can comprise master data base place server, from database place server and proxy server etc.The type of described test item parameter specifically can comprise: at least one during detection of connectivity, agency (Proxy) detection and database detect.Wherein, whether detection of connectivity can normal connection data storehouse for detecting user account; Whether Proxy detects normal for detecting by the state of proxy server accessing database; And whether the running status that database detects for Test database is normal, whether the internal memory service condition of such as database, exist slow inquiry etc.
In a kind of application example of the present invention, if comprise the disabled user's visit information in nearest 1 hour in the testing result obtained, and multiple disabled user's visit information is identical, then illustrate that the access rights of this user account may arrange mistake, then notification data library manager can check the access rights of this user account.In another kind of application example of the present invention, if this testing result comprises the slow queried access record that a large amount of slow inquiry durations exceedes preset time scope, then can think that current business is not suitable for by Proxy accessing database, the mode that database is directly accessed should be adjusted to, to improve business processing efficiency.
Can be detected by database performance corresponding to test item parameter by the embodiment of the present invention, to obtain the testing result of at least one corresponding performance, and according to the testing result of described at least one performance, the performance of described target database is marked.To make the embodiment of the present invention can carry out comprehensive evaluating according to many factors to database, obtain more accurate, considerable scoring, and can provide for user the foundation solving Problems existing and optimization data in database.
In a kind of application example of the present invention, evaluation and test module can be provided with in management server, for receiving and performing the evaluation and test instruction from user; Wherein, described evaluation and test instruction specifically can comprise: the parameter of target database.This evaluation and test module can be evaluated and tested target database by running preset python script.Particularly, first, the testing result of at least one performance of target database corresponding to described evaluation and test instruction can be obtained by the mode of on-line checkingi or offline search.Such as, Performance Detection can be carried out by the online target database corresponding to described evaluation and test instruction, to obtain the testing result of at least one corresponding performance; Or, the testing result of at least one performance of described target database can be obtained from the Performance Detection record prestored.Wherein, described testing result at least can comprise the one as follows: network performance testing result, hardware performance testing result and database performance testing result.Then, according to the testing result of described at least one performance, the performance of described target database is marked; Such as, when described testing result meets preset deduction rule, the evaluation and test total score corresponding to described target database deducts mark corresponding to described deduction rule, to obtain final appraisal result; Finally, the appraisal result of described target database is represented.
With reference to Fig. 6, show a kind of according to an embodiment of the invention structured flowchart of evaluating apparatus of database, specifically can comprise as lower module:
Command reception module 610, for receiving the evaluation and test instruction of user, wherein, described evaluation and test instruction specifically can comprise: the parameter of target database;
Result acquisition module 620, for obtaining the testing result of at least one performance of target database corresponding to described evaluation and test instruction;
Performance Score module 630, for the testing result according to described at least one performance, marks to the performance of described target database; And
Result display module 640, for representing the appraisal result of described target database.
In a kind of embodiment of the present invention, described result acquisition module 620, can comprise further:
Online acquisition submodule, carries out Performance Detection for the target database corresponding to described evaluation and test instruction, to obtain the testing result of at least one corresponding performance; And/or
Off-line obtains submodule, for obtaining the testing result of at least one performance of described target database from the Performance Detection record prestored.
In another kind of embodiment of the present invention, described testing result at least can comprise the one as follows:
Network performance testing result, hardware performance testing result and database performance testing result.
In another preferred embodiment of the present invention, described Performance Score module 630, can comprise further:
Performance Score submodule, during for meeting preset deduction rule in described testing result, the evaluation and test total score corresponding to described target database deducts mark corresponding to described deduction rule, to obtain final appraisal result.
In another preferred embodiment of the present invention, described device can also comprise:
Alarm module, for when described testing result meets preset severely subnormal condition, give a warning information;
Wherein, described preset severely subnormal condition can comprise at least one in following condition:
Master data base suspension in described target database;
Described target database corresponding master data base place server is delayed machine;
The service stopping of the corresponding master data base of described target database is run.
In another preferred embodiment of the present invention, described result display module 640, can comprise further:
First shows submodule, for carrying out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, shows the descriptor of the current performance title that detecting and this performance; And/or,
Second shows submodule, and for carrying out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, display detects progress bar and current scoring; And/or,
3rd shows submodule, and for carrying out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, display stops control, stops detecting the performance of target database when this termination control is triggered.
In another preferred embodiment of the present invention, described device can also comprise:
Module preserved in record, for described testing result is saved to Performance Detection record.
In another preferred embodiment of the present invention, described online acquisition submodule, can comprise further:
First determining unit, for the detected parameters inputted according to user, determines the destination server that described in described target database correspondence database cluster, detected parameters is corresponding;
First detecting unit, for by destination server described in Telnet, performs network performance to described destination server and detects and/or hardware performance detection.
In another preferred embodiment of the present invention, described online acquisition submodule, can comprise further:
Parameter receiving element, for receiving detected object parameter and the test item parameter of user's input;
Second determining unit, for according to described detected object parameter, determines the destination server that described in described target database correspondence database cluster, detected object parameter is corresponding;
Second detecting unit, for after destination server described in Telnet, performs database performance corresponding to described test item parameter and detects.
For device embodiment, due to itself and embodiment of the method basic simlarity, so description is fairly simple, relevant part illustrates see the part of embodiment of the method.
Intrinsic not relevant to any certain computer, virtual system or miscellaneous equipment with display at this algorithm provided.Various general-purpose system also can with use based on together with this teaching.According to description above, the structure constructed required by this type systematic is apparent.In addition, the present invention is not also for any certain programmed language.It should be understood that and various programming language can be utilized to realize content of the present invention described here, and the description done language-specific is above to disclose preferred forms of the present invention.
In instructions provided herein, describe a large amount of detail.But can understand, embodiments of the invention can be put into practice when not having these details.In some instances, be not shown specifically known method, structure and technology, so that not fuzzy understanding of this description.
Similarly, be to be understood that, in order to simplify the disclosure and to help to understand in each inventive aspect one or more, in the description above to exemplary embodiment of the present invention, each feature of the present invention is grouped together in single embodiment, figure or the description to it sometimes.But, the method for the disclosure should be construed to the following intention of reflection: namely the present invention for required protection requires feature more more than the feature clearly recorded in each claim.Or rather, as claims below reflect, all features of disclosed single embodiment before inventive aspect is to be less than.Therefore, the claims following embodiment are incorporated to this embodiment thus clearly, and wherein each claim itself is as independent embodiment of the present invention.
Those skilled in the art are appreciated that and adaptively can change the module in the equipment in embodiment and they are arranged in one or more equipment different from this embodiment.Module in embodiment or unit or assembly can be combined into a module or unit or assembly, and multiple submodule or subelement or sub-component can be put them in addition.Except at least some in such feature and/or process or unit be mutually repel except, any combination can be adopted to combine all processes of all features disclosed in this instructions (comprising adjoint claim, summary and accompanying drawing) and so disclosed any method or equipment or unit.Unless expressly stated otherwise, each feature disclosed in this instructions (comprising adjoint claim, summary and accompanying drawing) can by providing identical, alternative features that is equivalent or similar object replaces.
In addition, those skilled in the art can understand, although embodiments more described herein to comprise in other embodiment some included feature instead of further feature, the combination of the feature of different embodiment means and to be within scope of the present invention and to form different embodiments.Such as, in the following claims, the one of any of embodiment required for protection can use with arbitrary array mode.
All parts embodiment of the present invention with hardware implementing, or can realize with the software module run on one or more processor, or realizes with their combination.It will be understood by those of skill in the art that the some or all functions that microprocessor or digital signal processor (DSP) can be used in practice to realize according to the some or all parts in the evaluating method of the database of the embodiment of the present invention and device.The present invention can also be embodied as part or all equipment for performing method as described herein or device program (such as, computer program and computer program).Realizing program of the present invention and can store on a computer-readable medium like this, or the form of one or more signal can be had.Such signal can be downloaded from Internet platform and obtain, or provides on carrier signal, or provides with any other form.
The present invention will be described instead of limit the invention to it should be noted above-described embodiment, and those skilled in the art can design alternative embodiment when not departing from the scope of claims.In the claims, any reference symbol between bracket should be configured to limitations on claims.Word " comprises " or " comprising " is not got rid of existence and do not arrange element in the claims or step.Word "a" or "an" before being positioned at element is not got rid of and be there is multiple such element.The present invention can by means of including the hardware of some different elements and realizing by means of the computing machine of suitably programming.In the unit claim listing some devices, several in these devices can be carry out imbody by same hardware branch.Word first, second and third-class use do not represent any order.Can be title by these word explanations.
The invention discloses the evaluating method of A1, a kind of database, comprising:
Receive the evaluation and test instruction of user, wherein, described evaluation and test instruction comprises: the parameter of target database;
Obtain the testing result of at least one performance of target database corresponding to described evaluation and test instruction;
According to the testing result of described at least one performance, the performance of described target database is marked; And
Represent the appraisal result of described target database.
A2, method as described in claim A1, the step of the testing result of at least one performance of the target database that described acquisition described evaluation and test instruction is corresponding, comprises further:
The target database corresponding to described evaluation and test instruction carries out Performance Detection, to obtain the testing result of at least one corresponding performance; And/or
The testing result of at least one performance of described target database is obtained from the Performance Detection record prestored.
A3, method as described in claim A1, described testing result at least comprise following in one:
Network performance testing result, hardware performance testing result and database performance testing result.
A4, method as described in claim A1, the described testing result according to described at least one performance, to the step that the performance of described target database is marked, comprises further:
When described testing result meets preset deduction rule, the evaluation and test total score corresponding to described target database deducts mark corresponding to described deduction rule, to obtain final appraisal result.
A5, method as described in claim A1, described method also comprises:
When described testing result meets preset severely subnormal condition, give a warning information;
Wherein, described preset severely subnormal condition comprises at least one in following condition:
Master data base suspension in described target database;
Described target database corresponding master data base place server is delayed machine;
The service stopping of the corresponding master data base of described target database is run.
A6, method as described in claim A2, described in represent the step of the appraisal result of described target database, comprise further:
Carry out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, show the descriptor of the current performance title that detecting and this performance; And/or,
Carry out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, display detects progress bar and current scoring; And/or,
Carry out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, display stops control, stops detecting the performance of target database when this termination control is triggered.
A7, method as described in claim A2, detect at the target database execution performance corresponding to described evaluation and test instruction, after obtaining the testing result of at least one performance, described method also comprises:
Described testing result is saved to Performance Detection record.
A8, method as described in claim A2, the step that the described target database execution performance corresponding to described evaluation and test instruction detects, comprises further:
According to the detected parameters of user's input, determine the destination server that described in described target database correspondence database cluster, detected parameters is corresponding;
By destination server described in Telnet, network performance is performed to described destination server and detects and/or hardware performance detection.
A9, method as described in claim A2, the step that the described target database execution performance corresponding to described evaluation and test instruction detects, comprises further:
Receive detected object parameter and the test item parameter of user's input;
According to described detected object parameter, determine the destination server that described in described target database correspondence database cluster, detected object parameter is corresponding;
After destination server described in Telnet, perform database performance corresponding to described test item parameter and detect.
The invention discloses the performance evaluating apparatus of B10, a kind of data-base cluster, comprising:
Command reception module, for receiving the evaluation and test instruction of user, wherein, described evaluation and test instruction comprises: the parameter of target database;
Result acquisition module, for obtaining the testing result of at least one performance of target database corresponding to described evaluation and test instruction;
Performance Score module, for the testing result according to described at least one performance, marks to the performance of described target database; And
Result display module, for representing the appraisal result of described target database.
B11, device as described in claim B10, described result acquisition module, comprises further:
Online acquisition submodule, carries out Performance Detection for the target database corresponding to described evaluation and test instruction, to obtain the testing result of at least one corresponding performance; And/or
Off-line obtains submodule, for obtaining the testing result of at least one performance of described target database from the Performance Detection record prestored.
B12, device as described in claim B10, described testing result at least comprise following in one:
Network performance testing result, hardware performance testing result and database performance testing result.
B13, device as described in claim B10, described Performance Score module, comprises further:
Performance Score submodule, during for meeting preset deduction rule in described testing result, the evaluation and test total score corresponding to described target database deducts mark corresponding to described deduction rule, to obtain final appraisal result.
B14, device as described in claim B10, described device also comprises:
Alarm module, for when described testing result meets preset severely subnormal condition, give a warning information;
Wherein, described preset severely subnormal condition comprises at least one in following condition:
Master data base suspension in described target database;
Described target database corresponding master data base place server is delayed machine;
The service stopping of the corresponding master data base of described target database is run.
B15, device as described in claim B11, described result display module, comprises further:
First shows submodule, for carrying out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, shows the descriptor of the current performance title that detecting and this performance; And/or,
Second shows submodule, and for carrying out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, display detects progress bar and current scoring; And/or,
3rd shows submodule, and for carrying out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, display stops control, stops detecting the performance of target database when this termination control is triggered.
B16, device as described in claim B11, described device also comprises:
Module preserved in record, for described testing result is saved to Performance Detection record.
B17, device as described in claim B11, described online acquisition submodule, comprises further:
First determining unit, for the detected parameters inputted according to user, determines the destination server that described in described target database correspondence database cluster, detected parameters is corresponding;
First detecting unit, for by destination server described in Telnet, performs network performance to described destination server and detects and/or hardware performance detection.
B18, device as described in claim B11, described online acquisition submodule, comprises further:
Parameter receiving element, for receiving detected object parameter and the test item parameter of user's input;
Second determining unit, for according to described detected object parameter, determines the destination server that described in described target database correspondence database cluster, detected object parameter is corresponding;
Second detecting unit, for after destination server described in Telnet, performs database performance corresponding to described test item parameter and detects.
Claims (10)
1. an evaluating method for database, comprising:
Receive the evaluation and test instruction of user, wherein, described evaluation and test instruction comprises: the parameter of target database;
Obtain the testing result of at least one performance of target database corresponding to described evaluation and test instruction;
According to the testing result of described at least one performance, the performance of described target database is marked; And
Represent the appraisal result of described target database.
2. the method for claim 1, is characterized in that, the step of the testing result of at least one performance of the target database that described acquisition described evaluation and test instruction is corresponding, comprises further:
The target database corresponding to described evaluation and test instruction carries out Performance Detection, to obtain the testing result of at least one corresponding performance; And/or
The testing result of at least one performance of described target database is obtained from the Performance Detection record prestored.
3. the method for claim 1, is characterized in that, described testing result at least comprises the one as follows:
Network performance testing result, hardware performance testing result and database performance testing result.
4. the method for claim 1, is characterized in that, the described testing result according to described at least one performance, to the step that the performance of described target database is marked, comprises further:
When described testing result meets preset deduction rule, the evaluation and test total score corresponding to described target database deducts mark corresponding to described deduction rule, to obtain final appraisal result.
5. the method for claim 1, is characterized in that, described method also comprises:
When described testing result meets preset severely subnormal condition, give a warning information;
Wherein, described preset severely subnormal condition comprises at least one in following condition:
Master data base suspension in described target database;
Described target database corresponding master data base place server is delayed machine;
The service stopping of the corresponding master data base of described target database is run.
6. method as claimed in claim 2, is characterized in that, described in represent the step of the appraisal result of described target database, comprise further:
Carry out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, show the descriptor of the current performance title that detecting and this performance; And/or,
Carry out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, display detects progress bar and current scoring; And/or,
Carry out in the process of Performance Detection in the target database corresponding to described evaluation and test instruction, display stops control, stops detecting the performance of target database when this termination control is triggered.
7. method as claimed in claim 2, is characterized in that, detect at the target database execution performance corresponding to described evaluation and test instruction, after obtaining the testing result of at least one performance, described method also comprises:
Described testing result is saved to Performance Detection record.
8. method as claimed in claim 2, is characterized in that, the step that the described target database execution performance corresponding to described evaluation and test instruction detects comprises further:
According to the detected parameters of user's input, determine the destination server that described in described target database correspondence database cluster, detected parameters is corresponding;
By destination server described in Telnet, network performance is performed to described destination server and detects and/or hardware performance detection.
9. method as claimed in claim 2, is characterized in that, the step that the described target database execution performance corresponding to described evaluation and test instruction detects comprises further:
Receive detected object parameter and the test item parameter of user's input;
According to described detected object parameter, determine the destination server that described in described target database correspondence database cluster, detected object parameter is corresponding;
After destination server described in Telnet, perform database performance corresponding to described test item parameter and detect.
10. a performance evaluating apparatus for data-base cluster, comprising:
Command reception module, for receiving the evaluation and test instruction of user, wherein, described evaluation and test instruction comprises: the parameter of target database;
Result acquisition module, for obtaining the testing result of at least one performance of target database corresponding to described evaluation and test instruction;
Performance Score module, for the testing result according to described at least one performance, marks to the performance of described target database; And
Result display module, for representing the appraisal result of described target database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510997679.0A CN105404581B (en) | 2015-12-25 | 2015-12-25 | A kind of evaluating method and device of database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510997679.0A CN105404581B (en) | 2015-12-25 | 2015-12-25 | A kind of evaluating method and device of database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105404581A true CN105404581A (en) | 2016-03-16 |
| CN105404581B CN105404581B (en) | 2019-03-05 |
Family
ID=55470079
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510997679.0A Active CN105404581B (en) | 2015-12-25 | 2015-12-25 | A kind of evaluating method and device of database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105404581B (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106528388A (en) * | 2016-10-21 | 2017-03-22 | 网易（杭州）网络有限公司 | Database detection method and apparatus |
| CN108388503A (en) * | 2018-02-13 | 2018-08-10 | 中体彩科技发展有限公司 | Data-base performance monitoring method, system, equipment and computer readable storage medium |
| CN108874640A (en) * | 2018-05-07 | 2018-11-23 | 北京京东尚科信息技术有限公司 | A kind of appraisal procedure and device of clustering performance |
| CN109241096A (en) * | 2018-08-01 | 2019-01-18 | 北京京东金融科技控股有限公司 | Data processing method, device and system |
| CN109684309A (en) * | 2018-08-03 | 2019-04-26 | 全球能源互联网研究院有限公司 | A kind of quality of data evaluating method and device, computer equipment and storage medium |
| CN110008272A (en) * | 2019-04-10 | 2019-07-12 | 张绿儿 | The NoSQL database evaluating system and its construction method of facing sensing device data |
| WO2019153487A1 (en) * | 2018-02-07 | 2019-08-15 | 平安科技（深圳）有限公司 | System performance measurement method and device, storage medium and server |
| CN110716910A (en) * | 2019-10-14 | 2020-01-21 | 中国建设银行股份有限公司 | Log management method, device, equipment and storage medium |
| CN110750512A (en) * | 2019-09-09 | 2020-02-04 | 北京新数科技有限公司 | Database performance evaluation management method and device |
| CN111552637A (en) * | 2020-04-20 | 2020-08-18 | 北京顺达同行科技有限公司 | Database state detection method and device, electronic equipment and storage medium thereof |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1630677A1 (en) * | 2004-08-25 | 2006-03-01 | Ricoh Company, Ltd. | Maintenance mediation apparatus, maintenance target apparatus maintenance method, and maintenance system |
| CN101989283A (en) * | 2009-08-04 | 2011-03-23 | 中兴通讯股份有限公司 | Monitoring method and device of performance of database |
| CN103020132A (en) * | 2012-11-20 | 2013-04-03 | 北京奇虎科技有限公司 | Method and device for displaying detection result of database performance |
| CN103778050A (en) * | 2013-12-30 | 2014-05-07 | 国网山东省电力公司 | Database server high-availability performance detecting system |
| CN104462612A (en) * | 2015-01-05 | 2015-03-25 | 浪潮(北京)电子信息产业有限公司 | Method and device for monitoring database information |
| CN104639352A (en) * | 2013-11-12 | 2015-05-20 | 株式会社日立制作所 | Monitoring device and monitoring method |
-
2015
- 2015-12-25 CN CN201510997679.0A patent/CN105404581B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1630677A1 (en) * | 2004-08-25 | 2006-03-01 | Ricoh Company, Ltd. | Maintenance mediation apparatus, maintenance target apparatus maintenance method, and maintenance system |
| CN101989283A (en) * | 2009-08-04 | 2011-03-23 | 中兴通讯股份有限公司 | Monitoring method and device of performance of database |
| CN103020132A (en) * | 2012-11-20 | 2013-04-03 | 北京奇虎科技有限公司 | Method and device for displaying detection result of database performance |
| CN104639352A (en) * | 2013-11-12 | 2015-05-20 | 株式会社日立制作所 | Monitoring device and monitoring method |
| CN103778050A (en) * | 2013-12-30 | 2014-05-07 | 国网山东省电力公司 | Database server high-availability performance detecting system |
| CN104462612A (en) * | 2015-01-05 | 2015-03-25 | 浪潮(北京)电子信息产业有限公司 | Method and device for monitoring database information |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106528388A (en) * | 2016-10-21 | 2017-03-22 | 网易（杭州）网络有限公司 | Database detection method and apparatus |
| WO2019153487A1 (en) * | 2018-02-07 | 2019-08-15 | 平安科技（深圳）有限公司 | System performance measurement method and device, storage medium and server |
| CN108388503A (en) * | 2018-02-13 | 2018-08-10 | 中体彩科技发展有限公司 | Data-base performance monitoring method, system, equipment and computer readable storage medium |
| CN108874640A (en) * | 2018-05-07 | 2018-11-23 | 北京京东尚科信息技术有限公司 | A kind of appraisal procedure and device of clustering performance |
| CN109241096A (en) * | 2018-08-01 | 2019-01-18 | 北京京东金融科技控股有限公司 | Data processing method, device and system |
| CN109684309A (en) * | 2018-08-03 | 2019-04-26 | 全球能源互联网研究院有限公司 | A kind of quality of data evaluating method and device, computer equipment and storage medium |
| CN110008272A (en) * | 2019-04-10 | 2019-07-12 | 张绿儿 | The NoSQL database evaluating system and its construction method of facing sensing device data |
| CN110008272B (en) * | 2019-04-10 | 2020-01-31 | 张绿儿 | NoSQL database evaluation system for sensor data and construction method thereof |
| CN110750512A (en) * | 2019-09-09 | 2020-02-04 | 北京新数科技有限公司 | Database performance evaluation management method and device |
| CN110716910A (en) * | 2019-10-14 | 2020-01-21 | 中国建设银行股份有限公司 | Log management method, device, equipment and storage medium |
| CN110716910B (en) * | 2019-10-14 | 2022-10-14 | 中国建设银行股份有限公司 | Log management method, device, equipment and storage medium |
| CN111552637A (en) * | 2020-04-20 | 2020-08-18 | 北京顺达同行科技有限公司 | Database state detection method and device, electronic equipment and storage medium thereof |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105404581B (en) | 2019-03-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105404581A (en) | Database evaluation method and device | |
| US9471462B2 (en) | Proactive risk analysis and governance of upgrade process | |
| US7856575B2 (en) | Collaborative troubleshooting computer systems using fault tree analysis | |
| US10459780B2 (en) | Automatic application repair by network device agent | |
| US10771306B2 (en) | Log monitoring system | |
| US11157343B2 (en) | Systems and methods for real time computer fault evaluation | |
| CN105429826A (en) | Fault detection method and device for database cluster | |
| US10110419B2 (en) | Alarm to event tracing | |
| US20200379837A1 (en) | Automated recovery of webpage functionality | |
| CN108073499B (en) | Application program testing method and device | |
| CN110363381B (en) | Information processing method and device | |
| CN113626238B (en) | ctdb service health state monitoring method, system, device and storage medium | |
| US10713328B2 (en) | Automated tagging application for maintaining up-to-date web analytics | |
| CN111478792B (en) | Cutover information processing method, system and device | |
| CN112988439A (en) | Server fault discovery method and device, electronic equipment and storage medium | |
| US9594622B2 (en) | Contacting remote support (call home) and reporting a catastrophic event with supporting documentation | |
| CN108737184B (en) | Management method and device of disaster recovery system | |
| US10291700B2 (en) | Network optimized scan with dynamic fallback recovery | |
| CN114416560A (en) | Program crash analysis aggregation method and system | |
| CN115083030A (en) | Service inspection method and device and electronic equipment | |
| US10735246B2 (en) | Monitoring an object to prevent an occurrence of an issue | |
| CN113010375A (en) | Equipment alarm method and related equipment | |
| JP5679347B2 (en) | Failure detection device, failure detection method, and program | |
| CN111552703A (en) | Data processing method and device | |
| CN111444032A (en) | Computer system fault repairing method, system and equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20220719 Address after: Room 801, 8th floor, No. 104, floors 1-19, building 2, yard 6, Jiuxianqiao Road, Chaoyang District, Beijing 100015 Patentee after: BEIJING QIHOO TECHNOLOGY Co.,Ltd. Address before: Room 112, block D, No. 28, Xinjiekou outer street, Xicheng District, Beijing 100088 (Desheng Park) Patentee before: BEIJING QIHOO TECHNOLOGY Co.,Ltd. Patentee before: Qizhi software (Beijing) Co.,Ltd. |