CN108259259A - Cluster stability diagnostic method and device - Google Patents
Cluster stability diagnostic method and device Download PDFInfo
- Publication number
- CN108259259A CN108259259A CN201611256004.1A CN201611256004A CN108259259A CN 108259259 A CN108259259 A CN 108259259A CN 201611256004 A CN201611256004 A CN 201611256004A CN 108259259 A CN108259259 A CN 108259259A
- Authority
- CN
- China
- Prior art keywords
- consuming
- cluster
- stage
- time
- execution
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000002405 diagnostic procedure Methods 0.000 title claims abstract description 10
- 238000000034 method Methods 0.000 claims abstract description 19
- 238000004458 analytical method Methods 0.000 description 5
- 238000012423 maintenance Methods 0.000 description 5
- 230000008439 repair process Effects 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 230000008878 coupling Effects 0.000 description 2
- 238000011156 evaluation Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 241000282813 Aepyceros melampus Species 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000003745 diagnosis Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L43/00—Arrangements for monitoring or testing data switching networks
- H04L43/08—Monitoring or testing based on specific metrics, e.g. QoS, energy consumption or environmental parameters
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/50—Network service management, e.g. ensuring proper service fulfilment according to agreements
- H04L41/5003—Managing SLA; Interaction between SLA and QoS
- H04L41/5009—Determining service level performance parameters or violations of service level contracts, e.g. violations of agreed response time or mean time between failures [MTBF]
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L43/00—Arrangements for monitoring or testing data switching networks
- H04L43/16—Threshold monitoring
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Environmental & Geological Engineering (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention discloses a kind of cluster stability diagnostic method and devices.Wherein, this method includes：Same structured query language is performed according to the scheduled execution period, and obtains and performs taking for structured query language；Determine whether take is more than benchmark total time-consuming；It is taking more than in the case of benchmark total time-consuming, is determining that cluster is unstable.The present invention solves and can not diagnose the technical issues of cluster is slack-off in time in the prior art.
Description
Technical field
The present invention relates to computer internet field, in particular to a kind of cluster stability diagnostic method and device.
Background technology
In field of distributed type, cluster can be frequently used to perform task or inquired, and cluster is in the general of company
And degree is very extensive, existing company can all use multiple big clusters substantially, and various tasks are performed on cluster, this makes
The O＆M for obtaining cluster is sufficiently complex, for example, the colleague for carrying out O＆M in company to cluster often receives the throwing of project team colleague
It tells, including " the xx times, cluster is slack-off, similarly inquires original 3 seconds and completes, also performs within present 3 minutes endless " etc..Cluster
Slack-off is a kind of situation when cluster is unstable, and user's impression slack-off to cluster has hysteresis quality, that is, experiences in user
To cluster it is slack-off when, actually had a time difference apart from cluster is unstable.Therefore, to solve cluster O＆M
Problem, it is desirable to be able to be diagnosed to be the stability of cluster in time.
For the problem of cluster is slack-off can not be diagnosed in time in the prior art, effective solution party is not yet proposed at present
Case.
Invention content
An embodiment of the present invention provides a kind of cluster stability diagnostic method and device, at least solve in the prior art without
The technical issues of cluster is slack-off is arrived in diagnosis to method in time.
One side according to embodiments of the present invention provides a kind of cluster stability diagnostic method, including：According to predetermined
The execution period perform same structured query language, and obtain and perform taking for structured query language；Determining to take is
No is more than benchmark total time-consuming；It is taking more than in the case of benchmark total time-consuming, is determining that cluster is unstable.
Another aspect according to embodiments of the present invention additionally provides a kind of cluster stability diagnostic device, including：First obtains
Modulus block, for performing same structured query language, and obtain and perform structuralized query language according to the scheduled execution period
Speech takes；Whether the first determining module is more than benchmark total time-consuming for determining to take；Second determining module, for taking
In the case of more than benchmark total time-consuming, determine that cluster is unstable.
In embodiments of the present invention, using the time as the index for judging cluster stability, by according to scheduled execution
Period performs same structured query language, and obtains and perform taking for structured query language, determine to take whether be more than
Benchmark total time-consuming, and taking more than in the case of benchmark total time-consuming, it determines that cluster is unstable, has reached evaluation cluster stability
Purpose, and the phenomenon that cluster is unstable can be diagnosed in time, guarantee quickly to start subsequently slack-off to cluster
The analysis of reason and maintenance and repair to cluster etc., it is achieved thereby that saving time cost, the technology for improving user experience
Effect, and then solve and can not diagnose the technical issues of cluster is slack-off in time in the prior art.
Description of the drawings
Attached drawing described herein is used to provide further understanding of the present invention, and forms the part of the application, this hair
Bright illustrative embodiments and their description do not constitute improper limitations of the present invention for explaining the present invention.In the accompanying drawings：
Fig. 1 is a kind of flow chart of according to embodiments of the present invention 1 cluster stability diagnostic method；
Fig. 2 is a kind of structure chart of according to embodiments of the present invention 2 cluster stability diagnostic device；
Fig. 3 is a kind of structure chart of according to embodiments of the present invention 2 optional cluster stability diagnostic device；
Fig. 4 is a kind of structure chart of according to embodiments of the present invention 2 optional cluster stability diagnostic device；
Fig. 5 is a kind of structure chart of according to embodiments of the present invention 2 optional cluster stability diagnostic device；And
Fig. 6 is a kind of structure chart of according to embodiments of the present invention 2 optional cluster stability diagnostic device.
Specific embodiment
In order to which those skilled in the art is made to more fully understand the present invention program, below in conjunction in the embodiment of the present invention
The technical solution in the embodiment of the present invention is clearly and completely described in attached drawing, it is clear that described embodiment is only
The embodiment of a part of the invention, instead of all the embodiments.Based on the embodiments of the present invention, ordinary skill people
Member's all other embodiments obtained without making creative work should all belong to the model that the present invention protects
It encloses.
It should be noted that term " first " in description and claims of this specification and above-mentioned attached drawing, "
Two " etc. be the object for distinguishing similar, and specific sequence or precedence are described without being used for.It should be appreciated that it uses in this way
Data can be interchanged in the appropriate case, so as to the embodiment of the present invention described herein can in addition to illustrating herein or
Sequence other than those of description is implemented.In addition, term " comprising " and " having " and their any deformation, it is intended that cover
Cover it is non-exclusive include, be not necessarily limited to for example, containing the process of series of steps or unit, method, system, product or equipment
Those steps or unit clearly listed, but may include not listing clearly or for these processes, method, product
Or the intrinsic other steps of equipment or unit.
Embodiment 1
According to embodiments of the present invention, a kind of embodiment of the method for cluster stability diagnostic method is provided, needs what is illustrated
It is that step shown in the flowchart of the accompanying drawings can perform in the computer system of such as a group of computer-executable instructions,
Also, although logical order is shown in flow charts, in some cases, it can be performed with the sequence being different from herein
Shown or described step.
Fig. 1 is cluster stability diagnostic method according to embodiments of the present invention, as shown in Figure 1, this method includes following step
Suddenly：
Step S102 performs same structured query language, and obtain execution structuring according to the scheduled execution period
Query language takes.
Specifically, structured query language can be sql, sql is most important relational database operation language, can be certainly
A specific structured query language is preset in definition, it is preferred that the resource consumption of the specific structured query language is unsuitable
It is excessive, the specific structured query language then is performed according to the scheduled execution period, for each time to the specific knot
The execution of structure query language obtains and once performs taking for the specific structured query language.
In a kind of optional embodiment, the cluster in the present invention can be CDH (Cloudera ˊ s Distribution
Including Apache Hadoop) cluster, for CDH clusters, cloudera manager are used as cluster management at present
System provides the loads such as cpu, memory, io, network of many fine-grained each machines on cloudera manager
And service condition, the slack-off situation of cluster also can often occur；For CDH clusters, obtain and perform structured query language
It takes and existing mode in the prior art may be used is obtained, can also be obtained by following manner：Pass through cluster management
The application programming interface api of system cloudera manager is obtained based on distributed query engine impala in cluster
The inquiry record inquired based on structured query language；On cloudera manager platforms, it can be seen that use knot
The inquiry record and some other basic informations that structure query language is inquired, wherein basic information include performing structure
Change query language take, further include query time, user name, accrued memory, accumulative memory using peak value, each node it is interior
It deposits using peak value, the HDFS bytes read, pond etc., and can be by clicking on cloudera manager platform interfaces
" query details " function key performs the execution information for inquiring record of structured query language further to obtain each time
(sqlprofile), wherein execution information include perform structured query language during each perform the stage take and
Taking for step is each each performed during performing structured query language in the execution stage.
Step S104 determines whether take is more than benchmark total time-consuming.
Specifically, get perform structured query language take after, can by this take it is total with preset benchmark
It takes and is compared, wherein, benchmark total time-consuming can be meant according to the self-defined setting of actual conditions, the representative of benchmark total time-consuming
The standard that above-mentioned specific structured query language is performed under cluster stable state takes.
Step S106 is taking more than in the case of benchmark total time-consuming, is determining that cluster is unstable.
Specifically, by perform structured query language take with benchmark total time-consuming relatively after, if perform structuring look into
It is more than benchmark total time-consuming to ask taking for language, illustrates to perform the overlong time of structured query language, can also illustrate at this time
Cluster is unstable, it may also be said to which cluster is shaken, if performing taking for structured query language is no more than benchmark
Total time-consuming, as soon as the time for illustrating to perform structured query language is in a rational range, also cluster is stable to explanation at this time
, do not shake.
In the above embodiment of the present invention, using the time as the index for judging cluster stability, by according to scheduled
Performing the period performs same structured query language, and obtain and perform taking for structured query language, determine to take whether
It more than benchmark total time-consuming, and is taking more than in the case of benchmark total time-consuming, is determining that cluster is unstable, it is steady to have reached evaluation cluster
Qualitatively purpose, and the phenomenon that cluster is unstable can be diagnosed in time, guarantee quickly to start subsequently to cluster change
The analysis of the reason of slow and the maintenance and repair to cluster etc., it is achieved thereby that saving time cost, improving user experience
Technique effect, and then solve and can not diagnose the technical issues of cluster is slack-off in time in the prior art.
In a kind of optional embodiment, after step S106, including：
Step S202 is obtained and taking for stage is each performed during performing structured query language.
Time-consuming corresponding benchmark stage respectively in each execution stage is taken and is compared, determined by step S204
Take the execution stage taken more than the corresponding benchmark stage.
Specifically, when determining that cluster is unstable shake namely having occurred, in order to further determine it is at which
A execution stage take it is more lead to the unstable of cluster, can obtain perform structured query language during each perform
Stage takes, wherein, each execution stage takes there are one the preset benchmark stage, by comparing, it may be determined which
The time-consuming of execution stage has been more than to take in its corresponding benchmark stage.
By above-mentioned steps S202- step S204, can determine to be specifically which performs stage consumption when cluster is unstable
When it is more.
In a kind of optional embodiment, for CDH clusters, such as describe above, it can be by clicking in CDH clusters
" query details " function key on cloudera manager platform interfaces performs structuring each time further to obtain
The execution information (sql profile) of the inquiry record of query language, wherein execution information include performing structured query language
During each perform the stage take, and also can get perform structured query language executive plan, wherein
Including the corresponding benchmark stage in each execution stage in executive plan takes, by comparing the practical execution stage take and
Its corresponding benchmark stage takes, it may be determined that it has been more than to take in its corresponding benchmark stage which, which performs the time-consuming of stage,.
In a kind of optional embodiment, after step S204, including：
Step S302 obtains the consumption that step is each performed in the execution stage for taking and being taken more than the corresponding benchmark stage
When.
Each time-consuming corresponding calibration step respectively for performing step is taken and is compared, determined by step S304
Take the execution step taken more than corresponding calibration step.
Specifically, after the execution stage for taking and being taken more than the benchmark stage is determined, in order to further determine
Be perform the stage which perform step take it is more lead to the unstable of cluster, can obtain take be more than corresponding benchmark
Taking for step is each performed in the execution stage that stage takes, wherein, step is each performed in the execution stage, and there are one pre-
If calibration step take, by comparing, it may be determined that it has been more than its corresponding calibration step consumption which, which performs the time-consuming of step,
When.
By above-mentioned steps S302- step S304, can determine to take in the more execution stage when cluster is unstable
Specifically it is more to perform taking for step for which.
In a kind of optional embodiment, for CDH clusters, such as describe above, it can be by clicking in CDH clusters
" query details " function key on cloudera manager platform interfaces performs structuring each time further to obtain
The execution information (sql profile) of the inquiry record of query language, wherein execution information include performing structured query language
During taking for step is each each performed in the execution stage, and can also get and perform structured query language
Include the corresponding calibration step of each execution step in executive plan, wherein executive plan to take, by comparing practical execution
Time-consuming and its corresponding calibration step of step takes, it may be determined that it has been more than its corresponding base which, which performs the time-consuming of step,
Quasi- step takes.Wherein, for single machine, each execution step packet for performing the stage of executing agency's query language
The content contained is almost consistent, this is determined by the distributed thought of CDH clusters, and each step that performs is first to obtain
Data (map stages), then data are done and are polymerize (reduce stages).
In a kind of optional embodiment, after step S304, including：Step S402 is more than corresponding base according to taking
The execution step that quasi- step takes, it is more than corresponding calibration step that taking for the execution step is obtained from the experience library of prebuild
The reason of taking.
Specifically, an experience library can be built in advance, record when performing step and taking excessive for one, that is, take
It when taking more than calibration step, may cause to take the reason of excessive, therefore, be determined that it is more than corresponding calibration step to take
After time-consuming execution step, by inquiring experience library, it will be able to acquisition eventually leads to the reason of cluster is unstable, if for example,
Certain execution stage takes excessively, it is understood that there may be the reason of including inquiry when remote read excessive, resource pool and wait for excessive, lock etc.
Treat that excessive either some slow node has seriously tied down whole implementation progress, wherein, certain node memory deficiency, disk performance are not
Foot etc. may cause some slow node to tie down whole implementation progress.
Herein it should be noted that the experience library of prebuild can be constantly updated in continuous cluster O＆M,
Including but not limited to increase, delete, changing, the data in replacement experience library.
, can be when cluster be unstable by above-mentioned steps S402, the reason of obtaining the possibility for causing cluster unstable, root
According to the reason, can analysis examination and maintenance targetedly be carried out to cluster.
In a kind of optional embodiment, being obtained in the experience library from prebuild causes to take more than corresponding benchmark step
Suddenly after time-consuming the reason of being taken more than corresponding calibration step of time-consuming execution step, warning message can also be generated, wherein
Warning message includes above-mentioned reason.
In a kind of optional embodiment, after step S102, including：Step S502 draws and takes figure, takes figure at least
Including by performing the time-consuming curve formed of structured query language each time and representing the straight line of benchmark total time-consuming.
Specifically, get perform structured query language take after, can mark in dots in a two dimensional
It outpours and performs taking for structured query language each time, then connect all the points, form a curve, wherein, two
The longitudinal axis for tieing up figure represents the time, and horizontal axis can represent to perform the coding of structured query language, serial number or time mark each time
Know etc., the straight line for representing benchmark total time-consuming is further included in X-Y scheme, when curve is higher than straight line, illustrates that cluster is unstable, with straight line
It overlaps or during less than straight line, illustrates that cluster is in stable state.
By above-mentioned steps S502, the stability of cluster can intuitively be shown, determine that cluster is held in which time
It is shaken during row structured query language, that is, cluster is shaken in which time, is in just in which time
Normal state if after cluster is shaken, repairs cluster, can also observe that cluster is occurring by taking figure
How long restore after shake normal.
Embodiment 2
According to embodiments of the present invention, a kind of product embodiments of cluster stability diagnostic device are provided, Fig. 2 is according to this
The cluster stability diagnostic device of inventive embodiments, as shown in Fig. 2, the device includes the first acquisition module 101, the first determining mould
103 and second determining module 105 of block.
Wherein, the first acquisition module 101, for performing same structured query language according to the scheduled execution period,
And it obtains and performs taking for structured query language；Whether the first determining module 103 always consumes for determining to take more than benchmark
When；Second determining module 105 for taking more than in the case of benchmark total time-consuming, determines that cluster is unstable.
In the above embodiment of the present invention, using the time as the index for judging cluster stability, mould is obtained by first
Block 101 performs same structured query language according to the scheduled execution period, and obtains the consumption for performing structured query language
When, determine whether take is more than benchmark total time-consuming, and taking the situation more than benchmark total time-consuming by the first determining module 103
Under, it determines that cluster is unstable by the second determining module 105, has achieved the purpose that evaluate cluster stability, and can examine in time
Break to cluster it is unstable the phenomenon that, guarantee quickly start it is subsequently slack-off to cluster the reason of analysis and to cluster
Maintenance and repair etc. it is achieved thereby that saving time cost, improving the technique effect of user experience, and then solves the prior art
In can not diagnose the technical issues of cluster is slack-off in time.
Herein it should be noted that above-mentioned first acquisition module 101, the first determining module 103 and the second determining module 105
Corresponding to the step S102 in embodiment 1 to step S106, example and applied field that above-mentioned module is realized with corresponding step
Scape is identical, but is not limited to the above embodiments 1 disclosure of that.An it should be noted that part of the above-mentioned module as device
It can be performed in the computer system of such as a group of computer-executable instructions.
In a kind of optional embodiment, as shown in figure 3, device further includes the second acquisition module 201 and third determines mould
Block 203.
Wherein, the second acquisition module 201, for after the second determining module 105 determines that cluster is unstable, acquisition to perform knot
Taking for stage is each performed during structure query language.Third determining module 203, for by the consumption in each execution stage
When respectively corresponding benchmark stage take and be compared, determine to take the execution rank taken more than the corresponding benchmark stage
Section.
By above-mentioned second acquisition module 201 and third determining module 203, can be determined specific when cluster is unstable
It is more to be which takes in execution stage.
Herein it should be noted that above-mentioned second acquisition module 201 and third determining module 203 correspond in embodiment 1
Step S202 to step S204, above-mentioned module is identical with example and application scenarios that corresponding step is realized, but is not limited to
1 disclosure of that of above-described embodiment.It should be noted that above-mentioned module can be in such as one group of meter as a part of of device
It is performed in the computer system of calculation machine executable instruction.
In a kind of optional embodiment, as shown in figure 4, device further includes 301 and the 4th determining mould of third acquisition module
Block 303.
Wherein, third acquisition module 301 is more than the corresponding benchmark stage for determining to take in third determining module 203
After the time-consuming execution stage, the consumption that step is each performed in the execution stage for taking and being taken more than the corresponding benchmark stage is obtained
When；4th determining module 303 compares for each time-consuming corresponding calibration step respectively for performing step to be taken
Compared with determining to take the execution step taken more than corresponding calibration step.
By above-mentioned 301 and the 4th determining module 303 of third acquisition module, can be determined specific when cluster is unstable
It is which performs the time-consuming more of step in the time-consuming more execution stage.
Herein it should be noted that 301 and the 4th determining module 303 of above-mentioned third acquisition module corresponds in embodiment 1
Step S302 to step S304, above-mentioned module is identical with example and application scenarios that corresponding step is realized, but is not limited to
1 disclosure of that of above-described embodiment.It should be noted that above-mentioned module can be in such as one group of meter as a part of of device
It is performed in the computer system of calculation machine executable instruction.
In a kind of optional embodiment, as shown in figure 5, device further includes the 4th acquisition module 401, for true the 4th
Cover half block 303 is determined after taking the execution step taken more than corresponding calibration step, is more than that corresponding benchmark walks according to taking
Suddenly time-consuming execution step, acquisition causes to take from the experience library of prebuild performs step more than what corresponding calibration step took
Rapid taking is more than the reason of corresponding calibration step takes.
By above-mentioned 4th acquisition module 401, cause cluster unstable possible can be obtained when cluster is unstable
Reason according to the reason, targetedly can carry out analysis examination and maintenance to cluster.
Herein it should be noted that above-mentioned 4th acquisition module 401 corresponds to the step S402 in embodiment 1, above-mentioned mould
Block is identical with example and application scenarios that corresponding step is realized, but is not limited to the above embodiments 1 disclosure of that.It needs
Illustrate, above-mentioned module can be in the computer system of such as a group of computer-executable instructions as a part of of device
It performs.
In a kind of optional embodiment, as shown in fig. 6, device further includes drafting module 501, for obtaining mould first
Block 101 obtain perform structured query language take after draw take figure, take figure include at least by performing structure each time
Change the curve of the time-consuming formation of query language and represent the straight line of benchmark total time-consuming.
By above-mentioned drafting module 501, the stability of cluster can intuitively be shown, determine cluster in which time
It is shaken when performing structured query language, that is, cluster is shaken in which time, is in which time
Normal condition if after cluster is shaken, repairs cluster, can also observe that cluster is being sent out by taking figure
How long restore normal after raw shake.
Herein it should be noted that above-mentioned drafting module 501 correspond to embodiment 1 in step S502, above-mentioned module with
The example that corresponding step is realized is identical with application scenarios, but is not limited to the above embodiments 1 disclosure of that.It needs to illustrate
, above-mentioned module can hold as a part of of device in the computer system of such as a group of computer-executable instructions
Row.
The embodiments of the present invention are for illustration only, do not represent the quality of embodiment.
In the above embodiment of the present invention, all emphasize particularly on different fields to the description of each embodiment, do not have in some embodiment
The part of detailed description may refer to the associated description of other embodiment.
In several embodiments provided herein, it should be understood that disclosed technology contents can pass through others
Mode is realized.Wherein, the apparatus embodiments described above are merely exemplary, such as the division of the unit, Ke Yiwei
A kind of division of logic function, can there is an other dividing mode in actual implementation, for example, multiple units or component can combine or
Person is desirably integrated into another system or some features can be ignored or does not perform.Another point, shown or discussed is mutual
Between coupling, direct-coupling or communication connection can be INDIRECT COUPLING or communication link by some interfaces, unit or module
It connects, can be electrical or other forms.
The unit illustrated as separating component may or may not be physically separate, be shown as unit
The component shown may or may not be physical unit, you can be located at a place or can also be distributed to multiple
On unit.Some or all of unit therein can be selected according to the actual needs to realize the purpose of this embodiment scheme.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, it can also
That each unit is individually physically present, can also two or more units integrate in a unit.Above-mentioned integrated list
The form that hardware had both may be used in member is realized, can also be realized in the form of SFU software functional unit.
If the integrated unit is realized in the form of SFU software functional unit and is independent product sale or uses
When, it can be stored in a computer read/write memory medium.Based on such understanding, technical scheme of the present invention is substantially
The part to contribute in other words to the prior art or all or part of the technical solution can be in the form of software products
It embodies, which is stored in a storage medium, is used including some instructions so that a computer
Equipment (can be personal computer, server or network equipment etc.) perform each embodiment the method for the present invention whole or
Part steps.And aforementioned storage medium includes：USB flash disk, read-only memory (ROM, Read-Only Memory), arbitrary access are deposited
Reservoir (RAM, Random Access Memory), mobile hard disk, magnetic disc or CD etc. are various can to store program code
Medium.
The above is only the preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art
For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications also should
It is considered as protection scope of the present invention.
Claims (10)
1. a kind of cluster stability diagnostic method, which is characterized in that including：
Same structured query language is performed, and obtain and perform the structured query language according to the scheduled execution period
It takes；
Determine whether described take is more than benchmark total time-consuming；
It is taken described more than in the case of the benchmark total time-consuming, determines that the cluster is unstable.
2. according to the method described in claim 1, it is characterized in that, after determining that the cluster is unstable, the method is also wrapped
It includes：
It obtains and taking for stage is each performed during performing the structured query language；
Time-consuming corresponding benchmark stage respectively in each execution stage is taken and is compared, it is more than pair to determine to take
The execution stage that the benchmark stage answered takes.
3. it according to the method described in claim 2, it is characterized in that, determines to take the execution taken more than the corresponding benchmark stage
After stage, the method further includes：
It obtains and taking for step is each performed in the execution stage for taking and being taken more than the corresponding benchmark stage；
Each time-consuming corresponding calibration step respectively for performing step is taken and is compared, it is more than corresponding to determine to take
The execution step that calibration step takes.
4. it according to the method described in claim 3, it is characterized in that, determines to take the execution taken more than corresponding calibration step
After step, the method further includes：
According to the execution step for taking and being taken more than corresponding calibration step, being obtained from the experience library of prebuild leads to this
It is more than the reason of corresponding calibration step takes to perform taking for step.
5. according to claim 1-4 any one of them methods, which is characterized in that performed according to the scheduled execution period same
Structured query language, and obtain perform the structured query language it is time-consuming after, the method further includes：
It draws and takes figure, the time-consuming figure includes at least the time-consuming song formed by performing the structured query language each time
Line and the straight line for representing the benchmark total time-consuming.
6. a kind of cluster stability diagnostic device, which is characterized in that including：
First acquisition module, for performing same structured query language, and obtain and perform institute according to the scheduled execution period
State taking for structured query language；
First determining module, for determining whether described take is more than benchmark total time-consuming；
Second determining module for being taken described more than in the case of the benchmark total time-consuming, determines that the cluster is unstable.
7. device according to claim 6, which is characterized in that described device further includes：
Second acquisition module, for after second determining module determines that the cluster is unstable, obtaining and performing the structure
Taking for stage is each performed during changing query language；
Third determining module compares for time-consuming corresponding benchmark stage respectively in each execution stage to be taken
Compared with it is more than the execution stage taken in the corresponding benchmark stage to determine to take.
8. device according to claim 7, which is characterized in that described device further includes：
Third acquisition module, for determining to take the execution rank taken more than the corresponding benchmark stage in the third determining module
Duan Hou is obtained and taking for step is each performed in the execution stage for taking and being taken more than the corresponding benchmark stage；
4th determining module is compared for each time-consuming corresponding calibration step respectively for performing step to be taken,
It determines to take the execution step taken more than corresponding calibration step.
9. device according to claim 8, which is characterized in that described device further includes：
4th acquisition module performs step for determining to take in the 4th determining module more than what corresponding calibration step took
After rapid, according to the execution step for taking and being taken more than corresponding calibration step, being obtained from the experience library of prebuild causes
Taking for the execution step is more than the reason of corresponding calibration step takes.
10. according to claim 6-9 any one of them devices, which is characterized in that described device further includes：
Drafting module takes for obtaining to perform to draw after the taking of the structured query language in first acquisition module
Figure, the time-consuming figure are included at least as described in the time-consuming curve formed and the expression that perform the structured query language each time
The straight line of benchmark total time-consuming.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611256004.1A CN108259259A (en) | 2016-12-29 | 2016-12-29 | Cluster stability diagnostic method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611256004.1A CN108259259A (en) | 2016-12-29 | 2016-12-29 | Cluster stability diagnostic method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108259259A true CN108259259A (en) | 2018-07-06 |
Family
ID=62721228
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611256004.1A Pending CN108259259A (en) | 2016-12-29 | 2016-12-29 | Cluster stability diagnostic method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108259259A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114398391A (en) * | 2022-01-04 | 2022-04-26 | 山东浪潮科学研究院有限公司 | A slow SQL statement statistical method, device and medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6832368B1 (en) * | 1999-02-17 | 2004-12-14 | International Business Machines Corporation | Method and system for enhancing the performance of interpreted web applications |
| CN1801145A (en) * | 2005-01-06 | 2006-07-12 | 中兴通讯股份有限公司 | Method for improving database access efficiency of application system |
| CN101876924A (en) * | 2009-04-30 | 2010-11-03 | 升东网络科技发展(上海)有限公司 | Database fault automatic detection and transfer method |
| US7921112B2 (en) * | 2007-01-25 | 2011-04-05 | Rogers Family Trust | Data management system and method to host applications and manage storage, finding and retrieval of typed items with support for tagging, connections, and situated queries |
| CN102004766A (en) * | 2010-11-09 | 2011-04-06 | 北京神州泰岳软件股份有限公司 | Query method and system for configurable information based on information system |
| CN102541885A (en) * | 2010-12-10 | 2012-07-04 | 中国移动通信集团浙江有限公司 | Method and device for detecting database blockage |
| CN102779062A (en) * | 2011-05-09 | 2012-11-14 | 阿里巴巴集团控股有限公司 | Method and device for controlling number of threads accessing system resources |
| CN105279286A (en) * | 2015-11-27 | 2016-01-27 | 陕西艾特信息化工程咨询有限责任公司 | Interactive large data analysis query processing method |
-
2016
- 2016-12-29 CN CN201611256004.1A patent/CN108259259A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6832368B1 (en) * | 1999-02-17 | 2004-12-14 | International Business Machines Corporation | Method and system for enhancing the performance of interpreted web applications |
| CN1801145A (en) * | 2005-01-06 | 2006-07-12 | 中兴通讯股份有限公司 | Method for improving database access efficiency of application system |
| US7921112B2 (en) * | 2007-01-25 | 2011-04-05 | Rogers Family Trust | Data management system and method to host applications and manage storage, finding and retrieval of typed items with support for tagging, connections, and situated queries |
| CN101876924A (en) * | 2009-04-30 | 2010-11-03 | 升东网络科技发展(上海)有限公司 | Database fault automatic detection and transfer method |
| CN102004766A (en) * | 2010-11-09 | 2011-04-06 | 北京神州泰岳软件股份有限公司 | Query method and system for configurable information based on information system |
| CN102541885A (en) * | 2010-12-10 | 2012-07-04 | 中国移动通信集团浙江有限公司 | Method and device for detecting database blockage |
| CN102779062A (en) * | 2011-05-09 | 2012-11-14 | 阿里巴巴集团控股有限公司 | Method and device for controlling number of threads accessing system resources |
| CN105279286A (en) * | 2015-11-27 | 2016-01-27 | 陕西艾特信息化工程咨询有限责任公司 | Interactive large data analysis query processing method |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114398391A (en) * | 2022-01-04 | 2022-04-26 | 山东浪潮科学研究院有限公司 | A slow SQL statement statistical method, device and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN115481884A (en) | Engineering progress information visual management method based on engineering structure tree | |
| CN105550225B (en) | Index structuring method, querying method and device | |
| CN106126388A (en) | The method of monitor event, regulation engine device and rule engine system | |
| CN110909986A (en) | Suspected actual controller risk identification method and system based on knowledge graph | |
| CN112700131B (en) | AB test method and device based on artificial intelligence, computer equipment and medium | |
| CN110134659B (en) | Log monitoring system, method, medium, and apparatus for running program | |
| CN111083013B (en) | Test method and device based on flow playback, electronic equipment and storage medium | |
| CN109460676A (en) | A kind of desensitization method of blended data, desensitization device and desensitization equipment | |
| CN113672692B (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN113568693A (en) | Form rendering method and form rendering system | |
| CN114116774A (en) | Log data query method and device | |
| CN109389518A (en) | Association analysis method and device | |
| CN110975279B (en) | Game data processing method and device, game server and storage medium | |
| US20120095986A1 (en) | Runtime optimization of spatiotemporal events processing background | |
| CN114185631A (en) | Project task display method and device, storage medium and electronic device | |
| CN110852559A (en) | Resource allocation method and device, storage medium and electronic device | |
| CN107885781A (en) | A kind of method for edition management and system | |
| CN108259259A (en) | Cluster stability diagnostic method and device | |
| CN113313615A (en) | Method and device for quantitatively grading and grading enterprise judicial risks | |
| CN118740419A (en) | Network environment testing method, equipment and storage medium | |
| CN104484277B (en) | Process data dynamic analysis device based on monitoring point and use method thereof | |
| CN114742430A (en) | User retention early warning visualization method, device, equipment and storage medium | |
| CN108984289A (en) | Priority control method, device and car networking service platform | |
| CN114860851A (en) | Data processing method, device, equipment and storage medium | |
| CN113704624A (en) | User distribution based strategy recommendation method, device, equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Applicant after: Beijing Guoshuang Technology Co.,Ltd. Address before: 100086 Cuigong Hotel, 76 Zhichun Road, Shuangyushu District, Haidian District, Beijing Applicant before: Beijing Guoshuang Technology Co.,Ltd. |
|
| CB02 | Change of applicant information | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180706 |
|
| RJ01 | Rejection of invention patent application after publication |