CN112835778A - Universal test method for RDS database performance, electronic equipment and server - Google Patents
Universal test method for RDS database performance, electronic equipment and server Download PDFInfo
- Publication number
- CN112835778A CN112835778A CN202110212403.2A CN202110212403A CN112835778A CN 112835778 A CN112835778 A CN 112835778A CN 202110212403 A CN202110212403 A CN 202110212403A CN 112835778 A CN112835778 A CN 112835778A
- Authority
- CN
- China
- Prior art keywords
- database
- performance
- component
- processor
- rds
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000010998 test method Methods 0.000 title claims abstract description 9
- 238000012544 monitoring process Methods 0.000 claims abstract description 26
- 238000000034 method Methods 0.000 claims abstract description 17
- 238000011056 performance test Methods 0.000 claims abstract description 17
- 238000012360 testing method Methods 0.000 claims abstract description 17
- 238000012812 general test Methods 0.000 claims abstract description 11
- 238000004590 computer program Methods 0.000 claims description 6
- 238000013499 data model Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000007429 general method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Images
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/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3696—Methods or tools to render software testable
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Abstract
The invention provides a general test method for RDS database performance, electronic equipment and a server, which comprises the following steps: s1: determining the type of data to be tested and performance test indexes; s2: specifying a database type, a database parameter and a performance test index in a configuration file; s3: the client component is started and initialized; s4: the client component reads the configuration data in the configuration file and calls the corresponding database driving component through the configuration data; s5: the driving component is connected with the database according to the database parameters and types in the configuration file and starts a performance test; s6: the monitoring component of the database controls the performance index of the database server; s7: the monitoring component reports the performance index to the client; s8: and the client displays the acquired performance index data. The general test method, the electronic equipment and the server for the performance of the RDS database solve the problems that the existing test method is high in learning cost and does not support real-time use of resources of a tested system in the process of checking and testing.
Description
Technical Field
The invention belongs to the field of database performance testing, and particularly relates to a general testing method for RDS database performance, electronic equipment and a server.
Background
Currently, the database performance testing tools of RDS (relational database) such as Mysql, Postgresql, Sqlserver and the like are different, for example, sysbench is used for testing Mysql, pgbench is used for Postgresql, and HammerDB is used for sqerver; testing different RDS databases requires knowing how the corresponding tools are used, learning cost is particularly high, and real-time use conditions of resources of a tested system in a testing process cannot be checked.
Disclosure of Invention
In view of this, the invention provides a general test method for RDS database performance, an electronic device, and a server to solve the problems that the existing test method has a high learning cost and does not support checking the real-time use of the resources of the system under test in the test process.
In order to achieve the purpose, the technical scheme of the invention is realized as follows:
on one hand, the general test method for the performance of the RDS database comprises the following steps:
s1: determining the type of data to be tested and performance test indexes;
s2: specifying a database type, a database parameter and a performance test index in a configuration file;
s3: the client component is started and initialized;
s4: the client component reads the configuration data in the configuration file and calls the corresponding database driving component through the configuration data;
s5: the driving component is connected with the database according to the database parameters and types in the configuration file and starts a performance test;
s6: the monitoring component of the database controls the performance index of the database server;
s7: the monitoring component reports the performance index to the client;
s8: and the client displays the acquired performance index data.
Further, the configuration file information read by the configuration component in the database includes an IP address, a port number, an account number, a database name, a drive type, a data amount for performance test, and a test type of the database.
Furthermore, the monitoring component integrates monitoring tools of Windows and Linux systems, after the client component calls the monitoring component, the monitoring component automatically uploads the monitoring tool to the tested database server and starts to collect the resource use conditions of the CPU, the memory and the disk IO, and the monitoring tool reports the resource use conditions of the server to the client component for display.
In a second aspect, an electronic device includes a processor and a memory communicatively coupled to the processor and configured to store processor-executable instructions, wherein: the processor is configured to execute the general test method for the performance of the RDS database according to the first aspect.
In a third aspect, a server comprises at least one processor, and a memory communicatively coupled to the processor, the memory storing instructions executable by the at least one processor, the instructions being executable by the processor to cause the at least one processor to perform a method for universal testing of RDS database performance as set forth in the first aspect.
In a fourth aspect, a computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the computer program implements the method for universal testing of the performance of the RDS database according to the first aspect.
Compared with the prior art, the invention has the following beneficial effects:
the general test method for the performance of the RDS database, the electronic equipment and the server do not need to spend learning time to know different RDS performance test tools, and a user can obtain the required performance index and the real-time use condition of the resource of the tested system very intuitively only by knowing the type of the database to be tested and the tested data model.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate an embodiment of the invention and, together with the description, serve to explain the invention and not to limit the invention. In the drawings:
FIG. 1 is a schematic diagram illustrating a general method for testing the performance of an RDS database according to an embodiment of the present invention;
fig. 2 is a schematic diagram of a general test flow of RDS database performance according to an embodiment of the present invention.
Detailed Description
It should be noted that the embodiments and features of the embodiments may be combined with each other without conflict.
In the description of the present invention, it is to be understood that the terms "center", "longitudinal", "lateral", "up", "down", "front", "back", "left", "right", "vertical", "horizontal", "top", "bottom", "inner", "outer", and the like, indicate orientations or positional relationships based on those shown in the drawings, and are used only for convenience in describing the present invention and for simplicity in description, and do not indicate or imply that the referenced devices or elements must have a particular orientation, be constructed and operated in a particular orientation, and thus, are not to be construed as limiting the present invention. Furthermore, the terms "first", "second", etc. are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first," "second," etc. may explicitly or implicitly include one or more of that feature. In the description of the present invention, "a plurality" means two or more unless otherwise specified.
In the description of the present invention, it should be noted that, unless otherwise explicitly specified or limited, the terms "mounted," "connected," and "connected" are to be construed broadly, e.g., as meaning either a fixed connection, a removable connection, or an integral connection; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meaning of the above terms in the present invention can be understood by those of ordinary skill in the art through specific situations.
The present invention will be described in detail below with reference to the embodiments with reference to the attached drawings.
As shown in fig. 1 and fig. 2, a general test method for RDS database performance includes the following steps:
s1: determining the type of data to be tested and performance test indexes;
s2: specifying a database type, a database parameter and a performance test index in a configuration file;
s3: the client component is started and initialized;
s4: the client component reads the configuration data in the configuration file and calls the corresponding database driving component through the configuration data;
s5: the driving component is connected with the database according to the database parameters and types in the configuration file and starts a performance test;
s6: the monitoring component of the database controls the performance index of the database server;
s7: the monitoring component reports the performance index to the client;
s8: and the client displays the acquired performance index data.
The configuration file information read by the configuration component in the database comprises an IP address, a port number, an account number, a database name, a drive type, a data volume of a performance test and a test type of the database.
The monitoring component integrates monitoring tools of Windows and Linux systems, after the client component calls the monitoring component, the monitoring component automatically uploads the monitoring tool to the tested database server and starts to collect the resource use conditions of a CPU, an internal memory and a disk IO, and the monitoring tool reports the resource use conditions of the server to the client component for display.
An electronic device comprising a processor and a memory communicatively coupled to the processor and configured to store processor-executable instructions, wherein: the processor is used for executing the general test method for the performance of the RDS database.
A server comprising at least one processor, and a memory communicatively coupled to the processor, the memory storing instructions executable by the at least one processor, the instructions being executable by the processor to cause the at least one processor to perform the method for universal testing of performance of an RDS database.
A computer readable storage medium storing a computer program which, when executed by a processor, implements the universal test method for RDS database performance.
The general test method, the electronic equipment and the server for the RDS database performance provided by the invention enable a user to obtain the required performance index and the real-time use condition of the resource of the tested system very intuitively after the user only needs to know the type of the database to be tested and the tested data model without spending learning time to know different RDS performance test tools.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (6)
1. A universal test method for RDS database performance is characterized by comprising the following steps:
s1: determining the type of data to be tested and performance test indexes;
s2: specifying a database type, a database parameter and a performance test index in a configuration file;
s3: the client component is started and initialized;
s4: the client component reads the configuration data in the configuration file and calls the corresponding database driving component through the configuration data;
s5: the driving component is connected with the database according to the database parameters and types in the configuration file and starts a performance test;
s6: the monitoring component of the database controls the performance index of the database server;
s7: the monitoring component reports the performance index to the client;
s8: and the client displays the acquired performance index data.
2. A universal test method for RDS database performance according to claim 1, wherein: the configuration file information read by the configuration component in the database comprises an IP address, a port number, an account number, a database name, a drive type, a data volume of a performance test and a test type of the database.
3. A universal test method for RDS database performance according to claim 1, wherein: the monitoring component integrates monitoring tools of Windows and Linux systems, after the client component calls the monitoring component, the monitoring component automatically uploads the monitoring tool to the tested database server and starts to collect the resource use conditions of a CPU, an internal memory and a disk IO, and the monitoring tool reports the resource use conditions of the server to the client component for display.
4. An electronic device comprising a processor and a memory communicatively coupled to the processor and configured to store processor-executable instructions, wherein: the processor is used for executing the general test method for the performance of the RDS database as claimed in any one of the claims 1-3.
5. A server, characterized by: comprising at least one processor and a memory communicatively coupled to the processor, the memory storing instructions executable by the at least one processor to cause the at least one processor to perform a method for universal testing of the performance of an RDS database as claimed in any one of claims 1 to 3.
6. A computer-readable storage medium storing a computer program, characterized in that: the computer program when executed by a processor implements a universal test method for RDS database performance as claimed in any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110212403.2A CN112835778A (en) | 2021-02-25 | 2021-02-25 | Universal test method for RDS database performance, electronic equipment and server |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110212403.2A CN112835778A (en) | 2021-02-25 | 2021-02-25 | Universal test method for RDS database performance, electronic equipment and server |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112835778A true CN112835778A (en) | 2021-05-25 |
Family
ID=75933526
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110212403.2A Pending CN112835778A (en) | 2021-02-25 | 2021-02-25 | Universal test method for RDS database performance, electronic equipment and server |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112835778A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102521354A (en) * | 2011-12-13 | 2012-06-27 | 北京天融信科技有限公司 | Auditing and testing method and auditing and testing device for data base protocol |
| US20170300404A1 (en) * | 2016-04-18 | 2017-10-19 | Accenture Global Solutions Limited | Software integration testing with unstructured database |
| CN110147319A (en) * | 2019-04-19 | 2019-08-20 | 平安普惠企业管理有限公司 | Data library test method, device and computer equipment |
| CN110457202A (en) * | 2019-06-28 | 2019-11-15 | 武汉迎风聚智科技有限公司 | Quickly establish the TPC-E test method and actuator device of ODBC connection |
| CN111090572A (en) * | 2019-12-18 | 2020-05-01 | 紫光云(南京)数字技术有限公司 | System and method for performing performance test on MySQL database |
| CN111400186A (en) * | 2020-03-19 | 2020-07-10 | 时时同云科技(成都)有限责任公司 | Performance test method and system |
-
2021
- 2021-02-25 CN CN202110212403.2A patent/CN112835778A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102521354A (en) * | 2011-12-13 | 2012-06-27 | 北京天融信科技有限公司 | Auditing and testing method and auditing and testing device for data base protocol |
| US20170300404A1 (en) * | 2016-04-18 | 2017-10-19 | Accenture Global Solutions Limited | Software integration testing with unstructured database |
| CN110147319A (en) * | 2019-04-19 | 2019-08-20 | 平安普惠企业管理有限公司 | Data library test method, device and computer equipment |
| CN110457202A (en) * | 2019-06-28 | 2019-11-15 | 武汉迎风聚智科技有限公司 | Quickly establish the TPC-E test method and actuator device of ODBC connection |
| CN111090572A (en) * | 2019-12-18 | 2020-05-01 | 紫光云(南京)数字技术有限公司 | System and method for performing performance test on MySQL database |
| CN111400186A (en) * | 2020-03-19 | 2020-07-10 | 时时同云科技(成都)有限责任公司 | Performance test method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9773135B2 (en) | Portable data collection system and method | |
| EP1889750A1 (en) | System mounted on a vehicle, vehicle, diagnosis information collecting device and navigation device | |
| US20060142907A1 (en) | Method and system for enhanced vehicle diagnostics using statistical feedback | |
| WO2019153487A1 (en) | System performance measurement method and device, storage medium and server | |
| CN110568838B (en) | Vehicle quiescent current acquisition method and system, electronic device and storage medium | |
| CN109933051A (en) | A kind of automobile diagnostic software configuration method, system, equipment and computer media | |
| CN106021045A (en) | Method for testing IO (input/output) performance of hard disk of server under linux system | |
| CN111414351A (en) | Performance diagnosis method and device of MySQ L database | |
| CN111464376A (en) | Website availability monitoring method and device, storage medium and computer equipment | |
| CN113360519B (en) | Data processing method, device, equipment and storage medium | |
| CN112132285A (en) | Vehicle fault diagnosis method and device | |
| CN112835778A (en) | Universal test method for RDS database performance, electronic equipment and server | |
| CN105260400A (en) | Method for processing remote monitoring data of new energy vehicle | |
| CN112783906A (en) | Log data management method and system for industrial internet | |
| CN105718539B (en) | A kind of database application method and device | |
| CN110069562B (en) | Data display method and device, storage medium and computer equipment | |
| CN117347864A (en) | Battery specification searching and integrating method | |
| CN114117831A (en) | Method and device for analyzing data of meter with measuring value in intelligent laboratory | |
| CN113095666A (en) | Laboratory capacity verification and index judgment system and method | |
| CN111639098A (en) | Cloud log management method | |
| CN112783785A (en) | General test method for Nosql database performance | |
| CN114461470B (en) | Memory power consumption testing method, system, equipment and storage medium | |
| CN109885465A (en) | The bulk statistics and monitoring method in SSD disk service life on multi-brand server | |
| EP4198656A1 (en) | Method and system for monitoring an hvac apparatus | |
| CN116541442B (en) | New energy automobile log analysis method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210525 |
|
| RJ01 | Rejection of invention patent application after publication |