CN105404581B - A kind of evaluating method and device of database - Google Patents
A kind of evaluating method and device of database Download PDFInfo
- Publication number
- CN105404581B CN105404581B CN201510997679.0A CN201510997679A CN105404581B CN 105404581 B CN105404581 B CN 105404581B CN 201510997679 A CN201510997679 A CN 201510997679A CN 105404581 B CN105404581 B CN 105404581B
- Authority
- CN
- China
- Prior art keywords
- performance
- database
- target database
- detection
- testing result
- 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.)
- Active
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
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Debugging And Monitoring (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention provides a kind of evaluating method of database and device, method therein is specifically included: receiving the evaluation and test instruction of user, wherein the evaluation and test instruction includes: the parameter of target database；Obtain the testing result that the evaluation and test instructs at least one performance of corresponding target database；According to the testing result of at least one of described performance, score the performance of the target database；And show the appraisal result of the target database.The embodiment of the present invention is just able to use the abnormal phenomenon that family finds database in time, therefore can alleviate the hysteresis quality problem that failure perceives in database maintenance as much as possible, so as to reduce failure scale and failure detecting period.
Description
Technical field
The present invention relates to field of computer technology, more particularly to the evaluating method and device of a kind of database.
Background technique
With the rapid development of computer and network technologies, data-base cluster is widely used in various fields, particularly for
Store mass data.In practical applications, data-base cluster usually faces the write-in or reading of mass data, this results in data
There are certain failure rates for library cluster, such as will appear memory abnormal, hardware fault, network failure etc..
In order to enable data-base cluster can operate normally, it will usually database administrator (DBA) this role is set,
DBA is responsible for the operation and maintenance of database, the groundworks such as installation, monitoring, fault detection, backup, recovery including database,
Can solve failure when breaking down in data-base cluster, the normal operation of data-base cluster is maintained.
However, for a long time, DBA is faced with always two problems, that is, information delay and failure when breaking down
The problem of reason location difficulty.That is, DBA generally can not be known at the first time when breaking down in data-base cluster,
Cause to inform DBA by applicating maintenance personnel, DBA is very passive at this time, Er Qie using after congestion often caused by failure
After failure, database is typically in stopping response or the extremely slow state of response, brings pole between processing to DBA
Big puzzlement and inconvenience.In emergency circumstances, DBA may have to select temporarily to restart database to restore to apply as early as possible.However,
After database is restarted, due to the missing of site environment, problem is difficult to reproduce, and cannot fundamentally solve to exist in data-base cluster
The problem of.
Summary of the invention
In view of the above problems, it proposes on the present invention overcomes the above problem or at least be partially solved in order to provide one kind
State the evaluating method and device of a kind of database of problem.
According to one aspect of the present invention, a kind of evaluating method of database is provided, comprising:
Receive the evaluation and test instruction of user, wherein the evaluation and test instruction includes: the parameter of target database；
Obtain the testing result that the evaluation and test instructs at least one performance of corresponding target database；
According to the testing result of at least one of described performance, score the performance of the target database；And
Show the appraisal result of the target database.
Optionally, the acquisition evaluation and test instructs the testing result of at least one performance of corresponding target database
Step further comprises:
Corresponding target database is instructed to carry out performance detection the evaluation and test, to obtain at least one of corresponding performance
Testing result；And/or
The testing result of at least one performance of the target database is obtained from pre-stored performance detection record.
Optionally, the testing result includes at least one of following:
Network performance testing result, hardware performance testing result and database performance testing result.
Optionally, the testing result of at least one performance described in the foundation carries out the performance of the target database
The step of scoring, further comprises:
When the testing result meets preset deduction rule, evaluation and test total score corresponding to the target database is subtracted
The regular corresponding score of the deduction, to obtain final appraisal result.
Optionally, the method also includes:
When the testing result meets preset severely subnormal condition, send a warning message；
Wherein, the preset severely subnormal condition includes at least one of following condition:
Primary database suspension in the target database；
The target database corresponds to server delay machine where primary database；
The target database corresponds to the service stopping operation of primary database.
Optionally, the step of appraisal result for showing the target database further comprises:
During instructing corresponding target database to carry out performance detection the evaluation and test, display is currently being detected
Performance title and the performance description information；And/or
During instructing corresponding target database to carry out performance detection the evaluation and test, display detection progress bar with
And current scoring；And/or
During instructing corresponding target database to carry out performance detection the evaluation and test, display terminates control, when
It is terminated when the termination control is triggered and the performance of target database is detected.
Optionally, it is instructing corresponding target database execution performance to detect the evaluation and test, is obtaining at least one performance
Testing result after, the method also includes:
The testing result is saved to performance detection and is recorded.
Optionally, it the described the step of detection of corresponding target database execution performance is instructed to the evaluation and test, further wraps
It includes:
According to the detection parameters that user inputs, detection parameters described in the target database correspondence database cluster are determined
Corresponding destination server；
By destination server described in Telnet, network performance detection and/or hardware are executed to the destination server
Performance detection.
Optionally, it the described the step of detection of corresponding target database execution performance is instructed to the evaluation and test, further wraps
It includes:
Receive the test object parameter and detection project parameter of user's input；
According to the test object parameter, determine that test object described in the target database correspondence database cluster is joined
The corresponding destination server of number；
After destination server described in Telnet, the corresponding database performance detection of the detection project parameter is executed.
Another aspect according to the present invention provides a kind of evaluating apparatus of database, comprising:
Command reception module, the evaluation and test for receiving user instruct, wherein the evaluation and test instruction includes: target database
Parameter；
As a result module is obtained, the detection for instructing at least one performance of corresponding target database for obtaining the evaluation and test
As a result；
Performance Score module, for the testing result according at least one of described performance, to the property of the target database
It can be carried out scoring；And
As a result display module, for showing the appraisal result of the target database.
Optionally, the result obtains module, further comprises:
Online acquisition submodule, for instructing corresponding target database to carry out performance detection the evaluation and test, to obtain
The testing result of at least one of corresponding performance；And/or
Offline acquisition submodule, for obtaining the target database at least from pre-stored performance detection record
The testing result of one performance.
Optionally, the testing result includes at least one of following:
Network performance testing result, hardware performance testing result and database performance testing result.
Optionally, the Performance Score module further comprises:
Performance Score submodule, for when the testing result meets preset deduction rule, to the target data
The corresponding evaluation and test total score in library subtracts the corresponding score of the deduction rule, to obtain final appraisal result.
Optionally, described device further include:
Alarm module, for sending a warning message when the testing result meets preset severely subnormal condition；
Wherein, the preset severely subnormal condition includes at least one of following condition:
Primary database suspension in the target database；
The target database corresponds to server delay machine where primary database；
The target database corresponds to the service stopping operation of primary database.
Optionally, the result display module further comprises:
First shows submodule, in the process for instructing corresponding target database progress performance detection to the evaluation and test
In, the description information of performance title and the performance that display is currently detecting；And/or
Second shows submodule, in the process for instructing corresponding target database progress performance detection to the evaluation and test
In, display detection progress bar and current scoring；And/or
Third shows submodule, in the process for instructing corresponding target database progress performance detection to the evaluation and test
In, display terminates control, terminates when the termination control is triggered and detects to the performance of target database.
Optionally, described device further include:
Preserving module being recorded, being recorded for saving the testing result to performance detection.
Optionally, the online acquisition submodule further comprises:
First determination unit, the detection parameters for being inputted according to user determine the target database correspondence database
The corresponding destination server of detection parameters described in cluster；
First detection unit, for executing network to the destination server by destination server described in Telnet
Performance detection and/or hardware performance detection.
Optionally, the online acquisition submodule further comprises:
Parameter receiving unit, for receiving the test object parameter and detection project parameter of user's input；
Second determination unit, for determining the target database correspondence database collection according to the test object parameter
The corresponding destination server of test object parameter described in group；
Second detection unit, it is corresponding for after destination server described in Telnet, executing the detection project parameter
Database performance detection.
The evaluating method and device of a kind of database according to an embodiment of the present invention are instructed according to the evaluation and test received, are obtained
The testing result of at least one performance of target database, and the testing result according at least one of described performance are taken, to institute
The performance for stating target database scores, and shows the appraisal result of the target database；Since the appraisal result can
To reflect the health status of target database, for example, being indicated at the target database when the appraisal result is higher than scoring threshold value
Indicate that the target database is in abnormality in normal condition, or when the appraisal result is lower than scoring threshold value, therefore, this
Inventive embodiments are able to use the health status that destination server is learnt at family in time；In this way, being slightly lower than in the appraisal result
When the threshold value that scores, the embodiment of the present invention is just able to use the abnormal phenomenon that family finds database in time, therefore can be as much as possible
Alleviate the hysteresis quality problem of failure perception in database maintenance, so as to reduce failure scale and failure detecting period.
The above description is only an overview of the technical scheme of the present invention, in order to better understand the technical means of the present invention,
And it can be implemented in accordance with the contents of the specification, and in order to allow above and other objects of the present invention, feature and advantage can
It is clearer and more comprehensible, the followings are specific embodiments of the present invention.
Detailed description of the invention
By reading the detailed description of hereafter optional embodiment, various other advantages and benefits are common for this field
Technical staff will become clear.Attached drawing is only used for showing the purpose of optional embodiment, and is not considered as to the present invention
Limitation.And throughout the drawings, the same reference numbers will be used to refer to the same parts.In the accompanying drawings:
Fig. 1 shows a kind of step flow diagram of the evaluating method of database according to an embodiment of the invention；
Fig. 2 shows a kind of step flow diagrams of the evaluating method of database according to an embodiment of the invention；
Fig. 3 shows a kind of step flow diagram of the evaluating method of database according to an embodiment of the invention；
Fig. 4 shows a kind of step flow diagram of the evaluating method of database according to an embodiment of the invention；
Fig. 5 shows a kind of step flow diagram of the evaluating method of database according to an embodiment of the invention；
And
Fig. 6 shows a kind of structural block diagram of the evaluating apparatus of database according to an embodiment of the invention.
Specific embodiment
Exemplary embodiments of the present disclosure are described in more detail below with reference to accompanying drawings.Although showing the disclosure in attached drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here
It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure
It is fully disclosed to those skilled in the art.
Referring to Fig.1, the step process for showing a kind of evaluating method of database according to an embodiment of the invention is shown
It is intended to, can specifically include following steps:
Step 101, the evaluation and test instruction for receiving user, wherein the evaluation and test instruction can specifically include: target database
Parameter；
Step 102 obtains the testing result that the evaluation and test instructs at least one performance of corresponding target database；
The testing result of step 103, at least one performance according to described in, comments the performance of the target database
Point；And
Step 104, the appraisal result for showing the target database.
The one of the inventive concepts of the embodiment of the present invention are that evaluation and test instructs based on the received, at least to target database
One performance scores, and shows appraisal result.Specifically, in available data-base cluster each server it is network-like
The data informations such as state, hardware state and database operating status, so as to from network performance, hardware performance and data
Library performance etc. carries out performance evaluating to target database, to obtain the health status of target database.The embodiment of the present invention
The first purpose be existing database failure being transferred to active precautionary approach from passive processing mode, fundamentally effectively drop
Low failure perception and processing time.
The embodiment of the present invention is applicable to the evaluation and test of any type of database, wherein the database may include
Database of types such as ORACLE (inscriptions on bones or tortoise shells), DB2, MySQL etc., it will be understood that tool of the embodiment of the present invention for database
Body type is without restriction.For ease of description, the embodiment of the present invention is described by taking MySQL database as an example, other classes
The database of type is cross-referenced.
The embodiment of the present invention may operate at the management server side in data-base cluster, and the management server can be used for pipe
The server in data-base cluster is managed, and executes corresponding performance detection according to the present situation of each server managed.Pipe
It can store preset management configuration file in reason server, may include each in data-base cluster in the management configuration file
The information of server, for example, server where primary database in data-base cluster, from server, agency service where database
Device, information of load-balanced server etc..
In practical applications, can specifically include in data-base cluster master's (Master) database and it is multiple from
(Slave) database.Certainly, in practical applications, those skilled in the art can according to need the data for building different frameworks
Library cluster, such as the read and write abruption in order to realize database can also be provided with agency (Proxy) service in data-base cluster
Device, and may be provided for increasing handling capacity, load-balanced server of Strengthens network data-handling capacity etc., always
It, the embodiment of the present invention is without restriction for the concrete type of database and the specific framework of data-base cluster.
In practical applications, the database can be adapted in arbitrary operating system environment, such as Linux operation system
System, Windows operating system etc., the specific operating system environment that the embodiment of the present invention is suitable for database are not limited
System, for ease of description, the embodiment of the present invention is described by taking the database under (SuSE) Linux OS environment as an example, other
Operating system is cross-referenced.
In an alternative embodiment of the invention, the testing result at least may include at least one in following result
Kind: network performance testing result, hardware performance testing result and database performance testing result.
The embodiment of the present invention can evaluate and test database, and obtain corresponding appraisal result, the appraisal result
It can be the appraisal result to above-mentioned one of testing result, be also possible to obtain a variety of testing results progress comprehensive evaluating
Appraisal result, specifically, the network state of each server, hardware shape in the available data-base cluster of the embodiment of the present invention
The data informations such as state and database operating status, from many aspects pair such as network performance, hardware performance and database performances
Current database carries out comprehensive evaluating, and to obtain final appraisal result, which can comprehensively, objectively reflect currently
The problem of database, so that DBA can optimize database, compared with the existing technology after failure,
The insoluble problem of failure, the embodiment of the present invention can before failure generation, the problem of detecting database hidden danger,
And then it can prevent trouble before it happens to avoid the generation of failure.
It in embodiments of the present invention, can be by showing UI (User Interface, user interface) to user, to use
Family can issue the parameter of evaluation and test instruction and input target database.In an alternative embodiment of the invention, the mesh
The parameter of mark database can specifically include: port numbers.It is appreciated that specific shape of the present invention for the parameter of target database
Formula is without restriction, and the parameter of above-mentioned target database can also include IP (Internet Protocol, Internet protocol
Location) address or IP address and the combination of port numbers etc..In a kind of application example of the invention, user is inputted by UI
Port numbers 3717, and button is evaluated and tested in click data library, then can be issued for the corresponding target database of port numbers 3717
Evaluation and test instruction.
In an alternative embodiment of the invention, described to obtain the corresponding target database of the evaluation and test instruction at least
It the step of testing result of one performance, can further include:
Corresponding target database is instructed to carry out performance detection the evaluation and test, to obtain at least one of corresponding performance
Testing result；And/or
The testing result of at least one performance of the target database is obtained from pre-stored performance detection record.
In embodiments of the present invention, for obtaining described at least one performance for evaluating and testing the corresponding target database of instruction
The concrete mode of testing result is without restriction, and corresponding detection can be obtained by way of on-line checking or offline search
As a result.Wherein, on-line checking mode refers specifically to, and after receiving evaluation and test instruction from the user, executes to target database
Line performance detection, to obtain the testing result of at least one of corresponding performance；Offline search mode refers specifically to, preparatory by inquiring
The performance detection of storage records to obtain the testing result of at least one performance of target database.
In an alternative embodiment of the invention, the method can also include: corresponding to evaluation and test instruction
The detection of target database execution performance, after obtaining the testing result of at least one performance, the testing result is saved to property
It can detection record.It is detected and is recorded by retention, so that in the evaluation and test of subsequent execution database, it can be by offline search side
Formula directly acquires the testing result of at least one performance of target database, such as can inquire to obtain the last guarantor in 3 days
The testing result of at least one performance for the target database deposited, and evaluation and test marking is carried out with this, so as to save online inspection
Detection time needed for survey mode, to improve evaluation and test speed.Optionally, the embodiment of the present invention can be set periodically automatically to data
Library carries out performance detection, and saves detection record, different present in database so as to find early so that DBA is checked
Regular data takes preventive measures in advance before failure appearance, avoids unnecessary loss.
In an alternative embodiment of the invention, the step of appraisal result for showing the target database, into
One step may include:
During instructing corresponding target database to carry out performance detection the evaluation and test, display is currently being detected
Performance title and the performance description information；And/or
During instructing corresponding target database to carry out performance detection the evaluation and test, display detection progress bar with
And current scoring；And/or
During instructing corresponding target database to carry out performance detection the evaluation and test, display terminates control, when
It is terminated when the termination control is triggered and the performance of target database is detected.
In embodiments of the present invention, by showing the description information of the performance title and the performance that are currently detecting,
And/or display detection progress bar and current scoring, allow user understand in real time database performance detection progress and
Detection case, to improve user experience；In addition, by increase control, such as reality interface increase preset button so that with
Family can terminate the performance detection operation being currently executing when clicking the preset button, to increase the controllable of test process
Property.
In an alternative embodiment of the invention, the appraisal result can shown into boundary by pre-set page mode
Showed in face, to facilitate user to check.Specifically, the UI such as journal file, table, chart can be used in pre-set page side
Formula shows appraisal result, so that appraisal result can more intuitively be presented to user.It is appreciated that the embodiment of the present invention for
The concrete form of pre-set page is without restriction.
To sum up, the embodiment of the present invention is instructed according to the evaluation and test received, obtains at least one performance of target database
Testing result, and the testing result according at least one of described performance, score to the performance of the target database, with
And show the appraisal result of the target database；Since the appraisal result can reflect the health status of target database, example
Such as, indicate that the target database is in normal condition when the appraisal result is higher than scoring threshold value, or low in the appraisal result
In score threshold value when indicate that the target database is in abnormality, therefore, the embodiment of the present invention is able to use family in time
Know the health status of destination server；In this way, the embodiment of the present invention can when the appraisal result slightly lower than scores threshold value
So that user is found the abnormal phenomenon of database in time, therefore the lag that failure perceives in database maintenance can be alleviated as much as possible
Property problem, so as to reduce failure scale and failure detecting period.
Referring to Fig. 2, the step process for showing a kind of evaluating method of database according to an embodiment of the invention is shown
It is intended to, can specifically include following steps:
Step 201, the evaluation and test instruction for receiving user, wherein the evaluation and test instruction can specifically include: target database
Parameter；
Step 202 obtains the testing result that the evaluation and test instructs at least one performance of corresponding target database；
Step 203, when the testing result meets preset deduction rule, evaluation and test corresponding to the target database
Total score subtracts the corresponding score of the deduction rule, to obtain final appraisal result；And
Step 204, the appraisal result for showing the target database.
It, can be according to preset deduction rule, to the target data on the basis of the present embodiment embodiment shown in Fig. 2
The performance in library scores.In practical applications, when evaluating and testing to database, it is full that initial evaluation and test total score, which can be set,
Divide such as 100 points, when the testing result of at least one performance to acquisition scores, if the wherein detection knot of a certain performance
Fruit meets preset deduction rule, then can subtract corresponding score, from 100 points to obtain final appraisal result.
It, can be by when the testing result to multinomial performance carries out comprehensive evaluating in a kind of application example of the invention
The corresponding score of the testing result of pro rate properties, for example, for network performance testing result, hardware performance detection knot
The testing result of this three performances of fruit and database performance testing result carries out evaluation and test score, can preset wherein network
Performance accounts for 30 points, and hardware performance accounts for 30 points, and database performance accounts for 40 points, carries out evaluation and test marking in the testing result to properties
When, if meeting preset deduction rule, corresponding score is subtracted from 100 points, to obtain final appraisal result, the scoring
As a result more serious the problem of lower database of descriptions.For example, being learnt by network performance testing result from database institute
It breaks down in the connectivity of server, 5 points can be subtracted；Learn that CPU usage is more than pre- by hardware performance testing result
Gating limit, can subtract 20 points；Learn that slow inquiry duration, can be with beyond preset time range by database performance testing result
Subtract 10 points；Obtaining final appraisal result is 65 points.When the final appraisal result is presented to user, can also to
Family shows performance title, the description information of the performance and the corresponding deduction situation of the performance etc. of detection, with intuitive to user
The problem of evaluation result and database in ground display data library.
In another kind application example of the invention, can also according to testing result in abnormal seriousness to target data
Library carries out evaluation and test marking, for example, the database performance testing result by obtaining is led it is known that in the target database
The service of database is out of service, then the exception belongs to severely subnormal, has influenced the use of database basic function,
Therefore, appraisal result directly can be kept to 0 point, and gives a warning notice.
It is only answered as one kind of the invention it is appreciated that carrying out evaluation and test marking to target database above by deduction rule
With example, the embodiment of the present invention is without restriction for rule of specifically giving a mark, such as will can also initially evaluate and test total score setting
It is 0 point, evaluation and test marking is carried out to target database by bonus point rule, the final appraisal result the high, deposits in database of descriptions
The problem of it is more serious.
In an alternative embodiment of the invention, DBA can be according to the appraisal result of the target database showed, to mesh
The problems in mark database is analyzed, to solve the problems, such as and be optimized to database, such as it can be found that data base set
The unreasonable place of group's framework, so as to be optimized to database aggregated structure.In a kind of application example of the invention,
By the database performance testing result of acquisition it is known that including a large amount of slow queried access record in the testing result, and
Slow inquiry duration exceeds preset time range, it may be considered that current business does not fit through Proxy access database, it should right
Data-base cluster framework is adjusted, and is adjusted to the framework that client directly accesses to database, to improve business processing
Efficiency.
Referring to Fig. 3, the step process for showing a kind of evaluating method of database according to an embodiment of the invention is shown
It is intended to, can specifically include following steps:
Step 301, the evaluation and test instruction for receiving user, wherein the evaluation and test instruction can specifically include: target database
Parameter；
Step 302 obtains the testing result that the evaluation and test instructs at least one performance of corresponding target database；
The testing result of step 303, at least one performance according to described in, comments the performance of the target database
Point；
Step 304, the appraisal result for showing the target database；
Step 305, when the testing result meets preset severely subnormal condition, send a warning message；Wherein, described pre-
Setting severely subnormal condition includes at least one of following condition: the primary database suspension in the target database；The mesh
Mark database corresponds to server delay machine where primary database；The target database corresponds to the service stopping operation of primary database.
On the basis of the present embodiment embodiment shown in Fig. 2, preset severely subnormal condition can also be met in testing result
When, warning message is issued the user with, to remind customer data base severely subnormal occur.It is understood that the embodiment of the present invention for step
Rapid 305 execution opportunity does not limit, for example, it is preset serious different can to find that the testing result meets when executing step 302
Normal condition can be sent a warning message, alternatively, can also be after evaluating and testing marking, then send a warning message.
In an alternative embodiment of the invention, corresponding target database is being instructed to carry out performance inspection the evaluation and test
It surveys, during obtaining the testing result of at least one of corresponding performance, iting is found that it is preset serious that the testing result meets
When exceptional condition, warning message can be issued the user with.It, can also be by current performance in another alternative embodiment of the invention
Testing result and pre-stored performance detection record in testing result be compared, to determine the operating status of database
Trend, and severely subnormal whether there is according to the operating status trend evaluation database of database.
Wherein, preset severely subnormal condition can be used for indicating occurring severely subnormal in database, so that influencing database
Normal use any adjusting.For example, the service of server delay machine, primary database where primary database suspension, primary database
It is out of service etc..It is appreciated that above-mentioned preset severely subnormal condition only a kind of applies example, present invention implementation as of the invention
Example is without restriction for the particular content of preset severely subnormal condition, for example, can also include: database free memory it is super
Cross preset thresholding etc..
To sum up, the embodiment of the present invention is evaluated and tested to target database, obtains the target database at least one
The testing result of performance, and according to the testing result of at least one of described performance, the performance of the target database is carried out
Scoring while to obtain corresponding appraisal result, can also be sent out when the testing result meets preset severely subnormal condition
Warning message out.Through the embodiment of the present invention, it can be prompted the user in database during being evaluated and tested to database
Existing severely subnormal, with the trend for finding and preventing database further to deteriorate extremely in time.
Referring to Fig. 4, the step process for showing a kind of evaluating method of database according to an embodiment of the invention is shown
It is intended to, can specifically include following steps:
Step 401, the evaluation and test instruction for receiving user, wherein the evaluation and test instruction can specifically include: target database
Parameter；
Step 402, the detection parameters inputted according to user, determine described in the target database correspondence database cluster
The corresponding destination server of detection parameters；
Step 403 passes through destination server described in Telnet, executes network performance detection to the destination server
And/or hardware performance detection, to obtain the testing result of at least one of corresponding performance；
The testing result of step 404, at least one performance according to described in, comments the performance of the target database
Point；
Step 405, the appraisal result for showing the target database.
It, can be to target after the evaluation and test instruction for receiving user on the basis of the present embodiment embodiment shown in Fig. 2
Database executes network performance detection and/or hardware performance detection, to obtain the testing result of at least one of corresponding performance.
Specifically, it can be provided with performance detection module, in the management server to execute data in the embodiment of the present invention
The performance detection process in library.Wherein, the performance detection module can run preset python script, to provide a user inspection
Survey the input interface of parameter；Also, the detection parameters that can also be inputted according to user obtain the corresponding detection column of the detection parameters
Table, then by each destination server in detection list described in Telnet, each destination server execution performance is detected,
To obtain testing result.Wherein, the destination server may include server where primary database, the clothes where database
Business device and proxy server etc..
Wherein, the performance detection can specifically include network performance detection and hardware performance detection.To destination service
When device executes network performance detection, the Telnet of python script can be executed by the performance detection module in management server
Destination server can be by executing network sense command, to the net of destination server after Telnet destination server
Network state is detected, and detects corresponding testing result to obtain network performance.
In order to execute hardware performance detection to destination server, hardware detection mould can be set in the destination server
Block detects corresponding testing result, such as the benefit of CPU for collecting the hardware state of destination server to obtain hardware performance
It whether is more than preset thresholding etc. with rate.Wherein, the function that the hardware detecting module collects the hardware state of destination server can
To be realized by shell script.Specifically, python script can be executed by the performance detection module in management server
Telnet destination server calls the hardware detecting module by python script after Telnet destination server,
So that the hardware detecting module executes the hardware state of shell script collection destination server, and connect by python script
It receives the hardware performance that shell script returns and detects corresponding testing result, to complete the inspection to the hardware performance of destination server
It surveys.
To sum up, through the embodiment of the present invention, the available evaluation and test received instructs corresponding target database at least
The testing result of one performance, wherein the testing result includes that network performance detection and/or hardware performance detect corresponding inspection
Survey result.The embodiment of the present invention can score to database according to the network performance and/or hardware performance of database, and open up
The appraisal result of the existing target database.So that the embodiment of the present invention can integrate database according to many factors
Evaluation and test, obtains more accurate, considerable scoring, and can provide for user and solve the problems, such as database and optimization
The foundation of data.
Referring to Fig. 5, the step process for showing a kind of evaluating method of database according to an embodiment of the invention is shown
It is intended to, can specifically include following steps:
Step 501, the evaluation and test instruction for receiving user, wherein the evaluation and test instruction can specifically include: target database
Parameter；
Step 502, the test object parameter and detection project parameter for receiving user's input；
Step 503, according to the test object parameter, determine inspection described in the target database correspondence database cluster
Survey the corresponding destination server of image parameter；
Step 504, after destination server described in Telnet, execute the corresponding database of the detection project parameter
It can detect, to obtain the testing result of at least one of corresponding performance；
The testing result of step 505, at least one performance according to described in, comments the performance of the target database
Point；
Step 506, the appraisal result for showing the target database.
It, can be to target after the evaluation and test instruction for receiving user on the basis of the present embodiment embodiment shown in Fig. 2
Database executes database performance detection, to obtain the testing result of at least one of corresponding performance.
Specifically, it can be provided with performance detection module, in the management server to execute data in the embodiment of the present invention
The performance detection process in library.Wherein, the performance detection module can run preset python script, to provide a user inspection
Survey the input interface of image parameter and detection project parameter；Also, the test object parameter that can also be inputted according to user, obtains
The corresponding detection list of the test object parameter, then by each destination server in detection list described in Telnet, hold
The corresponding database performance detection of the row detection project parameter, to obtain the testing result of at least one of corresponding performance.Its
In, the destination server may include server where primary database, from server where database and proxy server
Deng.The type of the detection project parameter can specifically include: detection of connectivity, agency (Proxy) detection and database inspection
At least one of survey.Wherein, detection of connectivity is for detecting whether user account can normally connect database；Proxy inspection
It surveys whether normal for detecting the state for accessing database by proxy server；And database detection is used for Test database
Operating status it is whether normal, such as the memory service condition of database, if there is slow inquiry etc..
In a kind of application example of the invention, if including illegal in nearest 1 hour in obtained testing result
User access information, and multiple unauthorized users to access information be it is identical, then illustrate that the access authority of the user account may be set
Mistake is set, then can check the access authority of the user account with notification data library manager.Show in another application of the invention
In example, if including that largely inquiry duration is more than that the slow queried access of preset time range records slowly in the testing result,
It is considered that current business does not fit through Proxy access database, it should it is adjusted to the mode directly accessed database, with
Improve business processing efficiency.
Can detecte item argument corresponding database performance detection through the embodiment of the present invention, with obtain it is corresponding at least
The testing result of one performance, and the testing result according at least one of described performance, to the performance of the target database
It scores.So that the embodiment of the present invention can carry out comprehensive evaluating to database according to many factors, obtain it is more accurate,
Considerable scoring, and the foundation for solving the problems, such as database and optimizing data can be provided for user.
In a kind of application example of the invention, it can be provided with evaluation and test module in the management server, for receiving simultaneously
Execute evaluation and test instruction from the user；Wherein, the evaluation and test instruction can specifically include: the parameter of target database.The evaluation and test
Module can evaluate and test target database by running preset python script.Specifically, it is possible, firstly, to by examining online
It surveys or the mode of offline search obtains the testing result that the evaluation and test instructs at least one performance of corresponding target database.
For example, can by instructing corresponding target database to carry out performance detection the evaluation and test online, with obtain it is corresponding at least
The testing result of one performance；Alternatively, can from pre-stored performance detection record in obtain the target database to
The testing result of one item missing performance.Wherein, the testing result at least may include one of following: network performance detection knot
Fruit, hardware performance testing result and database performance testing result.Then, the detection knot according at least one of described performance
Fruit scores to the performance of the target database；For example, when the testing result meets preset deduction rule, it is right
The corresponding evaluation and test total score of the target database subtracts the corresponding score of the deduction rule, to obtain final appraisal result；
Finally, showing the appraisal result of the target database.
Referring to Fig. 6, a kind of structural block diagram of the evaluating apparatus of database according to an embodiment of the invention is shown, is had
Body may include following module:
Command reception module 610, the evaluation and test for receiving user instruct, wherein the evaluation and test instruction can specifically include:
The parameter of target database；
As a result module 620 is obtained, for obtaining described at least one performance for evaluating and testing the corresponding target database of instruction
Testing result；
Performance Score module 630, for the testing result according at least one of described performance, to the target database
Performance scores；And
As a result display module 640, for showing the appraisal result of the target database.
In an alternative embodiment of the invention, the result obtains module 620, can further include:
Online acquisition submodule, for instructing corresponding target database to carry out performance detection the evaluation and test, to obtain
The testing result of at least one of corresponding performance；And/or
Offline acquisition submodule, for obtaining the target database at least from pre-stored performance detection record
The testing result of one performance.
In another alternative embodiment of the invention, the testing result at least may include one of following:
Network performance testing result, hardware performance testing result and database performance testing result.
In another preferred embodiment of the invention, the Performance Score module 630 be can further include:
Performance Score submodule, for when the testing result meets preset deduction rule, to the target data
The corresponding evaluation and test total score in library subtracts the corresponding score of the deduction rule, to obtain final appraisal result.
In still another preferable embodiment of the invention, described device can also include:
Alarm module, for sending a warning message when the testing result meets preset severely subnormal condition；
Wherein, the preset severely subnormal condition may include at least one of following condition:
Primary database suspension in the target database；
The target database corresponds to server delay machine where primary database；
The target database corresponds to the service stopping operation of primary database.
In still another preferable embodiment of the invention, the result display module 640 be can further include:
First shows submodule, in the process for instructing corresponding target database progress performance detection to the evaluation and test
In, the description information of performance title and the performance that display is currently detecting；And/or
Second shows submodule, in the process for instructing corresponding target database progress performance detection to the evaluation and test
In, display detection progress bar and current scoring；And/or
Third shows submodule, in the process for instructing corresponding target database progress performance detection to the evaluation and test
In, display terminates control, terminates when the termination control is triggered and detects to the performance of target database.
In still another preferable embodiment of the invention, described device can also include:
Preserving module being recorded, being recorded for saving the testing result to performance detection.
In still another preferable embodiment of the invention, the online acquisition submodule be can further include:
First determination unit, the detection parameters for being inputted according to user determine the target database correspondence database
The corresponding destination server of detection parameters described in cluster；
First detection unit, for executing network to the destination server by destination server described in Telnet
Performance detection and/or hardware performance detection.
In still another preferable embodiment of the invention, the online acquisition submodule be can further include:
Parameter receiving unit, for receiving the test object parameter and detection project parameter of user's input；
Second determination unit, for determining the target database correspondence database collection according to the test object parameter
The corresponding destination server of test object parameter described in group；
Second detection unit, it is corresponding for after destination server described in Telnet, executing the detection project parameter
Database performance detection.
For device embodiment, since it is basically similar to the method embodiment, related so being described relatively simple
Place illustrates referring to the part of embodiment of the method.
Algorithm and display are not inherently related to any particular computer, virtual system, or other device provided herein.
Various general-purpose systems can also be used together with teachings based herein.As described above, it constructs required by this kind of system
Structure be obvious.In addition, the present invention is also not directed to any particular programming language.It should be understood that can use various
Programming language realizes summary of the invention described herein, and the description done above to language-specific is to disclose this hair
Bright preferred forms.
In the instructions provided here, numerous specific details are set forth.It is to be appreciated, however, that implementation of the invention
Example can be practiced without these specific details.In some instances, well known method, structure is not been shown in detail
And technology, so as not to obscure the understanding of this specification.
Similarly, it should be understood that in order to simplify the disclosure and help to understand one or more of the various inventive aspects,
Above in the description of exemplary embodiment of the present invention, each feature of the invention is grouped together into single implementation sometimes
In example, figure or descriptions thereof.However, the disclosed method should not be interpreted as reflecting the following intention: i.e. required to protect
Shield the present invention claims features more more than feature expressly recited in each claim.More precisely, as following
Claims reflect as, inventive aspect is all features less than single embodiment disclosed above.Therefore,
Thus the claims for following specific embodiment are expressly incorporated in the specific embodiment, wherein each claim itself
All as a separate embodiment of the present invention.
Those skilled in the art will understand that can be carried out adaptively to the module in the equipment in embodiment
Change and they are arranged in one or more devices different from this embodiment.It can be the module or list in embodiment
Member or component are combined into a module or unit or component, and furthermore they can be divided into multiple submodule or subelement or
Sub-component.Other than such feature and/or at least some of process or unit exclude each other, it can use any
Combination is to all features disclosed in this specification (including adjoint claim, abstract and attached drawing) and so disclosed
All process or units of what method or apparatus are combined.Unless expressly stated otherwise, this specification is (including adjoint power
Benefit require, abstract and attached drawing) disclosed in each feature can carry out generation with an alternative feature that provides the same, equivalent, or similar purpose
It replaces.
In addition, it will be appreciated by those of skill in the art that although some embodiments described herein include other embodiments
In included certain features rather than other feature, but the combination of the feature of different embodiments mean it is of the invention
Within the scope of and form different embodiments.For example, in the following claims, embodiment claimed is appointed
Meaning one of can in any combination mode come using.
Various component embodiments of the invention can be implemented in hardware, or to run on one or more processors
Software module realize, or be implemented in a combination thereof.It will be understood by those of skill in the art that can be used in practice
Microprocessor or digital signal processor (DSP) realize the evaluating method and device of database according to an embodiment of the present invention
In some or all components some or all functions.The present invention is also implemented as described herein for executing
Some or all device or device programs (for example, computer program and computer program product) of method.In this way
Realization program of the invention can store on a computer-readable medium, or can have the shape of one or more signal
Formula.Such signal can be downloaded from Internet platform and be obtained, and be perhaps provided on the carrier signal or with any other shape
Formula provides.
It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and ability
Field technique personnel can be designed alternative embodiment without departing from the scope of the appended claims.In the claims,
Any reference symbol between parentheses should not be configured to limitations on claims.Word "comprising" or " comprising " are not arranged
Except there are element or steps not listed in the claims.Word "a" or "an" located in front of the element does not exclude the presence of more
A such element.The present invention can be by means of including the hardware of several different elements and by means of properly programmed calculating
Machine is realized.In the unit claims listing several devices, several in these devices can be by same
Hardware branch embodies.The use of word first, second, and third does not indicate any sequence.It can be by these word solutions
It is interpreted as title.
The invention discloses A1, a kind of evaluating method of database, comprising:
Receive the evaluation and test instruction of user, wherein the evaluation and test instruction includes: the parameter of target database；
Obtain the testing result that the evaluation and test instructs at least one performance of corresponding target database；
According to the testing result of at least one of described performance, score the performance of the target database；And
Show the appraisal result of the target database.
A2, the method as described in claim A1, it is described to obtain the corresponding target database of the evaluation and test instruction at least
The step of testing result of one performance, further comprise:
Corresponding target database is instructed to carry out performance detection the evaluation and test, to obtain at least one of corresponding performance
Testing result；And/or
The testing result of at least one performance of the target database is obtained from pre-stored performance detection record.
A3, the method as described in claim A1, the testing result include at least one of following:
Network performance testing result, hardware performance testing result and database performance testing result.
A4, the method as described in claim A1, the testing result of performance at least one of described in the foundation, to the mesh
The step of performance of mark database is scored further comprises:
When the testing result meets preset deduction rule, evaluation and test total score corresponding to the target database is subtracted
The regular corresponding score of the deduction, to obtain final appraisal result.
A5, the method as described in claim A1, the method also includes:
When the testing result meets preset severely subnormal condition, send a warning message；
Wherein, the preset severely subnormal condition includes at least one of following condition:
Primary database suspension in the target database；
The target database corresponds to server delay machine where primary database；
The target database corresponds to the service stopping operation of primary database.
The step of A6, the method as described in claim A2, the appraisal result for showing the target database, into one
Step includes:
During instructing corresponding target database to carry out performance detection the evaluation and test, display is currently being detected
Performance title and the performance description information；And/or
During instructing corresponding target database to carry out performance detection the evaluation and test, display detection progress bar with
And current scoring；And/or
During instructing corresponding target database to carry out performance detection the evaluation and test, display terminates control, when
It is terminated when the termination control is triggered and the performance of target database is detected.
A7, the method as described in claim A2 are instructing corresponding target database execution performance to examine the evaluation and test
It surveys, after obtaining the testing result of at least one performance, the method also includes:
The testing result is saved to performance detection and is recorded.
A8, the method as described in claim A2, it is described that corresponding target database execution performance is instructed to the evaluation and test
The step of detection, further comprises:
According to the detection parameters that user inputs, detection parameters described in the target database correspondence database cluster are determined
Corresponding destination server；
By destination server described in Telnet, network performance detection and/or hardware are executed to the destination server
Performance detection.
A9, the method as described in claim A2, it is described that corresponding target database execution performance is instructed to the evaluation and test
The step of detection, further comprises:
Receive the test object parameter and detection project parameter of user's input；
According to the test object parameter, determine that test object described in the target database correspondence database cluster is joined
The corresponding destination server of number；
After destination server described in Telnet, the corresponding database performance detection of the detection project parameter is executed.
The invention discloses B10, a kind of performance evaluating apparatus of data-base cluster, comprising:
Command reception module, the evaluation and test for receiving user instruct, wherein the evaluation and test instruction includes: target database
Parameter；
As a result module is obtained, the detection for instructing at least one performance of corresponding target database for obtaining the evaluation and test
As a result；
Performance Score module, for the testing result according at least one of described performance, to the property of the target database
It can be carried out scoring；And
As a result display module, for showing the appraisal result of the target database.
B11, the device as described in claim B10, the result obtain module, further comprise:
Online acquisition submodule, for instructing corresponding target database to carry out performance detection the evaluation and test, to obtain
The testing result of at least one of corresponding performance；And/or
Offline acquisition submodule, for obtaining the target database at least from pre-stored performance detection record
The testing result of one performance.
B12, the device as described in claim B10, the testing result include at least one of following:
Network performance testing result, hardware performance testing result and database performance testing result.
B13, the device as described in claim B10, the Performance Score module further comprise:
Performance Score submodule, for when the testing result meets preset deduction rule, to the target data
The corresponding evaluation and test total score in library subtracts the corresponding score of the deduction rule, to obtain final appraisal result.
B14, the device as described in claim B10, described device further include:
Alarm module, for sending a warning message when the testing result meets preset severely subnormal condition；
Wherein, the preset severely subnormal condition includes at least one of following condition:
Primary database suspension in the target database；
The target database corresponds to server delay machine where primary database；
The target database corresponds to the service stopping operation of primary database.
B15, the device as described in claim B11, the result display module further comprise:
First shows submodule, in the process for instructing corresponding target database progress performance detection to the evaluation and test
In, the description information of performance title and the performance that display is currently detecting；And/or
Second shows submodule, in the process for instructing corresponding target database progress performance detection to the evaluation and test
In, display detection progress bar and current scoring；And/or
Third shows submodule, in the process for instructing corresponding target database progress performance detection to the evaluation and test
In, display terminates control, terminates when the termination control is triggered and detects to the performance of target database.
B16, the device as described in claim B11, described device further include:
Preserving module being recorded, being recorded for saving the testing result to performance detection.
B17, the device as described in claim B11, the online acquisition submodule further comprise:
First determination unit, the detection parameters for being inputted according to user determine the target database correspondence database
The corresponding destination server of detection parameters described in cluster；
First detection unit, for executing network to the destination server by destination server described in Telnet
Performance detection and/or hardware performance detection.
B18, the device as described in claim B11, the online acquisition submodule further comprise:
Parameter receiving unit, for receiving the test object parameter and detection project parameter of user's input；
Second determination unit, for determining the target database correspondence database collection according to the test object parameter
The corresponding destination server of test object parameter described in group；
Second detection unit, it is corresponding for after destination server described in Telnet, executing the detection project parameter
Database performance detection.
Claims (16)
1. a kind of evaluating method of database, comprising:
Receive the evaluation and test instruction of user, wherein the evaluation and test instruction includes: the parameter of target database；
The testing result that the evaluation and test instructs at least one performance of corresponding target database is obtained, wherein referring to the evaluation and test
It enables corresponding target database carry out performance detection, to obtain the testing result of at least one of corresponding performance, specifically includes: root
According to the detection parameters that user inputs, the corresponding detection list of the detection parameters is obtained, determines that the target database corresponds to number
According to the corresponding destination server of detection parameters described in the cluster of library；By destination server described in Telnet, to the target
Server executes network performance detection and/or hardware performance detection；
According to the testing result of at least one of described performance, score the performance of the target database；And
Show the appraisal result of the target database；
It further include that management server is used to manage the server in data-base cluster, and stores preset management configuration file, it should
Information including each server in data-base cluster in management configuration file, and the current shape according to each server managed
Condition executes corresponding performance detection.
2. the method as described in claim 1, which is characterized in that the acquisition evaluation and test instructs corresponding target database
The step of testing result of at least one performance, further comprise:
The testing result of at least one performance of the target database is obtained from pre-stored performance detection record.
3. the method as described in claim 1, which is characterized in that the testing result includes at least one of following:
Network performance testing result, hardware performance testing result and database performance testing result.
4. the method as described in claim 1, which is characterized in that the testing result of performance at least one of described in the foundation is right
The step of performance of the target database is scored further comprises:
When the testing result meets preset deduction rule, evaluation and test total score corresponding to the target database subtracts described
The corresponding score of deduction rule, to obtain final appraisal result.
5. the method as described in claim 1, which is characterized in that the method also includes:
When the testing result meets preset severely subnormal condition, send a warning message；
Wherein, the preset severely subnormal condition includes at least one of following condition:
Primary database suspension in the target database；
The target database corresponds to server delay machine where primary database；
The target database corresponds to the service stopping operation of primary database.
6. method according to claim 2, which is characterized in that the step of the appraisal result for showing the target database
Suddenly, further comprise:
During instructing corresponding target database to carry out performance detection the evaluation and test, the current property detected of display
The description information of energy title and the performance；And/or
During instructing corresponding target database to carry out performance detection the evaluation and test, display detects progress bar and works as
Preceding scoring；And/or
During instructing corresponding target database to carry out performance detection the evaluation and test, display terminates control, when the end
It is terminated when only control is triggered and the performance of target database is detected.
7. method according to claim 2, which is characterized in that instructing corresponding target database feasibility to the evaluation and test
It can detect, after obtaining the testing result of at least one performance, the method also includes:
The testing result is saved to performance detection and is recorded.
8. method according to claim 2, which is characterized in that described to instruct corresponding target database to execute the evaluation and test
The step of performance detection, further comprises:
Receive the test object parameter and detection project parameter of user's input；
According to the test object parameter, test object parameter pair described in the target database correspondence database cluster is determined
The destination server answered；
After destination server described in Telnet, the corresponding database performance detection of the detection project parameter is executed.
9. a kind of performance evaluating apparatus of data-base cluster, comprising:
Command reception module, the evaluation and test for receiving user instruct, wherein the evaluation and test instruction includes: the ginseng of target database
Number；
As a result module is obtained, the detection knot for instructing at least one performance of corresponding target database for obtaining the evaluation and test
Fruit, including online acquisition submodule, for instructing corresponding target database progress performance detection to the evaluation and test, to obtain pair
The testing result of at least one performance answered, specifically includes: the first determination unit, the detection parameters for being inputted according to user,
The corresponding detection list of the detection parameters is obtained, determines detection parameters described in the target database correspondence database cluster
Corresponding destination server；First detection unit, for passing through destination server described in Telnet, to the destination server
Execute network performance detection and/or hardware performance detection；
Performance Score module, for the testing result according at least one of described performance, to the performance of the target database into
Row scoring；And
As a result display module, for showing the appraisal result of the target database；
It further include that management server is used to manage the server in data-base cluster, and stores preset management configuration file, it should
Information including each server in data-base cluster in management configuration file, and the current shape according to each server managed
Condition executes corresponding performance detection.
10. device as claimed in claim 9, which is characterized in that the result obtains module, further comprises:
Offline acquisition submodule, for from pre-stored performance detection record in obtain the target database at least one of
The testing result of performance.
11. device as claimed in claim 9, which is characterized in that the testing result includes at least one of following:
Network performance testing result, hardware performance testing result and database performance testing result.
12. device as claimed in claim 9, which is characterized in that the Performance Score module further comprises:
Performance Score submodule, for when the testing result meets preset deduction rule, to the target database pair
The evaluation and test total score answered subtracts the corresponding score of the deduction rule, to obtain final appraisal result.
13. device as claimed in claim 9, which is characterized in that described device further include:
Alarm module, for sending a warning message when the testing result meets preset severely subnormal condition；
Wherein, the preset severely subnormal condition includes at least one of following condition:
Primary database suspension in the target database；
The target database corresponds to server delay machine where primary database；
The target database corresponds to the service stopping operation of primary database.
14. device as claimed in claim 10, which is characterized in that the result display module further comprises:
First shows submodule, is used for during instructing corresponding target database to carry out performance detection the evaluation and test,
The description information of performance title and the performance that display is currently detecting；And/or
Second shows submodule, is used for during instructing corresponding target database to carry out performance detection the evaluation and test,
Display detection progress bar and current scoring；And/or
Third shows submodule, is used for during instructing corresponding target database to carry out performance detection the evaluation and test,
Display terminates control, terminates when the termination control is triggered and detects to the performance of target database.
15. device as claimed in claim 10, which is characterized in that described device further include:
Preserving module being recorded, being recorded for saving the testing result to performance detection.
16. device as claimed in claim 10, which is characterized in that the online acquisition submodule further comprises:
Parameter receiving unit, for receiving the test object parameter and detection project parameter of user's input；
Second determination unit, for determining in the target database correspondence database cluster according to the test object parameter
The corresponding destination server of the test object parameter；
Second detection unit, for executing the corresponding number of the detection project parameter after destination server described in Telnet
According to library performance detection.
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 CN105404581A (en) | 2016-03-16 |
| CN105404581B true 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) |
Families Citing this family (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106528388A (en) * | 2016-10-21 | 2017-03-22 | 网易（杭州）网络有限公司 | Database detection method and apparatus |
| CN108446210B (en) * | 2018-02-07 | 2021-04-30 | 平安科技（深圳）有限公司 | System performance measurement method, storage medium and server |
| CN108388503A (en) * | 2018-02-13 | 2018-08-10 | 中体彩科技发展有限公司 | Data-base performance monitoring method, system, equipment and computer readable storage medium |
| CN108874640B (en) * | 2018-05-07 | 2022-09-30 | 北京京东尚科信息技术有限公司 | Cluster performance evaluation method and device |
| 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 |
| 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 |
| CN110716910B (en) * | 2019-10-14 | 2022-10-14 | 中国建设银行股份有限公司 | Log management method, device, equipment and storage medium |
| CN111552637B (en) * | 2020-04-20 | 2023-05-19 | 北京顺达同行科技有限公司 | 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105404581A (en) | 2016-03-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105404581B (en) | A kind of evaluating method and device of database | |
| JP6602435B2 (en) | Parallel execution of continuous event processing (CEP) queries | |
| US11023355B2 (en) | Dynamic tracing using ranking and rating | |
| US10459780B2 (en) | Automatic application repair by network device agent | |
| US20180075240A1 (en) | Method and device for detecting a suspicious process by analyzing data flow characteristics of a computing device | |
| US8756301B2 (en) | Systems and methods for organic knowledge base runbook automation | |
| US9817742B2 (en) | Detecting hardware and software problems in remote systems | |
| US8862941B2 (en) | Methods and apparatus for remediation execution | |
| US10860465B2 (en) | Automatically rerunning test executions | |
| CN106101130B (en) | A kind of network malicious data detection method, apparatus and system | |
| CN105191211B (en) | Log extracting method and server cluster under server cluster | |
| US20130254524A1 (en) | Automated configuration change authorization | |
| JP2017201470A (en) | Setting support program, setting support method, and setting support device | |
| JP6037397B2 (en) | User operation log recording method, program and apparatus thereof | |
| EP3214548A1 (en) | Systems and methods for operating a virtual power environment | |
| CN108073499B (en) | Application program testing method and device | |
| CN111478792B (en) | Cutover information processing method, system and device | |
| CN110297846A (en) | A kind of log feature processing system, method, electronic equipment and storage medium | |
| CN110363381B (en) | Information processing method and device | |
| US10021013B2 (en) | Optimizing the monitoring of an enterprise server environment | |
| CN114416589A (en) | Network target range comprehensive detection method, device, equipment and readable storage medium | |
| US20140359365A1 (en) | Integrated Configuration Management and Monitoring for Computer Systems | |
| CN106533812B (en) | Application server | |
| CN104967667A (en) | Software stability test remote monitoring system based on cloud service | |
| CN109445877B (en) | Method for detecting same virtual machine used by multiple threads of game server |
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 |
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. |
|
| TR01 | Transfer of patent right |