CN106528388A - Database detection method and apparatus - Google Patents

Database detection method and apparatus Download PDF

Info

Publication number
CN106528388A
CN106528388A CN201610919259.5A CN201610919259A CN106528388A CN 106528388 A CN106528388 A CN 106528388A CN 201610919259 A CN201610919259 A CN 201610919259A CN 106528388 A CN106528388 A CN 106528388A
Authority
CN
China
Prior art keywords
index
database
detection
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.)
Pending
Application number
CN201610919259.5A
Other languages
Chinese (zh)
Inventor
郭忆
赖明星
姜承尧
余利华
汪源
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Netease Hangzhou Network Co Ltd
Original Assignee
Netease Hangzhou Network Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Netease Hangzhou Network Co Ltd filed Critical Netease Hangzhou Network Co Ltd
Priority to CN201610919259.5A priority Critical patent/CN106528388A/en
Publication of CN106528388A publication Critical patent/CN106528388A/en
Pending legal-status Critical Current

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
    • 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/3466—Performance evaluation by tracing or monitoring
    • G06F11/3495—Performance evaluation by tracing or monitoring for systems
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/30—Authentication, i.e. establishing the identity or authorisation of security principals
    • G06F21/45—Structures or tools for the administration of authentication
    • G06F21/46—Structures or tools for the administration of authentication by designing passwords or checking the strength of passwords

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)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

An embodiment of the invention provides a database detection method. The database detection method comprises the steps of acquiring index data corresponding to all database detection indexes according to preset database detection indexes; comparing the index data corresponding to the database detection indexes with corresponding detection standards to obtain detection results corresponding to the database detection indexes; and obtaining a comprehensive score of database detection according to the detection results corresponding to the database detection indexes, and displaying the comprehensive score of the database detection. Different database detection indexes are designed for performing detection to obtain corresponding detection results, and the database comprehensive score is obtained according to the detection results and is presented, so that the risk of omission of manual detection and the like is avoided, the security and stability of database use are ensured, the database server performance is improved, and better experience is brought for a user. In addition, an embodiment of the invention provides a database detection apparatus.

Description

A kind of database detection method and apparatus
Technical field
Embodiments of the present invention are related to database access technology field, more specifically, embodiments of the present invention are related to A kind of database detection method and apparatus.
Background technology
This part is it is intended that the embodiments of the present invention stated in claims provide background or context.Herein Description is not because just recognize it is prior art in being included in this part.
Data base as an extremely complex large memory system, to service availability, data reliability, performance, peace Complete and autgmentability has very high requirement, and this causes the operation and maintenance of data base to have higher technical threshold, in order to obtain High-quality database service, current industry mainly have following two modes：One is DBA (Database that please be professional Administrator, data base administrator) carry out regular maintenance to data base, two be using publicly-owned cloud service, it is existing publicly-owned Cloud database service can provide High Availabitity fail-over scheme, therefore, it can directly use cloud service provider provide relative to into Ripe High Availabitity solution.
The content of the invention
But, above two database maintenance mode there is also certain defect, for example, for first kind of way, pass through DBA carries out hand inspection to data base, and this depends on the technical merit and experience of DBA, even if veteran professional DBA Also omission occurs when checking unavoidably, and these risks omitted may finally causes the catastrophe failure of data base；For upper The second way is stated, as almost all of cloud data base manufacturer is all realizing data by increasing redundancy in different level Storehouse High Availabitity, although which can successfully manage physical server delay machine or data base BUG etc. burst physical fault, but It is that, during data base's use, what is most often faced is frequently not these burst physical faults, and is because lacking capacity planning The performance of the unreasonable initiation of caused resource bottleneck, parameter configuration or data access integrity problem.
For this purpose, be highly desirable to a kind of database detection method, to ensure safety and stability that data base uses, improve Database service performance.
In the present context, embodiments of the present invention are expected to provide a kind of database detection method and apparatus.
In the first aspect of embodiment of the present invention, there is provided a kind of database detection method, including：
According to default database detection index, the corresponding achievement data of each database detection index is gathered respectively；
Each database detection index corresponding achievement data corresponding examination criteria is compared, obtains each The corresponding testing result of database detection index；
According to the corresponding testing result of each database detection index, the comprehensive grading of database detection is obtained, and Show the comprehensive grading of the database detection.
Alternatively, before the comprehensive grading for showing the database detection, also include：
According to the comprehensive grading of the database detection, it is determined that current detected data storehouse is in the data base for participating in detection Ranking results；And
While the database detection comprehensive grading is shown, also show according to working as that the ranking results determined are obtained The lateral comparison result of the data base that front detected data storehouse is detected with other participations.
Alternatively, database detection method provided in an embodiment of the present invention, also includes：
For each database detection index, if the testing result of the database detection index is not meet pre- bidding Standard, then judge that the corresponding database detection index of the testing result is unqualified；
If at least one database detection index is unqualified, determine detected data stock in risk.
Preferably, according to the corresponding testing result of each database detection index, obtain the synthesis of database detection Scoring, specifically includes：
For each database detection index, according to the corresponding deduction of points of the testing result of each database detection index Standard, carries out the comprehensive grading that accumulated deduction obtains the database detection.
Alternatively, before the comprehensive grading of the database detection is shown, also include：
According to the comprehensive grading of the database detection, the corresponding risk class in detected data storehouse is determined；And
The comprehensive grading of the database detection is shown, is specifically included：
According to determine, the corresponding risk class in detected data storehouse, using corresponding color pattern displaying described in number According to the comprehensive grading that storehouse is detected.
Alternatively, database detection method provided in an embodiment of the present invention, also includes：
While the database detection comprehensive grading is shown, the unqualified data base's Testing index of each item is shown.
Alternatively, database detection method provided in an embodiment of the present invention, also includes：
For the unqualified data base's Testing index of each item, unqualified data base's Testing index is set up to risk details page The link in face, the risk details page be used for showing the corresponding risk description information of unqualified data base's Testing index and/ Or repair advisory information.
Preferably, the database detection index include it is following at least one：Database table Index Design index, data base Parameter configuration index, database volume planning index, database service safety index, data base's leader follower replication index and user visit Ask data target.
Preferably, for the database table Index Design index, its corresponding testing result is obtained according to below scheme：
According to the corresponding achievement data of database table Index Design index of collection, whether deposit in judging database table index In following at least one index：Major key index, redundancy index, invalid index and poorly efficient index；
If it is, determining that the corresponding testing result of database table Index Design index does not meet preset standard；
If it is not, then determining that the corresponding testing result of database table Index Design index meets preset standard.
Preferably, the database parameter distribu-tion index include it is following at least one：Binary log parameter configuration index, Redo log parameter configuration index, service connection parameter configuration index and memory parameters distribu-tion index, the memory parameters configuration Index includes the shared parameter configuration index of example and the exclusive parameter configuration index of connection, wherein：
For the binary log parameter configuration index, its corresponding testing result is obtained according to below scheme：
According to the corresponding achievement data of binary log parameter configuration index of collection, it is determined that in the first predetermined period duration The binary log of interior generation takes up room mean size；
If it is determined that remaining space size takes sky less than the binary log produced in the first predetermined period duration Between mean size, it is determined that the corresponding testing result of the binary log parameter configuration index does not meet preset standard；Otherwise, Determine that the corresponding testing result of the binary log parameter configuration index meets preset standard；
Parameter configuration index is redo log for described, its corresponding testing result is obtained according to below scheme：
Judge detected data storehouse redoes log whether the corresponding achievement data of parameter configuration index is preset more than first Threshold value, does not meet preset standard if it is, determining and redoing log the corresponding testing result of parameter configuration index；Otherwise, it determines Redo log the corresponding testing result of parameter configuration index and meet preset standard, first predetermined threshold value is for different magnetic The preset value that disk space size is determined；
For the service connection parameter configuration index, its corresponding testing result is obtained according to below scheme：
According to collection the corresponding achievement data of service connection parameter configuration index, judge service connection volume peaks or Whether the average traffic connection quantity in the second predetermined period duration exceedes default maximum traffic connects quantity；If it is, Determine that the corresponding testing result of service connection parameter configuration index does not meet preset standard；Otherwise, it determines service connection parameter is matched somebody with somebody Put the corresponding testing result of index and meet preset standard；
For the memory parameters distribu-tion index, its corresponding testing result is obtained according to below scheme：
According to the corresponding achievement data of memory parameters distribu-tion index of collection, determine that service connection volume peaks and connection are only Whether the product and the shared parameter value sum of example for accounting for parameter value is more than physical memory size；If it is, determining memory parameters The corresponding testing result of distribu-tion index does not meet preset standard, otherwise, it determines memory parameters configure corresponding testing result meeting Preset standard.
Preferably, the database volume planning index include it is following at least one：Central processing unit CPU capacity planning Index, read/write I/O capacity planning index, memory size planning index, network bandwidth capacity planning index and storage space volume Planning index；Wherein：
For database volume planning index, its corresponding testing result is obtained according to below scheme：
According to the corresponding achievement data of CPU capacity planning index of collection, determine that cpu busy percentage peak value or the 3rd is preset CPU average utilizations in cycle duration；
If the cpu busy percentage peak value or the CPU average utilizations in the 3rd predetermined period duration are pre- more than second If threshold value, it is determined that the corresponding testing result of CPU capacity planning index does not meet preset standard, CPU capacity planning is otherwise determined The corresponding testing result of index meets preset standard；
For the I/O capacity plannings index, its corresponding testing result is obtained according to below scheme：
According to the corresponding achievement data of I/O capacity planning indexs of collection, if it is determined that in the 4th predetermined period duration, I/O utilization rates more than the 3rd predetermined threshold value duration more than the first preset ratio, it is determined that I/O capacity plannings index correspondence Testing result do not meet preset standard；Otherwise, it determines the corresponding testing result of I/O capacity planning indexs meets preset standard；
For the memory size planning index, its corresponding testing result is obtained according to below scheme：
According to the corresponding achievement data of memory size planning index of collection, if it is determined that in the 5th predetermined period duration Mean hit rate is deposited less than the 4th predetermined threshold value, it is determined that the corresponding testing result of memory size planning index does not meet pre- bidding It is accurate；Otherwise, it determines the corresponding testing result of memory size planning index meets preset standard；
For network bandwidth capacity planning index, its corresponding testing result is obtained according to below scheme：
According to the corresponding achievement data of network bandwidth capacity planning index of collection, if it is determined that in six predetermined periods In long, network bandwidth utilization factor more than the 5th predetermined threshold value duration more than the second preset ratio, it is determined that the network bandwidth The corresponding testing result of capacity planning index does not meet preset standard；Otherwise, it determines network bandwidth capacity planning index is corresponding Testing result meets preset standard；
For storage space volume planning index, its corresponding testing result is obtained according to below scheme：
According to the corresponding achievement data of storage space volume planning index of collection, determine memory space in the 7th default week Usage trend in phase duration, estimates the use demand of memory space according to the usage trend determined；If memory space is remained Covolume amount meets the use demand, it is determined that the corresponding testing result of the storage space volume planning index meets pre- bidding Standard, otherwise, it determines the corresponding testing result of storage space volume planning index does not meet preset standard.
Preferably, the database service safety index include it is following at least one：Cipher Strength index, it is periodically detected Index, scope check index and network security index；Wherein：
For Cipher Strength index, according to the corresponding achievement data of Cipher Strength index of collection, if according to default rule Then judge that the Cipher Strength that user is arranged is low, it is determined that the corresponding testing result of Cipher Strength index does not meet preset standard, Otherwise determine that the corresponding testing result of Cipher Strength index meets preset standard；
For being periodically detected index, the corresponding achievement data of index is periodically detected according to what is gathered, if it is determined that use Family is not periodically detected to data base, it is determined that is periodically detected the corresponding testing result of index and is not met preset standard, Otherwise determine that being periodically detected the corresponding testing result of index meets preset standard；
For scope check index, according to the corresponding achievement data of scope check index of collection, obtain and access detected The authority information of the user of data base, if the number of users of high authority is more than the 3rd preset ratio, it is determined that scope check refers to Mark corresponding testing result and do not meet preset standard, the corresponding testing result of the Index for examination that otherwise defines the competence meets pre- bidding It is accurate；
For network security index, according to the corresponding achievement data of network security index of collection, if being not provided with network Fire wall and/or the network address information of non-limited-access data storehouse user, it is determined that the corresponding detection knot of network security index Fruit does not meet preset standard, otherwise determines that the corresponding testing result of network security index meets preset standard.
Preferably, data base's leader follower replication index include it is following at least one：Replication performance index and data safety Index；Wherein：
For replication performance index, according to the corresponding achievement data of replication performance index of collection, if default the 8th In cycle duration, slave replica delay more than the 6th predetermined threshold value duration more than the 4th preset ratio, it is determined that replicate The corresponding testing result of performance indications does not meet preset standard；Otherwise, it determines the corresponding testing result of replication performance index meets Preset standard；
For data safety index, according to the corresponding achievement data of data safety index of collection, slave configuration is judged Whether position acquisition parameter enables, if it is, determining that the corresponding testing result of data safety index meets preset standard；It is no Then, determine that the corresponding testing result of data safety index does not meet preset standard.
Preferably, the user accesses data index include it is following at least one：Deadlock index and slow inquiry index；Its In：
For deadlock index, according to the corresponding achievement data of deadlock index of collection, count in the 8th predetermined period duration Interior deadlock number of times, if the deadlock number of times that statistics is obtained is more than the 7th predetermined threshold value, it is determined that the corresponding detection of deadlock index As a result preset standard is not met；Otherwise, it determines the corresponding testing result of deadlock index meets preset standard；
For slow inquiry index, according to the corresponding achievement data of slow inquiry index of collection, count in the 9th predetermined period In duration, inquiry response is delayed over the slow inquiry times of pre-set delay threshold value, more than the slow inquiry times that obtain of statistics more than the Eight predetermined threshold values, it is determined that the slow corresponding testing result of index of inquiring about does not meet preset standard；Otherwise, it determines inquiring about index pair slowly The testing result answered meets preset standard.
In the second aspect of embodiment of the present invention, there is provided a kind of database detection device, including：
Collecting unit, for according to default database detection index, gathering each database detection index correspondence respectively Achievement data；
Comparing unit, for each database detection index corresponding achievement data corresponding examination criteria is carried out Relatively, obtain the corresponding testing result of each database detection index；
Detector unit, for according to the corresponding testing result of each database detection index, obtaining database detection Comprehensive grading；
Display unit, for showing the comprehensive grading of the database detection.
Alternatively, database detection device provided in an embodiment of the present invention, also including the first determining unit, wherein：
First determining unit, for before the comprehensive grading that the display unit shows the database detection, According to the comprehensive grading of the database detection, it is determined that sequence knot of the current detected data storehouse in the data base for participating in detection Really；
The display unit, for while the database detection comprehensive grading is shown, also showing that basis is determined The current detected data storehouse that obtains of ranking results and the data bases of other participation detections lateral comparison result.
Alternatively, database detection device provided in an embodiment of the present invention, also includes：
Identifying unit, for for each database detection index, if the testing result of the database detection index is Preset standard is not met, then judges that the corresponding database detection index of the testing result is unqualified；
Second determining unit, if judging that at least one database detection index is unqualified for the identifying unit, really Detected data stock is determined in risk.
Preferably, the detector unit, specifically for for each database detection index, according to each database detection The corresponding standard of deducting point of the testing result of index, carries out the comprehensive grading that accumulated deduction obtains the database detection.
Alternatively, database detection device provided in an embodiment of the present invention, also including the 3rd determining unit, wherein：
3rd determining unit, for before the comprehensive grading that the display unit shows the database detection, According to the comprehensive grading of the database detection, the corresponding risk class in detected data storehouse is determined；
The display unit, it is corresponding specifically for determined according to the 3rd determining unit, detected data storehouse Risk class, using corresponding color pattern displaying described in database detection comprehensive grading.
Preferably, the display unit, is additionally operable to while the database detection comprehensive grading is shown, showing every One unqualified data base's Testing index.
Alternatively, database detection device provided in an embodiment of the present invention, also includes：
The link page sets up unit, for for the unqualified data base's Testing index of each item, setting up the number of non-compliances evidence Link of the storehouse Testing index to risk details page, the risk details page are used for showing unqualified data base's Testing index Corresponding risk description information and/or reparation advisory information.
Preferably, the database detection index include it is following at least one：Database table Index Design index, data base Parameter configuration index, database volume planning index, database service safety index, data base's leader follower replication index and user visit Ask data target.
Preferably, the comparing unit, specifically for for the database table Index Design index, according to below scheme Obtain its corresponding testing result：According to the corresponding achievement data of database table Index Design index of collection, data base is judged With the presence or absence of following at least one index in table index：Major key index, redundancy index, invalid index and poorly efficient index；If it is, Then determine that the corresponding testing result of database table Index Design index does not meet preset standard；If it is not, then determining database table The corresponding testing result of Index Design index meets preset standard.
Preferably, the database parameter distribu-tion index include it is following at least one：Binary log parameter configuration index, Redo log parameter configuration index, service connection parameter configuration index and memory parameters distribu-tion index, the memory parameters configuration Index includes the shared parameter configuration index of example and the exclusive parameter configuration index of connection；
The comparing unit, specifically for for the binary log parameter configuration index, obtaining according to below scheme Its corresponding testing result：According to the corresponding achievement data of binary log parameter configuration index of collection, it is determined that pre- first The mean size if binary log produced in cycle duration takes up room；If it is determined that remaining space size is less than described first The binary log produced in predetermined period duration takes up room mean size, it is determined that the binary log parameter configuration refers to Mark corresponding testing result and do not meet preset standard；Otherwise, it determines the corresponding detection of the binary log parameter configuration index As a result meet preset standard；Parameter configuration index is redo log for described, its corresponding detection knot is obtained according to below scheme Really：Whether judge detected data storehouse redoes log the corresponding achievement data of parameter configuration index more than the first predetermined threshold value, Preset standard is not met if it is, determining and redoing log the corresponding testing result of parameter configuration index；Otherwise, it determines reforming day The corresponding testing result of will parameter configuration index meets preset standard, and first predetermined threshold value is for different disk spaces The preset value that size is determined；For the service connection parameter configuration index, its corresponding detection is obtained according to below scheme As a result：According to the corresponding achievement data of service connection parameter configuration index of collection, service connection volume peaks or the is judged Whether the average traffic connection quantity in two predetermined period durations exceedes default maximum traffic connects quantity；If it is, really Determine the corresponding testing result of service connection parameter configuration index and do not meet preset standard；Otherwise, it determines service connection parameter configuration The corresponding testing result of index meets preset standard；For the memory parameters distribu-tion index, which is obtained according to below scheme right The testing result answered：According to collection the corresponding achievement data of memory parameters distribu-tion index, determine service connection volume peaks and Whether the product of the exclusive parameter value of connection is more than physical memory size with the shared parameter value sum of example；If it is, in determining Deposit the corresponding testing result of parameter configuration index and do not meet preset standard, otherwise, it determines the corresponding detection knot of memory parameters configuration Fruit meets preset standard.
Preferably, the database volume planning index include it is following at least one：Central processing unit CPU capacity planning Index, read/write I/O capacity planning index, memory size planning index, network bandwidth capacity planning index and storage space volume Planning index；
The comparing unit, specifically for for database volume planning index, obtaining which according to below scheme corresponding Testing result：According to the corresponding achievement data of CPU capacity planning index of collection, cpu busy percentage peak value or the 3rd pre- is determined If the CPU average utilizations in cycle duration；If the cpu busy percentage peak value or the CPU in the 3rd predetermined period duration Average utilization is more than the second predetermined threshold value, it is determined that the corresponding testing result of CPU capacity planning index does not meet preset standard, Otherwise determine that the corresponding testing result of CPU capacity planning index meets preset standard；And refer to for the I/O capacity plannings Mark, obtains its corresponding testing result according to below scheme：According to the corresponding achievement data of I/O capacity planning indexs of collection, If it is determined that in the 4th predetermined period duration, I/O utilization rates are default more than first more than the duration of the 3rd predetermined threshold value Ratio, it is determined that the corresponding testing result of I/O capacity planning indexs does not meet preset standard；Otherwise, it determines I/O capacity plannings refer to Mark corresponding testing result and meet preset standard；And the memory size planning index is directed to, which is obtained according to below scheme Corresponding testing result：According to the corresponding achievement data of memory size planning index of collection, if it is determined that in the 5th default week Phase duration internal memory mean hit rate is less than the 4th predetermined threshold value, it is determined that the corresponding testing result of memory size planning index is not inconsistent Close preset standard；Otherwise, it determines the corresponding testing result of memory size planning index meets preset standard；It is tolerant for Netowrk tape Amount planning index, obtains its corresponding testing result according to below scheme：According to the network bandwidth capacity planning index pair of collection The achievement data answered, if it is determined that in the 6th predetermined period duration, network bandwidth utilization factor is held more than the 5th predetermined threshold value Continuous duration is more than the second preset ratio, it is determined that the corresponding testing result of network bandwidth capacity planning index does not meet pre- bidding It is accurate；Otherwise, it determines the corresponding testing result of network bandwidth capacity planning index meets preset standard；Advise for storage space volume Index is drawn, and its corresponding testing result is obtained according to below scheme：It is corresponding according to the storage space volume planning index of collection Achievement data, determines usage trend of the memory space in the 7th predetermined period duration, is estimated according to the usage trend determined The use demand of memory space；If memory space residual capacity meets the use demand, it is determined that the memory space holds The corresponding testing result of amount planning index meets preset standard, otherwise, it determines the corresponding detection of storage space volume planning index As a result preset standard is not met.
Preferably, the database service safety index include it is following at least one：Cipher Strength index, it is periodically detected Index, scope check index and network security index；
The comparing unit, specifically for for Cipher Strength index, according to the corresponding finger of Cipher Strength index of collection According to preset rules, mark data, if judge that the Cipher Strength that user is arranged is low, it is determined that the corresponding inspection of Cipher Strength index Survey result and do not meet preset standard, otherwise determine that the corresponding testing result of Cipher Strength index meets preset standard；For the cycle Property Testing index, according to collection be periodically detected the corresponding achievement data of index, if it is determined that user is not carried out to data base It is periodically detected, it is determined that be periodically detected the corresponding testing result of index and do not meet preset standard, otherwise determines Survey the corresponding testing result of index and meet preset standard；For scope check index, according to the scope check index correspondence of collection Achievement data, obtain the authority information of the user for accessing detected data storehouse, if the number of users of high authority is more than the 3rd Preset ratio, it is determined that the corresponding testing result of scope check index does not meet preset standard, and otherwise define the competence Index for examination Corresponding testing result meets preset standard；For network security index, according to the corresponding index of network security index of collection Data, if be not provided with the network address information of network firewall and/or non-limited-access data storehouse user, it is determined that network is pacified Preset standard is not met all referring to corresponding testing result is marked, otherwise determines that the corresponding testing result of network security index meets default Standard.
Preferably, data base's leader follower replication index include it is following at least one：Replication performance index and data safety Index；
The comparing unit, specifically for for replication performance index, according to the corresponding finger of replication performance index of collection Mark data, if in the 8th predetermined period duration, slave replica delay more than the 6th predetermined threshold value duration more than the Four preset ratios, it is determined that the corresponding testing result of replication performance index does not meet preset standard；Otherwise, it determines replication performance refers to Mark corresponding testing result and meet preset standard；For data safety index, according to the corresponding finger of data safety index of collection Mark data, judge whether the position acquisition parameter of slave configuration enables, if it is, determining the corresponding detection of data safety index As a result meet preset standard；Otherwise, it determines the corresponding testing result of data safety index does not meet preset standard.
Preferably, the user accesses data index include it is following at least one：Deadlock index and slow inquiry index；
The comparing unit, specifically for for deadlock index, according to the corresponding achievement data of deadlock index of collection, system The deadlock number of times in the 8th predetermined period duration is counted, if the deadlock number of times that obtains of statistics is more than the 7th predetermined threshold value, really Fix the corresponding testing result of lock index and do not meet preset standard；Otherwise, it determines the corresponding testing result of deadlock index meets pre- Bidding is accurate；For slow inquiry index, according to the corresponding achievement data of slow inquiry index of collection, count in nine predetermined periods In long, inquiry response is delayed over the slow inquiry times of pre-set delay threshold value, and the slow inquiry times obtained more than statistics are more than the 8th Predetermined threshold value, it is determined that the slow corresponding testing result of index of inquiring about does not meet preset standard；Otherwise, it determines inquiry index is corresponding slowly Testing result meet preset standard.
In the third aspect of embodiment of the present invention, there is provided a kind of database detection device, for example, can include depositing Reservoir and processor, wherein, processor can be used for reading the program in memorizer, perform following process：According to default number According to storehouse Testing index, the corresponding achievement data of each database detection index is gathered respectively；By each database detection index pair The corresponding examination criteria of the achievement data answered is compared, and obtains the corresponding testing result of each database detection index； According to the corresponding testing result of each database detection index, the comprehensive grading of database detection is obtained, and shows described The comprehensive grading of database detection.
In the fourth aspect of embodiment of the present invention, there is provided a kind of program product, which includes program code, when described When program product runs, described program code is used for performing procedure below：According to default database detection index, gather respectively The corresponding achievement data of each database detection index；Will be each database detection index corresponding achievement data corresponding Examination criteria is compared, and obtains the corresponding testing result of each database detection index；According to each database detection The corresponding testing result of index, obtains the comprehensive grading of database detection, and shows the comprehensive grading of the database detection.
According to the database detection method and apparatus of embodiment of the present invention, for the different data base's inspection of data lab setting Survey index and gather corresponding achievement data, carry out detecting according to the examination criteria for arranging for each database detection index To corresponding testing result, and database generalization is obtained according to testing result score and present, can so cause user according to Testing result is optimized respectively for different data base's indexs, it is to avoid the risk of the omission such as manual inspection, it is ensured that number The safety and stability used according to storehouse, improves Database server performance, is that user brings preferably experience.
Description of the drawings
Detailed description below, above-mentioned and other mesh of exemplary embodiment of the invention are read by reference to accompanying drawing , feature and advantage will become prone to understand.In the accompanying drawings, if showing the present invention's by way of example, and not by way of limitation Dry embodiment, wherein：
Fig. 1 schematically shows the application scenarios schematic diagram according to embodiment of the present invention；
Fig. 2 schematically shows the database detection method flow schematic diagram according to embodiment of the present invention；
Fig. 3 schematically shows and schematic diagram is presented according to the first database detection result of embodiment of the present invention；
Fig. 4 schematically shows and schematic diagram is presented according to second database detection result of embodiment of the present invention；
Fig. 5 schematically shows and schematic diagram is presented according to the third database detection result of embodiment of the present invention；
Fig. 6 schematically shows the database detection apparatus structure schematic diagram according to embodiment of the present invention；
Fig. 7 schematically shows the structural representation of the database detection device according to another embodiment of the invention；
Fig. 8 schematically shows the program product schematic diagram for database detection according to embodiment of the present invention；
In the accompanying drawings, identical or corresponding label represents identical or corresponding part.
Specific embodiment
The principle and spirit of the present invention are described below with reference to some illustrative embodiments.It should be appreciated that providing this Just for the sake of making, those skilled in the art better understood when a little embodiments and then realization is of the invention, and not with any Mode limits the scope of the present invention.Conversely, these embodiments are provided so that the disclosure is more thorough and complete, and energy It is enough that the scope of the present disclosure is intactly conveyed to those skilled in the art.
One skilled in the art will appreciate that embodiments of the present invention can be implemented as a kind of system, device, equipment, method Or computer program.Therefore, the disclosure can be implemented as following form, i.e.,：Completely hardware, completely software (including firmware, resident software, microcode etc.), or the form that hardware and software is combined.
According to the embodiment of the present invention, it is proposed that a kind of database detection method and apparatus.
Herein, any number of elements in accompanying drawing is used to example and unrestricted, and any name is only used for Distinguish, not with any limitation.
Below with reference to some representative embodiments of the present invention, the in detail principle and spirit of the explaination present invention.
Summary of the invention
The inventors discovered that, during the operation and maintenance of data base, a kind of mode is to data by the DBA of specialty Storehouse is checked, but this is overly dependent upon the technical merit and experience of DBA, and easily occurs omitting so that data base makes With there is certain risk, another mode be using publicly-owned cloud service, but the data base that publicly-owned cloud service is provided uses Ensure mainly for physical hardware devices failure, and be not for data base's design and provide safeguard in itself, it can be seen that, no matter which The mode of kind, cannot ensure the safety and stability during data base's use, reduce database performance.
In view of this, in the embodiment of the present invention, multinomial database detection index is designed for data base, and gather each item number According to the corresponding achievement data of storehouse Testing index, for each association database Testing index, by the achievement data of collection and setting Examination criteria relatively obtains corresponding testing result, determines the comprehensive grading in detected data storehouse and presents according to result is detected To user, so, it is to avoid the risk of the omission such as manual inspection, it is ensured that the safety and stability that data base uses, improve Database server performance；Further, can with video data storehouse detection neutralization scoring while, display to the user that and deposit In data base's index of risk so that user can be optimized for risky data base's index, it is ensured that data base uses Stability.
After the ultimate principle for describing the present invention, lower mask body introduces the various non-limiting embodiment party of the present invention Formula.
Application scenarios overview
With reference first to Fig. 1, which is the application scenarios schematic diagram of database detection method provided in an embodiment of the present invention.User 10 are configured and are managed to data base 12 by management terminal 11, and in the embodiment of the present invention, user 10 can also be by management Terminal 11 is detected to data base 12.Management terminal 11 is according to the corresponding index of database detection index collection for pre-setting Data, and compared according to the achievement data examination criteria corresponding with the Testing index of collection, obtain the Testing index corresponding Testing result, wherein, it is qualified and unqualified that the testing result of each Testing index is divided into, if unqualified, can be according to inspection Survey the corresponding standard of deducting point of result to be deducted points, all achievement data accumulated deductions finally give detected data storehouse Comprehensive grading.
When being embodied as, management terminal 11 can be to be connected with network side server 13, by the comprehensive grading of data base Offer network side server 13, it is that network side server 13 is reported according to different management terminals 11, be detected for different Lateral comparison result between data base simultaneously feeds back to management terminal 11, and the number with other participation detections is presented by management terminal 11 According to the lateral comparison result in storehouse.
Wherein, management terminal 11 and server 13 are communicatively coupled by network, and the network can be LAN, wide area Net etc..Management terminal 11 can be PC (PC, Personal Computer), server 13 can for it is any can be with The server apparatus communicated by management terminal 11.Additionally, data base itself can also configure detection instrument, detection instrument is according to pre- The corresponding achievement data of database detection index collection for first arranging, and it is corresponding with the Testing index according to the achievement data of collection Examination criteria compare, obtain the corresponding testing result of the Testing index, wherein, the testing result of each Testing index is divided into conjunction Lattice and unqualified, if unqualified, can be deducted points according to the corresponding standard of deducting point of testing result, all index numbers According to accumulated deduction, the comprehensive grading in detected data storehouse is finally given.The detection instrument of data base itself can be taken with network side Business device 13 connects and for the comprehensive grading of data base to report network side server 13, and network side server 13 is according to different data It is that storehouse detection instrument is reported, for the lateral comparison result between different detected data storehouses and feed back to user terminal, by User terminal is presented the lateral comparison result with the data base of other participation detections.
Illustrative methods
With reference to the application scenarios of Fig. 1, it is described with reference to Figure 2 and is examined according to the data base of exemplary embodiment of the invention Survey method.It should be noted that above-mentioned application scenarios are for only for ease of and understand spirit and principles of the present invention and illustrates, this Bright embodiment is unrestricted in this regard.Conversely, embodiments of the present invention can apply to applicable any field Scape.
As shown in Fig. 2 which is the implementation process diagram of database detection method provided in an embodiment of the present invention, can wrap Include following steps：
S21, according to default database detection index, gather the corresponding index number of each database detection index respectively According to.
In the embodiment of the present invention, the database risk being currently known is classified as into 6 big class, is set for each class risk respectively Corresponding database detection index is counted, difference is as follows：Database table Index Design index, database parameter distribu-tion index, data Storage capacity planning index, database service safety index, data base's leader follower replication index and user accesses data index.Accordingly Ground, when detecting to data base, can gather the above at least one corresponding achievement data of data base's index.Implement according to figure When, according to actual needs, can also be for certain association database index and the sub- index of database detection can also be set, for there is number The database detection index of sub- index is detected according to storehouse, achievement data corresponding for the sub- index collection of each association database is needed.
S22, each database detection index corresponding achievement data corresponding examination criteria is compared, is obtained The corresponding testing result of each database detection index.
When being embodied as, for each database detection index, according to the achievement data of collection by itself and default detection Standard is compared, and judges whether which meets preset standard, if met, judges the corresponding detection of database detection index As a result it is qualified, if not meeting examination criteria, judge that the corresponding testing result of database detection index is unqualified, if extremely The corresponding testing result of one item missing database detection index is unqualified, it is determined that detected data stock is in risk.
S23, according to the corresponding testing result of each database detection index, the synthesis for obtaining database detection is commented Point, and show the comprehensive grading of the database detection.
In this step, according to the corresponding standard of deducting point of the corresponding testing result of each association database Testing index, pin Carry out accumulated deduction and obtain the synthesis of detected data commenting to each association database Testing index or the sub- index of database detection Point.For example, it is assumed that standard of deducting point is to be deducted points for not meeting the Testing index of examination criteria, benchmark is divided into 100 points, often examines 2 points of a sub- index button of database detection index or database detection for not meeting examination criteria is measured, is then opened from 100 points Begin, often detect 2 points of a sub- index button of data base's index or database detection for not meeting examination criteria, to each item data Storehouse index or the sub- index of database detection carry out accumulated deduction, and after the completion of database detection, Residual fraction is this secondary data Detect corresponding comprehensive grading in storehouse.Standard of deducting point is it can also be provided that other standard of deducting point, of the invention that this is not construed as limiting.
Below for each association database Testing index designed in the embodiment of the present invention, introduce respectively and obtain the data base The method of the corresponding testing result of Testing index.
First, database table Index Design index.
For database table Index Design index, common tables of data Index Design problem mainly includes that major key index lacks Mistake, redundancy index, invalid index and poorly efficient index.Wherein, for major key index is lacked, if user creates clustered index table Leader follower replication can be caused to postpone without Explicit designation major key, while the insertion performance of master library example can be affected；And for a rope The field for drawing the prefix or an index most end that are another index is major key, then occur that redundancy is indexed, increase index Maintenance cost, affects the insertion performance of example；And invalid index also can additionally increase the maintenance cost of index, after establishment Always no used index (the invalid index being related in the embodiment of the present invention) should be cleared up in time；Poorly efficient rope Draw：Data-base recording is to determine inquiry by indexing the key index for performing speed in the differentiation degree of index field, for area The not high index of indexing can affect data base querying execution efficiency.
Based on this, in the embodiment of the present invention, can be according to the corresponding index number of database table Index Design index of collection According to judging in database table index with the presence or absence of following at least one index：Major key index, redundancy index, it is invalid index and it is low , often there is a kind of index, then deduct corresponding score value in effect index, for example, if there is invalid index, then deduct 2 points, if also There is redundancy index, then deduct 2 points, that is, add up to deduct 4 points.Correspondingly, if it is judged that at least one more than existing index, then Determine that the corresponding testing result of database table Index Design index does not meet preset standard；If there is no any of the above rope Draw, it is determined that the corresponding testing result of database table Index Design index meets preset standard.Correspondingly, if database table sets Meter index meet preset standard, it is determined that database table design objective is qualified, if database table design objective do not meet it is default Standard, it is determined that database table design objective is unqualified.
2nd, database parameter distribu-tion index.
In the embodiment of the present invention, database parameter distribu-tion index can include it is following at least one：Binary log parameter Distribu-tion index, redo log parameter configuration index, service connection parameter configuration index and memory parameters distribu-tion index, the internal memory Parameter configuration index includes the shared parameter configuration index of example and the exclusive parameter configuration index of connection.
Wherein, for binary log parameter configuration index, the binary system that data base is produced during affairs read-write Daily record can be removed automatically according to the binary log parameter of configuration, if the parameter setting is excessive, binary log can be caused to account for With excessive memory space, hard disk remaining space is ultimately resulted in not enough；In addition, whether binary log is each when affairs are submitted to It is required for fsync (synchronization) hard disk also by corresponding state modulator, if not forcing fsync, may result in principal and subordinate's data Database data is inconsistent；The form of binary log also by corresponding state modulator, if not Row (OK) form, is also resulted in Principal and subordinate's data are inconsistent.
Based on this, in the embodiment of the present invention, for the binary log parameter configuration index, can be according to below scheme Obtain its corresponding testing result：According to the corresponding achievement data of binary log parameter configuration index of collection, it is determined that the The binary log produced in one predetermined period duration takes up room mean size；If it is determined that remaining space size is less than described The binary log produced in first predetermined period duration takes up room mean size, it is determined that the binary log parameter is matched somebody with somebody Put the corresponding testing result of index and do not meet preset standard；Otherwise, it determines the binary log parameter configuration index is corresponding Testing result meets preset standard.
For example, it is assumed that binary log parameter configuration is binary log of removing per 10 days, and according to the finger of collection Mark data determine that the mean space size shared by the binary log produced per 10 days is 2G, if present hard discs remaining space Less than 2G, then illustrate that the corresponding testing result of binary log parameter configuration index does not meet preset standard, otherwise, it determines two enter The corresponding testing result of log parameters distribu-tion index processed meets preset standard.
In addition, whether needing the parameter of fsync hard disks be configured to when affairs are submitted to every time for binary log Open, that is, force fsync, to keep the consistent of master-slave database.If determining that the parameter is not opened according to the achievement data of collection Open, it is determined that the Testing index does not meet preset standard, otherwise, it determines the Testing index meets preset standard.
Equally, for the parameter of the form of control binary log, it is also desirable to according to the corresponding achievement data of collection, sentence Whether disconnected binary log form meets requirement, if it is not, then determining the parameter index of the form of control binary log not Meet preset standard, otherwise, it determines the parameter index of the form of binary log meets preset standard.
For parameter configuration index is redo log, it is the parameter for redoing log size for control to redo log parameter, such as Really the parameter setting is excessive, can take excessive memory space, in addition, also result in database corruption to recover to need to spend more Time, affect service availability；If parameter setting is too small, database service can be caused intermittence hang (interim card) occur, Cannot access.Whether in addition, needing to redo log the parameter of brush when also including that each affairs of control are submitted to, the parameter is not strong Brush processed, can cause leader follower replication data inconsistent.
Based on this, in the embodiment of the present invention, parameter configuration index is redo log for described, can be obtained according to below scheme Obtain its corresponding testing result：
Judge detected data storehouse redoes log whether the corresponding achievement data of parameter configuration index is preset more than first Threshold value, does not meet preset standard if it is, determining and redoing log the corresponding testing result of parameter configuration index；Otherwise, it determines Redo log the corresponding testing result of parameter configuration index and meet preset standard, first predetermined threshold value is for different magnetic The preset value that disk space size is determined.
And for controlling whether to need to redo log the parameter of brush when each affairs are submitted to, if according to the finger of collection Mark data judging goes out the parameter and is set to redo log brush when each affairs are submitted to, it is determined that each affairs of control Whether need for the parameter index for redoing log brush not meeting preset standard during submission, otherwise, it determines each affairs of control are carried Whether need for the parameter index for redoing log brush to meet preset standard during friendship.
For service connection parameter configuration index, service connection parameter refers to data bank service connection number maximum, the ginseng Number is if it is, can cause using there is connection overflow problem, the parameter setting is excessive, it is possible to cause service end resource Exhaust, affect service availability.
Thus, in the embodiment of the present invention, for the service connection parameter configuration index, can obtain according to below scheme Its corresponding testing result：According to the corresponding achievement data of service connection parameter configuration index of collection, service connection number is judged Whether the average traffic connection quantity in amount peak value or the second predetermined period duration exceedes default maximum traffic connects quantity； If it is, determining that the corresponding testing result of service connection parameter configuration index does not meet preset standard；Otherwise, it determines business connects Connect the corresponding testing result of parameter configuration index and meet preset standard.
And for memory size planning index, databases capacity parameter includes the shared parameter of example and the exclusive ginseng of connection Number, the latter are multiplied by maximum number of connections and add the former, are exactly the maximum memory that data base can use, if it exceeds on physical memory Limit, the risk for just having internal memory to overflow.Based on this, in the embodiment of the present invention, its corresponding detection can be obtained according to below scheme As a result：According to the corresponding achievement data of memory parameters distribu-tion index of collection, determine that service connection volume peaks and connection are exclusive Whether the product of parameter value is more than physical memory size with the shared parameter value sum of example；If it is, determining that memory parameters are matched somebody with somebody Put the corresponding testing result of index and do not meet preset standard, otherwise, it determines memory parameters configure corresponding testing result meets pre- Bidding is accurate.
3rd, database volume planning index.
Database volume planning index include it is following at least one：It is CPU capacity planning index, I/O capacity planning indexs, interior Deposit capacity planning index, network bandwidth capacity planning index and storage space volume planning index.
For CPU capacity planning index primary concern is that cpu busy percentage, because if cpu busy percentage continues higher meeting Have a strong impact on the response time of data base querying.Based on this, in the embodiment of the present invention, CPU can be obtained according to below scheme and be held The corresponding testing result of amount planning index：According to the corresponding achievement data of CPU capacity planning index of collection, determine that CPU is utilized CPU average utilizations in rate peak value or the 3rd predetermined period duration；If the cpu busy percentage peak value or the 3rd is preset CPU average utilizations in cycle duration are more than the second predetermined threshold value, it is determined that the corresponding testing result of CPU capacity planning index Preset standard is not met, otherwise determines that the corresponding testing result of CPU capacity planning index meets preset standard.
For I/O (read/write) capacity planning index, as data base is typical I/O intensive applications, if I/O is sharp It is lasting higher with rate, the response time of data base querying can be also affected, in the embodiment of the present invention, can be obtained according to below scheme Its corresponding testing result：According to the corresponding achievement data of I/O capacity planning indexs of collection, if it is determined that in the 4th default week In phase duration, I/O utilization rates more than the 3rd predetermined threshold value duration more than the first preset ratio, it is determined that I/O capacity advise Draw the corresponding testing result of index and do not meet preset standard；Otherwise, it determines the corresponding testing result of I/O capacity planning indexs meets Preset standard.
For the memory size planning index, data base allocates internal memory in advance, weighs whether internal memory meets application The standard of demand should be the hit rate for checking memory buffer pond, if hit rate is too high, while SQL performs slack-off, Ke Yitong Cross exented memory resource and improve database performance.Therefore, in the embodiment of the present invention, for the memory size planning index, press Its corresponding testing result is obtained according to below scheme：According to the corresponding achievement data of memory size planning index of collection, if It is determined that being less than the 4th predetermined threshold value in the 5th predetermined period duration internal memory mean hit rate, it is determined that memory size planning index pair The testing result answered does not meet preset standard；Otherwise, it determines the corresponding testing result of memory size planning index meets pre- bidding It is accurate.
For network bandwidth capacity planning index, for the SQL of transmission big data quantity, the network bandwidth is likely to become impact number According to the bottleneck of storehouse performance.In the embodiment of the present invention, its corresponding testing result can be obtained according to below scheme：According to collection The corresponding achievement data of network bandwidth capacity planning index, if it is determined that in the 6th predetermined period duration, the network bandwidth are utilized Rate more than the 5th predetermined threshold value duration more than the second preset ratio, it is determined that network bandwidth capacity planning index is corresponding Testing result does not meet preset standard；Otherwise, it determines the corresponding testing result of network bandwidth capacity planning index meets pre- bidding It is accurate.
For storage space volume planning index, by the usage trend of one week memory space, using fitting algorithm, estimate Calculate whether following 3 days memory space meets data base's needs.If memory space inadequate, data base's machine of delaying can be caused to carry For service.In the embodiment of the present invention, its corresponding testing result can be obtained according to below scheme：According to the memory space of collection The corresponding achievement data of capacity planning index, determines usage trend of the memory space in the 7th predetermined period duration, according to true The usage trend made estimates the use demand of memory space；If memory space residual capacity meets the use demand, Determine that the corresponding testing result of the storage space volume planning index meets preset standard, otherwise, it determines storage space volume The corresponding testing result of planning index does not meet preset standard.
4th, database service safety index.
Database service safety index include it is following at least one：Cipher Strength index, be periodically detected index, authority inspection Look into index and network security index.
Wherein, Cipher Strength index, if the cryptosecurity grade that user is arranged is relatively low, can cause data base to exist and be let out The risk of dew, has a strong impact on the safety of data.In the embodiment of the present invention, for Cipher Strength index, according to the password of collection According to preset rules, the corresponding achievement data of intensity index, if judge that the Cipher Strength that user is arranged is low, it is determined that password The corresponding testing result of intensity index does not meet preset standard, otherwise determines that the corresponding testing result of Cipher Strength index meets pre- Bidding is accurate.
And for index is periodically detected, if timing does not check UP user to data base, risk is there is also, Therefore, in the embodiment of the present invention, the corresponding achievement data of index is periodically detected according to what is gathered, if it is determined that the non-logarithm of user It is periodically detected according to storehouse, it is determined that be periodically detected the corresponding testing result of index and do not meet preset standard, otherwise determine It is periodically detected the corresponding testing result of index and meets preset standard.
For scope check index, if the authority that the application permission for accessing data base that user is arranged possesses is excessive, can Can cause to delete the operation such as table by mistake, affect data safety.In the embodiment of the present invention, can be according to the scope check index pair of collection The achievement data answered, obtains the authority information of the user for accessing detected data storehouse, if the number of users of high authority is more than the Three preset ratios, it is determined that the corresponding testing result of scope check index does not meet preset standard, and the inspection that otherwise defines the competence refers to Mark corresponding testing result and meet preset standard.
For network security index, using the data base of public network access, if being not provided with fire wall, limited-access data The IP in storehouse and port, are very easy to cause data base to be subjected to network attack, while being likely to the risk for causing data base to reveal.Have In consideration of it, in the embodiment of the present invention, according to the corresponding achievement data of network security index of collection, if being not provided with network fire prevention Wall and/or the network address information of non-limited-access data storehouse user, it is determined that the corresponding testing result of network security index is not Meet preset standard, otherwise determine that the corresponding testing result of network security index meets preset standard.
5th, data base's leader follower replication index
Data base's leader follower replication index include it is following at least one：Replication performance index and data safety index.
For replication performance index, if the delay of leader follower replication slave is lasting too high, example master-slave swap can be not only threatened Time, will also result in the application of read and write abruption, read from database data and update delayed.For the problem, can be by opening simultaneously The solution that row is replicated, accelerates reproduction process.Based on this, during the present invention is implemented, for replication performance index, can be according to adopting The corresponding achievement data of replication performance index of collection, if in the 8th predetermined period duration, slave replica delay is more than the 6th The duration of predetermined threshold value is more than the 4th preset ratio, it is determined that the corresponding testing result of replication performance index does not meet default Standard；Otherwise, it determines the corresponding testing result of replication performance index meets preset standard.
For data safety index, the slave of leader follower replication is once restarted, need reacquire host log position and Slave plays back the position of binary log, if two positions are inaccurate, principal and subordinate's data can be caused inconsistent.Therefore, the present invention In embodiment, the position acquisition parameter of slave configuration can be judged according to the corresponding achievement data of data safety index of collection Whether enable, if it is, determining that the corresponding testing result of data safety index meets preset standard；Otherwise, it determines data peace Preset standard is not met all referring to corresponding testing result is marked.
6th, user accesses data index
User accesses data index include it is following at least one：Deadlock index and slow inquiry index.
Wherein, for deadlock index, if deadlock is excessive, illustrate that business procedure there are problems that holding lock order improperly, no The performance of data base can be only had a strong impact on, the affairs that will also result in impact program are forced rollback.Therefore, the embodiment of the present invention In, for deadlock index, according to the corresponding achievement data of deadlock index of collection, count dead in the 8th predetermined period duration Lock number of times, if the deadlock number of times that statistics is obtained is more than the 7th predetermined threshold value, it is determined that the corresponding testing result of deadlock index is not Meet preset standard；Otherwise, it determines the corresponding testing result of deadlock index meets preset standard.
For slow inquiry index, slow inquiry quantity is user's query execution speed most intuitively index, if inquired about slowly Many, user may need to add optimiged index query execution efficiency.In the embodiment of the present invention, for slow inquiry index, according to adopting The corresponding achievement data of slow inquiry index of collection, counts the inquiry response in the 9th predetermined period duration and is delayed over pre-set delay The slow inquiry times of threshold value, more than the slow inquiry times that obtain of statistics more than the 8th predetermined threshold value, it is determined that slow inquiry index pair The testing result answered does not meet preset standard；Otherwise, it determines the corresponding testing result of inquiry index meets preset standard slowly.
It should be noted that for each class index, if such index includes at least one index, when being embodied as, Preset standard is not met if there is at least one index, then can be determined that such index does not meet preset standard, i.e., such refers to Mark is unqualified, there is risk.
Data base is being carried out detecting that the synthesis for obtaining detected data storehouse is commented according to the database detection index of design / after, the comprehensive grading in detected data storehouse can also be sent to network side server, network side server is according to all The comprehensive grading of each data base of detection is participated in, it is determined that sequence knot of the current detected data storehouse in the data base for participating in detection Really, so, while comprehensive grading is detected in video data storehouse, also show the currently quilt obtained according to the ranking results determined The lateral comparison result of the data base that Test database is detected with other participations.
It is preferred that when being embodied as, can also be for each database detection index, deposited according to the database detection index Data base by classification of risks, for example, can be divided into by serious, warning and advised using the order of severity for affecting in risk.Its In, significantly larger than there is the number of warning risk and suggestion risk in the corresponding deduction of points of database detection index that there is serious risk According to the corresponding deduction of points of storehouse Testing index.It is divided into 100 points in the case of benchmark, if detecting that risk classifications are serious data base's inspection Index is surveyed, then directly deducts corresponding scores from basis point, it is assumed that for 40, if detecting risk classifications for warning and suggestion, Accumulated deduction is carried out according to above-mentioned accumulated deduction method then, finally be presented to user is an intuitively fraction, fraction is got over Height, represents that database risk is fewer, and fraction is lower, represents that database risk is more, needs to be repaired in time.Specifically, such as Shown in Fig. 3, user is presented a circular button when database detection is carried out by interactive interface, and user should by clicking on The detection of button trigger data storehouse starts, and round button is dispersed into big open circles, has a solid round dot with inspection Recommendation along empty circles rotate, be the comprehensive grading of database detection inside open circles, often detect a database detection Index, then deduct corresponding fraction according to standard of deducting point, until detection completes all of database detection index.
Description is needed, the pattern shown in Fig. 3 is only the preferred embodiment of the embodiment of the present invention, which is not constituted to this Bright restriction, when being embodied as, it would however also be possible to employ other modes are presented database detection result.
Preferably, in order that user is more visually known the order of severity of the detected data stock in risk, the present invention In embodiment, the corresponding risk class in detected data storehouse can be determined with the comprehensive grading according to database detection；So, In video data storehouse, the comprehensive grading of detection is according to determine, the corresponding risk class in detected data storehouse, using correspondingly face The comprehensive grading of database detection described in the pattern displaying of color.For example, if comprehensive grading is less than 60 timesharing, using red pattern Video data storehouse detection comprehensive grading, comprehensive grading between 60-85, using the synthesis of orange pattern displaying database detection Scoring, comprehensive grading more than 85 points, using green pattern video data storehouse detect comprehensive grading.
Preferably, while video data detects comprehensive grading, the unqualified data base's Testing index of each item is shown, such as Shown in Fig. 4, as such, it is possible to make user know the concrete database Testing index that there is risk, it is excellent so as to targetedly carry out Change.Meanwhile, for the unqualified data base's Testing index of each item, unqualified data base's Testing index is set up to risk details page The link in face, the risk details page be used for showing the corresponding risk description information of unqualified data base's Testing index and/ Or advisory information is repaired, as shown in Figure 5.
Database detection method provided in an embodiment of the present invention, for the different database detection index of data lab setting simultaneously Corresponding achievement data is gathered, detection is carried out according to the examination criteria for arranging for each database detection index and is obtained accordingly Testing result, and database generalization is obtained according to testing result score and present, user can be so caused according to testing result It is optimized for different data base's indexs respectively, it is to avoid the risk of the omission such as manual inspection, it is ensured that data base uses Safety and stability, improve Database server performance, be that user brings preferably experience.In order to drive user and Shi Xiufu risks, while database generalization scoring is presented, also add lateral comparison mechanism, complete in database detection Afterwards, the comprehensive grading according to detected data storehouse, is ranked up in all data bases for participating in detection according to comprehensive grading, and How many users defeated in Test database is participated in prompting user's detected data storehouse.
Example devices
After the method for describing exemplary embodiment of the invention, next, with reference to Fig. 6 to exemplary reality of the invention The data detection device for applying mode is illustrated.
As shown in fig. 6, which is the structural representation of database detection device provided in an embodiment of the present invention, can include：
Collecting unit 61, for according to default database detection index, gathering each database detection index pair respectively The achievement data answered；
Comparing unit 62, for each database detection index corresponding achievement data corresponding examination criteria is entered Row compares, and obtains the corresponding testing result of each database detection index；
Detector unit 63, for according to the corresponding testing result of each database detection index, obtaining data base's inspection The comprehensive grading of survey；
Display unit 64, for showing the comprehensive grading of the database detection.
Alternatively, database detection device provided in an embodiment of the present invention, can also include the first determining unit 65, its In：
First determining unit 65, for show in the display unit 64 database detection comprehensive grading it Before, according to the comprehensive grading of the database detection, it is determined that row of the current detected data storehouse in the data base for participating in detection Sequence result；
The display unit 64, for, while the database detection comprehensive grading is shown, also showing according to determination The lateral comparison result of the data base that the current detected data storehouse that the ranking results for going out are obtained is detected with other participations.
Alternatively, database detection device provided in an embodiment of the present invention, can also include：
Identifying unit 66, for for each database detection index, if the testing result of the database detection index For not meeting preset standard, then judge that the corresponding database detection index of the testing result is unqualified；
For the identifying unit 66, second determining unit 67, if judge that at least one database detection index does not conform to Lattice, determine detected data stock in risk.
Preferably, the detector unit 63, specifically for for each database detection index, examining according to each data base The corresponding standard of deducting point of the testing result of index is surveyed, the comprehensive grading that accumulated deduction obtains the database detection is carried out.
Alternatively, database detection device provided in an embodiment of the present invention, can also include the 3rd determining unit 68, its In：
3rd determining unit 68, for show in the display unit 64 database detection comprehensive grading it Before, according to the comprehensive grading of the database detection, determine the corresponding risk class in detected data storehouse；
The display unit 64, specifically for determined according to the 3rd determining unit 68, detected data storehouse pair The risk class answered, using corresponding color pattern displaying described in database detection comprehensive grading.
Alternatively, the display unit 64, is additionally operable to, while the database detection comprehensive grading is shown, show The unqualified data base's Testing index of each item.
Alternatively, database detection device provided in an embodiment of the present invention, can also include：
The link page sets up unit 69, for for the unqualified data base's Testing index of each item, setting up the number of non-compliances According to the link of storehouse Testing index to risk details page, the risk details page is used for showing that the unqualified database detection refers to Mark corresponding risk description information and/or repair advisory information.
Preferably, the database detection index include it is following at least one：Database table Index Design index, data base Parameter configuration index, database volume planning index, database service safety index, data base's leader follower replication index and user visit Ask data target.
The comparing unit 62, specifically for for the database table Index Design index, obtaining according to below scheme Its corresponding testing result：According to the corresponding achievement data of database table Index Design index of collection, database table rope is judged With the presence or absence of following at least one index in drawing：Major key index, redundancy index, invalid index and poorly efficient index；If it is, really Determine the corresponding testing result of data base's table index design objective and do not meet preset standard；If it is not, then determining database table index The corresponding testing result of design objective meets preset standard.
Preferably, the database parameter distribu-tion index include it is following at least one：Binary log parameter configuration index, Redo log parameter configuration index, service connection parameter configuration index and memory parameters distribu-tion index, the memory parameters configuration Index includes the shared parameter configuration index of example and the exclusive parameter configuration index of connection；
The comparing unit 62, specifically for for the binary log parameter configuration index, obtaining according to below scheme Obtain its corresponding testing result：According to the corresponding achievement data of binary log parameter configuration index of collection, it is determined that first The binary log produced in predetermined period duration takes up room mean size；If it is determined that remaining space size is less than described the The binary log produced in one predetermined period duration takes up room mean size, it is determined that the binary log parameter configuration The corresponding testing result of index does not meet preset standard；Otherwise, it determines the corresponding inspection of the binary log parameter configuration index Survey result and meet preset standard；Parameter configuration index is redo log for described, its corresponding detection is obtained according to below scheme As a result：Whether judge detected data storehouse redoes log the corresponding achievement data of parameter configuration index more than the first default threshold Value, does not meet preset standard if it is, determining and redoing log the corresponding testing result of parameter configuration index；Otherwise, it determines weight Do the corresponding testing result of log parameters distribu-tion index and meet preset standard, first predetermined threshold value is for different disks The preset value that space size is determined；For the service connection parameter configuration index, which is obtained according to below scheme corresponding Testing result：According to collection the corresponding achievement data of service connection parameter configuration index, judge service connection volume peaks or Whether the average traffic connection quantity in person's the second predetermined period duration exceedes default maximum traffic connects quantity；If it is, Then determine that the corresponding testing result of service connection parameter configuration index does not meet preset standard；Otherwise, it determines service connection parameter The corresponding testing result of distribu-tion index meets preset standard；For the memory parameters distribu-tion index, obtain according to below scheme Its corresponding testing result：According to the corresponding achievement data of memory parameters distribu-tion index of collection, service connection quantity peak is determined Whether the product of value and the exclusive parameter value of connection is more than physical memory size with the shared parameter value sum of example；If it is, really Determine the corresponding testing result of memory parameters distribu-tion index and do not meet preset standard, otherwise, it determines memory parameters configure corresponding inspection Survey result and meet preset standard.
Preferably, the database volume planning index include it is following at least one：Central processing unit CPU capacity planning Index, read/write I/O capacity planning index, memory size planning index, network bandwidth capacity planning index and storage space volume Planning index；
The comparing unit 62, specifically for for database volume planning index, obtaining its correspondence according to below scheme Testing result：According to the corresponding achievement data of CPU capacity planning index of collection, cpu busy percentage peak value or the 3rd is determined CPU average utilizations in predetermined period duration；If in the cpu busy percentage peak value or the 3rd predetermined period duration CPU average utilizations are more than the second predetermined threshold value, it is determined that the corresponding testing result of CPU capacity planning index does not meet pre- bidding Standard, otherwise determines that the corresponding testing result of CPU capacity planning index meets preset standard；And it is directed to the I/O capacity plannings Index, obtains its corresponding testing result according to below scheme：According to the corresponding index number of I/O capacity planning indexs of collection According to, if it is determined that in the 4th predetermined period duration, I/O utilization rates are pre- more than first more than the duration of the 3rd predetermined threshold value If ratio, it is determined that the corresponding testing result of I/O capacity planning indexs does not meet preset standard；Otherwise, it determines I/O capacity plannings The corresponding testing result of index meets preset standard；And the memory size planning index is directed to, obtain according to below scheme Its corresponding testing result：According to the corresponding achievement data of memory size planning index of collection, if it is determined that default the 5th Cycle duration internal memory mean hit rate is less than the 4th predetermined threshold value, it is determined that the corresponding testing result of memory size planning index is not Meet preset standard；Otherwise, it determines the corresponding testing result of memory size planning index meets preset standard；For the network bandwidth Capacity planning index, obtains its corresponding testing result according to below scheme：According to the network bandwidth capacity planning index of collection Corresponding achievement data, if it is determined that in the 6th predetermined period duration, network bandwidth utilization factor is more than the 5th predetermined threshold value Duration is more than the second preset ratio, it is determined that the corresponding testing result of network bandwidth capacity planning index does not meet pre- bidding It is accurate；Otherwise, it determines the corresponding testing result of network bandwidth capacity planning index meets preset standard；Advise for storage space volume Index is drawn, and its corresponding testing result is obtained according to below scheme：It is corresponding according to the storage space volume planning index of collection Achievement data, determines usage trend of the memory space in the 7th predetermined period duration, is estimated according to the usage trend determined The use demand of memory space；If memory space residual capacity meets the use demand, it is determined that the memory space holds The corresponding testing result of amount planning index meets preset standard, otherwise, it determines the corresponding detection of storage space volume planning index As a result preset standard is not met.
Preferably, the database service safety index include it is following at least one：Cipher Strength index, it is periodically detected Index, scope check index and network security index；
The comparing unit 62, it is specifically for for Cipher Strength index, corresponding according to the Cipher Strength index of collection According to preset rules, achievement data, if judge that the Cipher Strength that user is arranged is low, it is determined that Cipher Strength index is corresponding Testing result does not meet preset standard, otherwise determines that the corresponding testing result of Cipher Strength index meets preset standard；For week Phase property Testing index, is periodically detected the corresponding achievement data of index according to what is gathered, if it is determined that user does not enter to data base Line period is detected, it is determined that is periodically detected the corresponding testing result of index and is not met preset standard, is otherwise determined periodically The corresponding testing result of Testing index meets preset standard；For scope check index, according to the scope check index pair of collection The achievement data answered, obtains the authority information of the user for accessing detected data storehouse, if the number of users of high authority is more than the Three preset ratios, it is determined that the corresponding testing result of scope check index does not meet preset standard, and the inspection that otherwise defines the competence refers to Mark corresponding testing result and meet preset standard；For network security index, according to the corresponding finger of network security index of collection Mark data, if be not provided with the network address information of network firewall and/or non-limited-access data storehouse user, it is determined that network The corresponding testing result of safety index does not meet preset standard, otherwise determines that the corresponding testing result of network security index meets pre- Bidding is accurate.
Preferably, data base's leader follower replication index include it is following at least one：Replication performance index and data safety Index；
The comparing unit 62, it is specifically for for replication performance index, corresponding according to the replication performance index of collection Achievement data, if in the 8th predetermined period duration, slave replica delay exceedes more than the duration of the 6th predetermined threshold value 4th preset ratio, it is determined that the corresponding testing result of replication performance index does not meet preset standard；Otherwise, it determines replication performance The corresponding testing result of index meets preset standard；It is for data safety index, corresponding according to the data safety index of collection Achievement data, judges whether the position acquisition parameter of slave configuration enables, if it is, determining the corresponding inspection of data safety index Survey result and meet preset standard；Otherwise, it determines the corresponding testing result of data safety index does not meet preset standard.
Preferably, the user accesses data index include it is following at least one：Deadlock index and slow inquiry index；
The comparing unit 62, specifically for for deadlock index, according to the corresponding achievement data of deadlock index of collection, The deadlock number of times in the 8th predetermined period duration is counted, if the deadlock number of times that statistics is obtained is more than the 7th predetermined threshold value, Determine that the corresponding testing result of deadlock index does not meet preset standard；Otherwise, it determines the corresponding testing result of deadlock index meets Preset standard；For slow inquiry index, according to the corresponding achievement data of slow inquiry index of collection, count in the 9th predetermined period In duration, inquiry response is delayed over the slow inquiry times of pre-set delay threshold value, more than the slow inquiry times that obtain of statistics more than the Eight predetermined threshold values, it is determined that the slow corresponding testing result of index of inquiring about does not meet preset standard；Otherwise, it determines inquiring about index pair slowly The testing result answered meets preset standard.
After the method and notice device for describing exemplary embodiment of the invention, next, introducing according to this The database detection device of bright another exemplary embodiment.
Person of ordinary skill in the field it is understood that various aspects of the invention can be implemented as system, method or Program product.Therefore, various aspects of the invention can be implemented as following form, i.e.,：Completely hardware embodiment, complete Full Software Implementation (including firmware, microcode etc.), or the embodiment combined in terms of hardware and software, can be united here Referred to as " circuit ", " module " or " system ".
In some possible embodiments, database detection device of the invention can at least include at least one Processing unit and at least one memory element.Wherein, the memory element has program stored therein code, when described program code When being performed by the processing unit so that the processing unit is performed described in above-mentioned " illustrative methods " part of this specification According to the step in the database detection method of various illustrative embodiments of the invention.For example, the processing unit can be held Row as shown in Figure 2 the step of S21, according to default database detection index, gather each database detection index pair respectively The achievement data answered, and step S22, each database detection index corresponding achievement data corresponding examination criteria is entered Row compares, and obtains the corresponding testing result of each database detection index, step S23, is referred to according to each database detection Corresponding testing result is marked, the comprehensive grading of database detection is obtained, and is shown the comprehensive grading of the database detection.
The database detection device 70 of this embodiment of the invention is described referring to Fig. 7.What Fig. 7 showed Database detection device 70 is only an example, should not bring any limit to the function of the embodiment of the present invention and use range System.
As shown in fig. 7, database detection device 70 is showed in the form of universal computing device.Database detection device 70 Component can be including but not limited to：At least one processing unit 71, at least one memory element 72, connection different system component The bus 73 of (including memory element 72 and processing unit 71).
Bus 73 represents one or more in a few class bus structures, including memory bus or Memory Controller, Peripheral bus, processor or using various bus structures in any bus-structured local bus.
Memory element 72 can include the computer-readable recording medium of form of volatile memory, such as random access memory (RAM) 721 and/or cache memory 722, can further include read only memory (ROM) 723.
Memory element 72 can also include the program/utility 725 with one group of (at least one) program module 724, Such program module 724 is included but is not limited to：Operating system, one or more application program, other program modules and Routine data, potentially includes the realization of network environment in each or certain combination in these examples.
Database detection device 70 can also be logical with one or more external equipments 74 (such as keyboard, sensing equipment etc.) Letter, can also enable a user to the equipment communication that interact with database detection device 70 with one or more, and/or with cause this Any equipment (such as router, modulatedemodulate that data detection device 70 can be communicated with one or more of the other computing device Adjust device etc.) communication.This communication can be carried out by input/output (I/O) interface 75.Also, database detection device 70 Can also be by network adapter 76 and one or more network (such as LAN (LAN), wide area network (WAN) and/or public Network, such as the Internet) communication.As illustrated, network adapter 76 passes through other of bus 73 and database detection device 70 Module communicates.It should be understood that although not shown in other hardware and/or soft can be used with reference to data base's detection means 70 Part module, including but not limited to：Microcode, device driver, redundant processing unit, external disk drive array, RAID system, Tape drive and data backup storage system etc..
Exemplary process product
In some possible embodiments, various aspects of the invention are also implemented as a kind of shape of program product Formula, which includes program code, and when described program product is run on the terminal device, described program code is used for making the terminal Equipment performs the number according to various illustrative embodiments of the invention described in above-mentioned " illustrative methods " part of this specification According to the step in detection method, for example, the step of terminal unit can be performed as shown in Figure 2 S21, according to default number According to storehouse Testing index, gather the corresponding achievement data of each database detection index respectively, and step S22, by each data base The corresponding examination criteria of the corresponding achievement data of Testing index is compared, and obtains each database detection index corresponding Testing result, step S23, according to the corresponding testing result of each database detection index obtain the comprehensive of database detection Scoring is closed, and shows the comprehensive grading of the database detection.
Described program product can be using the combination in any of one or more computer-readable recording mediums.Computer-readable recording medium can be readable letter Number medium or readable storage medium storing program for executing.Readable storage medium storing program for executing can for example be but not limited to electricity, magnetic, optical, electromagnetic, red The system of outside line or quasiconductor, device or device, or combination arbitrarily above.The more specifically example of readable storage medium storing program for executing (non exhaustive list) includes：Electrical connection with one or more wires, portable disc, hard disk, random access memory (RAM), read only memory (ROM), erasable programmable read only memory (EPROM or flash memory), optical fiber, portable compact disc Read memorizer (CD-ROM), light storage device, magnetic memory device or above-mentioned any appropriate combination.
As shown in figure 8, describing the program product 80 for database detection according to the embodiment of the present invention, which can With using portable compact disc read only memory (CD-ROM) and including program code, it is possible in terminal unit, such as individual Run on computer.However, the program product not limited to this of the present invention, in this document, readable storage medium storing program for executing can be any bag Containing or storage program tangible medium, the program can be commanded execution system, device or device and use or in connection Use.
Readable signal medium can include the data signal propagated in a base band or as a carrier wave part, wherein carry Readable program code.The data signal of this propagation can take various forms, including but not limited to electromagnetism letter Number, optical signal or above-mentioned any appropriate combination.Readable signal medium can also be beyond readable storage medium storing program for executing it is any can Read medium, the computer-readable recording medium can send, propagate or transmit for by instruction execution system, device or device use or Program in connection.
The program code included on computer-readable recording medium can be with any appropriate medium transmission, including but not limited to Wirelessly, wired, optical cable, RF etc., or above-mentioned any appropriate combination.
The program for performing present invention operation can be write with the combination in any of one or more programming language Code, described program design language include object oriented program language Java, C++ etc., also including routine Procedural programming language such as " C " language or similar programming language.Program code can fully in user Perform in computing device, partly perform on a user device, performing as an independent software kit, partly calculating in user Its upper side point is performed on a remote computing or is performed in remote computing device or server completely.It is being related to far In the situation of journey computing device, remote computing device can include LAN (LAN) or wide by the network of any kind Domain net (WAN) is connected to user's computing device, or, it may be connected to external computing device is (such as using Internet service Provider comes by Internet connection).
If although it should be noted that be referred in above-detailed the equipment for instant messaging application equipment for drying or Sub-device, but this division is only not enforceable.In fact, according to the embodiment of the present invention, above-described two The feature and function of individual or more devices can embody in one apparatus.Conversely, the feature of an above-described device Can be to be embodied by multiple devices with Further Division with function.
Although additionally, describe the operation of the inventive method in the accompanying drawings with particular order, this do not require that or Hint must perform according to the particular order these operation, or the operation having to carry out shown in whole could realize it is desired As a result.Additionally or alternatively, it is convenient to omit some steps, multiple steps are merged into a step to perform, and/or by one Step is decomposed into execution of multiple steps.
Although describing spirit and principles of the present invention by reference to some specific embodiments, it should be appreciated that, this Invention is not limited to disclosed specific embodiment, and the feature in also not meaning that to the division of each side in terms of these can not Combination is to be benefited, this to divide merely to the convenience of statement.It is contemplated that cover claims spirit and In the range of included various modifications and equivalent arrangements.

Claims (10)

1. a kind of database detection method, including：
According to default database detection index, the corresponding achievement data of each database detection index is gathered respectively；
Each database detection index corresponding achievement data corresponding examination criteria is compared, each data are obtained The corresponding testing result of storehouse Testing index；
According to the corresponding testing result of each database detection index, the comprehensive grading of database detection is obtained, and is shown The comprehensive grading of the database detection.
2. method according to claim 1, before the comprehensive grading of the database detection is shown, also includes：
According to the comprehensive grading of the database detection, it is determined that row of the current detected data storehouse in the data base for participating in detection Sequence result；And
While the database detection comprehensive grading is shown, the currently quilt obtained according to the ranking results determined also is shown The lateral comparison result of the data base that Test database is detected with other participations.
3. method according to claim 1, also includes：
For each database detection index, if the testing result of the database detection index is not for meeting preset standard, Judge that the corresponding database detection index of the testing result is unqualified；
If at least one database detection index is unqualified, determine detected data stock in risk.
4. the method according to claim 1,2 or 3, according to the corresponding testing result of each database detection index, The comprehensive grading of database detection is obtained, is specifically included：
For each database detection index, according to the corresponding deduction of points mark of the testing result of each database detection index Standard, carries out the comprehensive grading that accumulated deduction obtains the database detection.
5. the method according to claim 1,2 or 3, before the comprehensive grading of the database detection is shown, also includes：
According to the comprehensive grading of the database detection, the corresponding risk class in detected data storehouse is determined；And
The comprehensive grading of the database detection is shown, is specifically included：
According to determine, the corresponding risk class in detected data storehouse, using corresponding color pattern displaying described in data base The comprehensive grading of detection.
6. method according to claim 3, also includes：
While the database detection comprehensive grading is shown, the unqualified data base's Testing index of each item is shown.
7. method according to claim 6, also includes：
For the unqualified data base's Testing index of each item, unqualified data base's Testing index is set up to risk details page Link, the risk details page are used for showing the corresponding risk description information of unqualified data base's Testing index and/or repair Multiple advisory information.
8. the method according to right 3, the database detection index include it is following at least one：Database table Index Design Index, database parameter distribu-tion index, database volume planning index, database service safety index, data base's leader follower replication Index and user accesses data index.
9. a kind of database detection device, including：
Collecting unit, for according to default database detection index, gathering the corresponding finger of each database detection index respectively Mark data；
Comparing unit, for each database detection index corresponding achievement data corresponding examination criteria is compared Compared with obtaining the corresponding testing result of each database detection index；
Detector unit, for according to the corresponding testing result of each database detection index, obtaining the comprehensive of database detection Close scoring；
Display unit, for showing the comprehensive grading of the database detection.
10. device according to claim 9, also including the first determining unit, wherein：
First determining unit, for before the comprehensive grading that the display unit shows the database detection, according to The comprehensive grading of the database detection, it is determined that ranking results of the current detected data storehouse in the data base for participating in detection；
The display unit, for, while the database detection comprehensive grading is shown, also showing according to the row for determining The lateral comparison result of the data base that the current detected data storehouse that sequence result is obtained is detected with other participations.
CN201610919259.5A 2016-10-21 2016-10-21 Database detection method and apparatus Pending CN106528388A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610919259.5A CN106528388A (en) 2016-10-21 2016-10-21 Database detection method and apparatus

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610919259.5A CN106528388A (en) 2016-10-21 2016-10-21 Database detection method and apparatus

Publications (1)

Publication Number Publication Date
CN106528388A true CN106528388A (en) 2017-03-22

Family

ID=58333003

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610919259.5A Pending CN106528388A (en) 2016-10-21 2016-10-21 Database detection method and apparatus

Country Status (1)

Country Link
CN (1) CN106528388A (en)

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107506436A (en) * 2017-08-23 2017-12-22 福建星瑞格软件有限公司 A kind of method and device for Internet of Things data library storage performance test
CN109213827A (en) * 2017-07-03 2019-01-15 阿里巴巴集团控股有限公司 A kind of data processing system, method, router and from database
CN109241096A (en) * 2018-08-01 2019-01-18 北京京东金融科技控股有限公司 Data processing method, device and system
CN109905403A (en) * 2019-03-26 2019-06-18 国网甘肃省电力公司信息通信公司 A kind of safety detecting method considering operation and maintenance
CN110750512A (en) * 2019-09-09 2020-02-04 北京新数科技有限公司 Database performance evaluation management method and device
CN110764981A (en) * 2019-09-09 2020-02-07 北京新数科技有限公司 Integrated operation and maintenance management method and device for IT machine room
CN110795614A (en) * 2019-09-27 2020-02-14 广东浪潮大数据研究有限公司 Index automatic optimization method and device
CN112861142A (en) * 2021-02-22 2021-05-28 北京安华金和科技有限公司 Database risk level determination method and device, storage medium and electronic device
CN112994990A (en) * 2021-05-20 2021-06-18 蚂蚁金服（杭州）网络技术有限公司 Loop detection method and device, electronic equipment and storage medium

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
CN105404581A (en) * 2015-12-25 2016-03-16 北京奇虎科技有限公司 Database evaluation method and device
CN105429826A (en) * 2015-12-25 2016-03-23 北京奇虎科技有限公司 Fault detection method and device for database cluster

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
CN105404581A (en) * 2015-12-25 2016-03-16 北京奇虎科技有限公司 Database evaluation method and device
CN105429826A (en) * 2015-12-25 2016-03-23 北京奇虎科技有限公司 Fault detection method and device for database cluster

Cited By (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109213827A (en) * 2017-07-03 2019-01-15 阿里巴巴集团控股有限公司 A kind of data processing system, method, router and from database
CN109213827B (en) * 2017-07-03 2022-07-08 阿里云计算有限公司 Data processing system, method, router and slave database
CN107506436A (en) * 2017-08-23 2017-12-22 福建星瑞格软件有限公司 A kind of method and device for Internet of Things data library storage performance test
CN109241096A (en) * 2018-08-01 2019-01-18 北京京东金融科技控股有限公司 Data processing method, device and system
CN109905403A (en) * 2019-03-26 2019-06-18 国网甘肃省电力公司信息通信公司 A kind of safety detecting method considering operation and maintenance
CN110750512A (en) * 2019-09-09 2020-02-04 北京新数科技有限公司 Database performance evaluation management method and device
CN110764981A (en) * 2019-09-09 2020-02-07 北京新数科技有限公司 Integrated operation and maintenance management method and device for IT machine room
CN110795614A (en) * 2019-09-27 2020-02-14 广东浪潮大数据研究有限公司 Index automatic optimization method and device
CN112861142A (en) * 2021-02-22 2021-05-28 北京安华金和科技有限公司 Database risk level determination method and device, storage medium and electronic device
CN112994990A (en) * 2021-05-20 2021-06-18 蚂蚁金服（杭州）网络技术有限公司 Loop detection method and device, electronic equipment and storage medium
CN112994990B (en) * 2021-05-20 2021-07-30 蚂蚁金服（杭州）网络技术有限公司 Loop detection method and device, electronic equipment and storage medium

Similar Documents

Publication Publication Date Title
CN106528388A (en) Database detection method and apparatus
US10649838B2 (en) Automatic correlation of dynamic system events within computing devices
CN105843703B (en) Workflow is created to solve the method and system of at least one system problem
CN107667370A (en) Abnormal account is detected using event log
CN108170566A (en) Product failure information processing method, system, equipment and collaboration platform
CN107122669A (en) A kind of method and apparatus for assessing leaking data risk
CN105528275B (en) Database security inspection method
CN105302697B (en) A kind of running state monitoring method and system of density data model database
CN111931047B (en) Artificial intelligence-based black product account detection method and related device
CN104504334B (en) System and method for assessing classifying rules selectivity
WO2014206131A1 (en) Method and apparatus for report generation
WO2021040871A1 (en) Quantifiying privacy impact
WO2023138098A1 (en) User group attribute analysis system and method based on online network
CN108121716A (en) The approaches and problems uniprocesser system of process problem list
CN111934954A (en) Broadband detection method and device, electronic equipment and storage medium
CN109471862A (en) Data processing method and device, electronic equipment, storage medium
CN112861142A (en) Database risk level determination method and device, storage medium and electronic device
CN115396231A (en) Network security equipment test system
CN103281221B (en) Fire-fighting Internet of things system method of testing
CN108197041A (en) A kind of method, equipment and its storage medium of the parent process of determining subprocess
US9515884B2 (en) System and method for evaluating coverage of services by components of an IT infrastructure
US20130291106A1 (en) Enterprise level information alert system
CN114297522A (en) Display method and device of power grid station monitoring data and electronic equipment
CN109783773A (en) A kind of method and device of the improper flow of determining website interface
CN110519102A (en) A kind of server failure recognition methods, device and storage medium

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication

Application publication date: 20170322

RJ01 Rejection of invention patent application after publication