CN114077449B - Database server testing method and device, electronic equipment and storage medium - Google Patents

Database server testing method and device, electronic equipment and storage medium Download PDF

Info

Publication number
CN114077449B
CN114077449B CN202010845007.9A CN202010845007A CN114077449B CN 114077449 B CN114077449 B CN 114077449B CN 202010845007 A CN202010845007 A CN 202010845007A CN 114077449 B CN114077449 B CN 114077449B
Authority
CN
China
Prior art keywords
test
database server
tested
configuration
service
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202010845007.9A
Other languages
Chinese (zh)
Other versions
CN114077449A (en
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.)
NetsUnion Clearing Corp
Original Assignee
NetsUnion Clearing Corp
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 NetsUnion Clearing Corp filed Critical NetsUnion Clearing Corp
Priority to CN202010845007.9A priority Critical patent/CN114077449B/en
Publication of CN114077449A publication Critical patent/CN114077449A/en
Application granted granted Critical
Publication of CN114077449B publication Critical patent/CN114077449B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/4401Bootstrapping
    • G06F9/4411Configuring for operating with peripheral devices; Loading of device drivers
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/36Preventing errors by testing or debugging software
    • G06F11/3668Software testing
    • G06F11/3672Test management
    • G06F11/3684Test management for test design, e.g. generating new test cases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/36Preventing errors by testing or debugging software
    • G06F11/3668Software testing
    • G06F11/3672Test management
    • G06F11/3688Test management for test execution, e.g. scheduling of test suites
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Software Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computer Hardware Design (AREA)
  • Quality & Reliability (AREA)
  • Computer Security & Cryptography (AREA)
  • Debugging And Monitoring (AREA)

Abstract

The application provides a method, a device, electronic equipment and a storage medium for testing a database server, and relates to the technical field of data processing, wherein the method comprises the following steps: determining a brand identification of a database server to be tested; according to the brand identification and a preset configuration management library, determining installation information matched with a database server to be tested, and installing a server driver on the database server to be tested according to the installation information; the method comprises the steps that a configuration management library is preset to store the corresponding relation between brand identifiers and installation information; determining a test task of a database server to be tested according to the brand identification and a preset configuration management library; the preset configuration management library stores the corresponding relation between the brand identification and the configuration parameters of each configuration item; and performing pressure test on the database server to be tested based on the configuration parameters of each configuration item in the test task. Therefore, the technical problems of complicated operation, low accuracy and excessive labor cost of the test of the database server are solved, and the test efficiency and accuracy are improved while the cost is reduced.

Description

Database server testing method and device, electronic equipment and storage medium
Technical Field
The present disclosure relates to the field of data processing technologies, and in particular, to a method and apparatus for testing a database server, an electronic device, and a storage medium.
Background
Typically, performance testing of the database servers is required before the database servers are selected and deployed in the production environment to ensure that the database servers are able to meet business processing requirements.
In the related art, a test engineer is often required to manually perform a test, the test operation is complex, the result is not accurate enough, and the labor cost is too high.
Disclosure of Invention
The present application aims to solve, at least to some extent, one of the technical problems in the related art.
Therefore, the method for testing the database server solves the technical problems that the testing operation is complex, the result is inaccurate, and the labor cost is too high in the prior art, realizes the rapid testing of the database server, and improves the testing efficiency and accuracy while reducing the cost.
The application provides a testing device of a database server.
The application provides an electronic device.
The present application proposes a computer-readable storage medium.
In one aspect, an embodiment of the present application provides a method for testing a database server, including:
Determining a brand identification of a database server to be tested;
determining installation information matched with the database server to be tested according to the brand identification and a preset configuration management library, and installing a server driver on the database server to be tested according to the installation information; wherein, the corresponding relation between the brand identification and the installation information is stored in the preset configuration management library;
determining a test task for the database server to be tested according to the brand identification and the preset configuration management library; wherein, the preset configuration management library also stores the corresponding relation between the brand identification and the configuration parameters of each configuration item;
and performing pressure test on the database server to be tested based on the configuration parameters of each configuration item in the test task.
In one embodiment of the present application, the determining, according to the brand identifier and the preset configuration management library, a test task for the database server to be tested includes:
acquiring configuration parameters of each configuration item of the database server to be tested from the preset configuration management library according to the brand identification; the configuration parameters comprise one or more of a central processing unit mode, a disk scheduling mode and a disk array card cache configuration;
Acquiring control parameters of the database server to be tested;
and setting the test task of the database server to be tested according to the configuration parameters of the configuration items and the control parameters.
In one embodiment of the present application, the method for testing a database server further includes:
acquiring pressure test parameters from a pressure test task configuration library;
the performing the pressure test on the database server to be tested based on the configuration parameters of each configuration item in the test task includes:
and carrying out multiple pressure tests on the database server to be tested according to the configuration parameters of each configuration item and the pressure test parameters to obtain multiple pressure test results.
In one embodiment of the present application, the pressure test parameters include a pressure test time, a test thread number, a test type, a test data lookup table, and a data amount of each test data lookup table;
and performing multiple pressure tests on the database server to be tested according to the configuration parameters of each configuration item and the pressure test parameters to obtain multiple pressure test results, wherein the multiple pressure test results comprise:
and under the configuration parameters of different configuration items of the database server to be tested, controlling the database server to be tested to perform multiple query processing on the corresponding test data query table according to the data quantity of each test data query table based on the test type and the test line number in the pressure test time, so as to obtain a plurality of pressure test results.
In one embodiment of the present application, the method for testing a database server further includes:
and obtaining target results meeting target screening conditions from the plurality of pressure test results, and obtaining target configuration items corresponding to the target results.
In one embodiment of the present application, the target screening conditions include: and one or more of service processing capacity, query data amount per second, average response time, minimum response time, maximum response time and total response time of the database server to be tested.
In an embodiment of the present application, when the target screening condition is a service processing amount of the database server to be tested, a query data amount per second, and an average response time, the obtaining a target result from the plurality of pressure test results, where the target result meets the target screening condition, and obtaining a target configuration item corresponding to the target result includes:
obtaining target results corresponding to the maximum amount of business processing amount and query data amount per second and the minimum average response time from the plurality of pressure test results;
and obtaining a target configuration parameter corresponding to the target result by performing pressure test on the database server to be tested, and determining a target configuration item according to the target configuration parameter.
In one embodiment of the present application, after the obtaining the target configuration item corresponding to the target result, the method further includes:
acquiring a test service type, service test time and test service processing amount from a service test task configuration library;
under the configuration parameters of the target configuration items of the database server to be tested, controlling the data server to be tested to process the test service processing amount according to the test service type in the service test time to obtain a service test result;
and under the condition that the service test result meets the preset test condition, determining that the database server to be tested meets the online requirement.
In an embodiment of the present application, the determining that the database server to be tested meets an online requirement when the service test result meets a preset test condition includes:
acquiring a service type to be processed, and determining that the test condition is a service average time consumption threshold and a service throughput threshold according to the service type to be processed;
and acquiring test average time consumption and test service processing amount from the service test result, and determining that the database server to be tested meets the online requirement under the condition that the test average time consumption is smaller than or equal to the service average time consumption threshold and the test service processing amount is larger than the service processing amount threshold.
Another embodiment of the present application provides a testing device for a database server, including:
the first determining module is used for determining brand identifiers of the database servers to be tested;
the processing module is used for determining installation information matched with the database server to be tested according to the brand identification and a preset configuration management library, and installing a server driver on the database server to be tested according to the installation information; wherein, the corresponding relation between the brand identification and the installation information is stored in the preset configuration management library;
the second determining module is used for determining a test task of the database server to be tested according to the brand identification and the preset configuration management library; wherein, the preset configuration management library also stores the corresponding relation between the brand identification and the configuration parameters of each configuration item;
and the test module is used for carrying out pressure test on the database server to be tested based on the configuration parameters of each configuration item in the test task.
In another aspect, an embodiment of the present application provides an electronic device, including: the test method for the database server comprises a memory, a processor and a computer program stored in the memory and capable of running on the processor, wherein the processor realizes the test method for the database server according to the embodiment of the aspect when executing the program.
In yet another aspect, an embodiment of the present application proposes a computer readable storage medium, on which a computer program is stored, which when executed by a processor, implements a method for testing a database server according to the foregoing method embodiment.
The technical scheme provided by the embodiment of the application can comprise the following beneficial effects:
determining a brand identification of a database server to be tested; according to the brand identification and a preset configuration management library, determining installation information matched with a database server to be tested, and installing a server driver on the database server to be tested according to the installation information; the corresponding relation between the brand identification and the installation information is stored in a preset configuration management library; determining a test task of a database server to be tested according to the brand identification and a preset configuration management library; the preset configuration management library also stores the corresponding relation between the brand identification and the configuration parameters of each configuration item; and performing pressure test on the database server to be tested based on the configuration parameters of each configuration item in the test task. Therefore, the technical problems of complicated operation, low accuracy and excessive labor cost of the test of the database server are solved, and the test efficiency and accuracy are improved while the cost is reduced.
Drawings
The foregoing and/or additional aspects and advantages of the present application will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings, in which:
fig. 1 is a flow chart of a method for testing a database server according to an embodiment of the present application;
FIG. 2 is an exemplary diagram of configuration information of a database server according to an embodiment of the present application;
FIG. 3 is a flowchart illustrating another method for testing a database server according to an embodiment of the present disclosure;
FIG. 4 is a flowchart illustrating a testing method of a database server according to another embodiment of the present application
Fig. 5 is a schematic structural diagram of a testing device of a database server according to an embodiment of the present application.
Detailed Description
Embodiments of the present application are described in detail below, examples of which are illustrated in the accompanying drawings, wherein the same or similar reference numerals refer to the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the drawings are exemplary and intended for the purpose of explaining the present application and are not to be construed as limiting the present application.
The following describes a method, an apparatus, an electronic device, and a storage medium for testing a database server according to embodiments of the present application with reference to the accompanying drawings.
Specifically, in order to solve the technical problems of complex testing mode, inaccurate result and high labor cost of the database server in the prior art, the application provides a testing method of the database server, and the brand identification of the database server to be tested is determined; according to the brand identification and a preset configuration management library, determining installation information matched with a database server to be tested, and installing a server driver on the database server to be tested according to the installation information; the corresponding relation between the brand identification and the installation information is stored in a preset configuration management library; determining a test task of a database server to be tested according to the brand identification and a preset configuration management library; the preset configuration management library also stores the corresponding relation between the brand identification and the configuration parameters of each configuration item; and performing pressure test on the database server to be tested based on the configuration parameters of each configuration item in the test task.
Therefore, the technical problems of complicated operation, low accuracy and excessive labor cost of the test of the database server are solved, and the test efficiency and accuracy are improved while the cost is reduced.
Fig. 1 is a flowchart of a method for testing a database server according to an embodiment of the present application.
As shown in fig. 1, the method comprises the steps of:
step 101, determining a brand identification of the database server to be tested.
In the embodiment of the application, the database server is composed of one or more computers running in the local area network and database management system software, and the database server provides data services for client application programs, such as transaction data processing and clearing processing (such as checking account, accounting and the like).
In this embodiment of the present application, a test may be performed on one or more different database servers, and after the database server to be tested is obtained, a brand identifier of the database server to be tested is determined.
In this embodiment of the present application, the test instruction may be triggered by triggering a related control, or may be a test instruction sent by a related device, or may also be that, through a related integration tool, it is monitored that related test parameters of a database server are updated, for example, test parameters of a newly added database server or parameters of an existing database server are updated, and the test instruction is automatically triggered, that is, after the test instruction is triggered, a brand identifier of the database server to be tested is determined.
Step 103, according to the brand identification and a preset configuration management library, determining installation information matched with the database server to be tested, and installing a server driver on the database server to be tested according to the installation information; the corresponding relation between the brand identification and the installation information is stored in a preset configuration management library.
Step 105, determining a test task of a database server to be tested according to the brand identification and a preset configuration management library; the preset configuration management library also stores the corresponding relation between the brand identification and the configuration parameters of each configuration item.
In this embodiment of the present application, a correspondence between a brand identifier and installation information is stored in a preset configuration management library, and a correspondence between the brand identifier and configuration parameters of each configuration item is also stored in the preset configuration management library, that is, configuration information corresponding to database servers of different brands, such as an installation package path, a central processing unit mode, a disk scheduling mode, a disk array card cache configuration, etc., is obtained in advance, and is stored in the preset data management library according to a mapping relationship.
As a possible way, as shown in fig. 2, the adjustment command may be different for different brands of database servers, and different brands of information, such as dell, hua, wave and hewlett-packard, shown in fig. 2, including location information of the drive package, where the installation package, the central processing mode (power saving and high performance), the disk scheduling mode (Deadline; operating in order from beginning to end, NOOP) and the disk array RAID card cache configuration (Write-back; write-through) required for the different brands of database servers are distributed.
Further, after determining the corresponding database server, the installation package path of the database server can be obtained from the data management database, so that an installation package is obtained, and a server driver is installed on the database server to be tested according to the installation information.
In this embodiment of the present application, there are various ways of determining a test task of a database server to be tested according to a brand identifier and a preset configuration management library, and as an example, a central processing unit mode, a disk scheduling mode, and a disk array card cache configuration of the database server to be tested are obtained, and the test task of the database server to be tested is set according to the central processing unit mode, the disk scheduling mode, the disk array card cache configuration, and control parameters.
And step 107, performing pressure test on the database server to be tested based on the configuration parameters of each configuration item in the test task.
In the embodiment of the application, the database server to be tested is subjected to pressure test under different configuration items of the database server, and it can be understood how many configuration items correspond to how many test results, namely, the test results of the database server under different configuration items are obtained.
In the embodiment of the application, the configuration parameters of each configuration item of the database server to be tested are obtained from a preset configuration management library according to the brand identification; the configuration parameters comprise one or more of a central processing unit mode, a disk scheduling mode and a disk array card cache configuration, control parameters of the database server to be tested are obtained, and test tasks of the database server to be tested are set according to the configuration parameters and the control parameters of each configuration item, and are exemplified as follows:
in a first example, for example, under the control of parameters of real-time disk brushing of a log of a database server to be tested, under the configuration items that a central processor mode is energy-saving, a disk scheduling mode is a deadline scheduling program and a disk array card cache is configured as write-back, the service processing capacity of the database server to be tested is A, the query data capacity B per second, the average response time C, the minimum response time D, the maximum response time E and the total response time F are obtained.
In a second example, for example, under the parameter control of real-time disk brushing of the log of the database server to be tested, under the configuration items that the central processor mode is high performance, the disk scheduling mode is a deadline scheduler, and the disk array card cache is configured as write-back, the service processing amount of the database server to be tested is R, the query data amount S per second, the average response time Q, the minimum response time U, the maximum response time V and the total response time W are obtained.
In the method for testing the database server, the brand identification of the database server to be tested is determined; according to the brand identification and a preset configuration management library, determining installation information matched with a database server to be tested, and installing a server driver on the database server to be tested according to the installation information; the corresponding relation between the brand identification and the installation information is stored in a preset configuration management library; determining a test task of a database server to be tested according to the brand identification and a preset configuration management library; the preset configuration management library also stores the corresponding relation between the brand identification and the configuration parameters of each configuration item; and performing pressure test on the database server to be tested based on the configuration parameters of each configuration item in the test task. Therefore, the technical problems of complicated operation, low accuracy and excessive labor cost of the test of the database server are solved, and the test efficiency and accuracy are improved while the cost is reduced.
The present embodiment provides another method for testing a database server, and fig. 3 is a flow chart of another method for testing a database server provided in the embodiment of the present application.
As shown in fig. 3, after step 105, the method may further comprise the steps of:
step 201, obtaining pressure test parameters from a pressure test task configuration library, and performing multiple pressure tests on the database server to be tested according to the configuration parameters and the pressure test parameters of each configuration item to obtain multiple pressure test results.
In this embodiment of the present application, the pressure test parameters may be set as required, and may include one or more of a pressure test time, a test thread number, a test type, a test data lookup table, and a data amount of each test data lookup table, and the like, and are stored in a pressure test task configuration library.
Thus, the pressure test parameters may be obtained from a pressure test task configuration library from which, as an example, the pressure test time, the number of test threads, the test type, the test data look-up table, and the amount of data for each test data look-up table are obtained.
In the embodiment of the application, under the configuration parameters of different configuration items of the database server to be tested, the database server to be tested is controlled to perform multiple query processing on the corresponding test data query table according to the data quantity of each test data query table based on the test type and the test line number in the pressure test time, so as to obtain multiple pressure test results.
In the embodiment of the present application, there are a plurality of ways to obtain different configuration items of the database server, and as an example, a central processor mode, a disk scheduling mode and a disk array card cache configuration of the database server are obtained from the data management database, control parameters of the database server are obtained, and the configuration items of the database server are set according to the central processor mode, the disk scheduling mode, the disk array card cache configuration and the control parameters.
Further, under different configuration items of the database server to be tested, performing multiple pressure tests on the database server to be tested according to the pressure test parameters to obtain multiple pressure test results, and it can be understood how many configuration items correspond to how many test results, namely, obtaining test results of the database server to be tested under different configuration items.
In a first example, for example, under the control of parameters of real-time disk brushing of a log of a database server to be tested, under the configuration items that a central processor mode is energy-saving, a disk scheduling mode is a deadline scheduling program and a disk array card cache is configured as write-back, the service processing capacity of the database server to be tested is A, the query data capacity B per second, the average response time C, the minimum response time D, the maximum response time E and the total response time F are obtained.
In a second example, for example, under the parameter control of real-time disk brushing of the log of the database server to be tested, under the configuration items that the central processor mode is high performance, the disk scheduling mode is a deadline scheduler, and the disk array card cache is configured as write-back, the service processing amount of the database server to be tested is R, the query data amount S per second, the average response time Q, the minimum response time U, the maximum response time V and the total response time W are obtained.
And 203, acquiring a target result meeting the target screening condition from the plurality of pressure test results, and acquiring a target configuration item corresponding to the target result.
In the embodiment of the present application, in order to ensure that the database server to be tested can meet the service requirement, the target screening condition may be set according to the requirement, for example, one or more of the service throughput of the database server, the query data volume per second, the average response time, the minimum response time, the maximum response time and the total response time.
Further, a target result meeting the target screening condition is obtained from the plurality of test results, and a target configuration item corresponding to the target result, namely a central processing unit mode, a disk scheduling mode, a disk array card cache configuration and control parameters of a database server corresponding to the target result, is obtained.
As one possible implementation manner, when the target screening condition is a service processing amount of a database server to be tested, a query data amount per second, and an average response time, acquiring a target result satisfying the target screening condition from a plurality of pressure test results, and acquiring a target configuration item corresponding to the target result, including: obtaining target results corresponding to the maximum amount of business processing capacity and query data amount per second and the minimum time value of average response time from a plurality of pressure test results; and obtaining a target configuration parameter corresponding to the target result by performing pressure test on the database server to be tested, and determining a target configuration item according to the target configuration parameter.
And 205, acquiring a test service type, service test time and test service processing amount from the service test task configuration library, and controlling the data server to be tested to process the test service processing amount according to the test service type to obtain a service test result in the service test time under the configuration parameters of the target configuration item of the database server to be tested.
Step 207, determining that the database server to be tested meets the online requirement when the service test result meets the preset test condition.
In the embodiment of the application, after determining a target configuration item, a test service type, service test time and test service processing amount are obtained from a service test task configuration library, and under the target configuration item, service test is performed on a database server to be tested according to the test service type, service test time and test service processing amount.
The service test parameters are set according to the requirement, and may include one or more of test service type, second test time, test service throughput, etc., and stored in a service test task configuration library.
Thus, the traffic test parameters may be obtained from a traffic test task configuration library, as an example, the test traffic type, traffic test time, and test traffic throughput are obtained from the traffic test task configuration library.
Further, performing service testing on the database server to be tested according to the service testing parameters, including: and in the service test time, controlling the data server to process the test service processing amount according to the test service type.
In the embodiment of the present application, corresponding test conditions may be set according to different service types to be processed, which is taken as an example, a service type to be processed is obtained, and the test conditions are determined to be a service average time consumption threshold and a service throughput threshold according to the service type to be processed.
Further, the average test time consumption and the test service processing amount are obtained from the test result, and if the average test time consumption is smaller than or equal to the average service time consumption threshold and the test service processing amount is larger than the service processing amount threshold, the database server is determined to meet the online requirement.
As another example, a type of traffic to be processed is obtained, and test conditions are determined as a traffic average time consumption threshold, a traffic throughput threshold, and a traffic query throughput per second threshold according to the type of traffic to be processed.
Further, the average test time consumption, the test service processing amount and the test service inquiry amount per second are obtained from the test result, and if the average test time consumption is smaller than or equal to the average service time consumption threshold, the test service processing amount is larger than the service processing amount threshold and the test service inquiry amount per second is smaller than or equal to the service inquiry amount threshold per second, the database server to be tested is determined to meet the online requirement.
It should be noted that if the test result does not meet the preset test condition, it is determined that the database server to be tested meets the online requirement.
Therefore, the technical problems of complicated operation, low accuracy and excessive labor cost of the test of the database server are solved, and the test efficiency and accuracy are improved while the cost is reduced.
The present embodiment provides another method for testing a database server, and fig. 4 is a flow chart of another method for testing a database server provided in the embodiment of the present application.
As shown in fig. 4, after step 105, the method may further include the steps of:
step 301, obtaining a pressure test time, a test thread number, a test type, a test data lookup table and a data amount of each test data lookup table from a pressure test task configuration library.
In the application embodiment, the pressure test time can be summarized and determined, for example, in one hour, according to historical test experience, or can be set according to service requirements; the number of test threads mainly refers to the concurrency processing capacity of the database server, namely the concurrency quantity can be 10, 30, 50, 100 and the like; the test type can be read-write, write-only, read-only, update, etc.; the test data look-up table, i.e. the look-up table storing data, may be one or more, and the amount of data, i.e. how much data, each test data look-up table comprises.
Step 303, obtaining the central processing unit mode, the disk scheduling mode and the disk array card cache configuration of the database server to be tested from the preset configuration management library, and obtaining the control parameters of the database server to be tested.
And step 305, setting configuration items of the database server to be tested according to the CPU mode, the disk scheduling mode, the disk array card cache configuration and the control parameters.
In this embodiment of the present application, the control parameters of the database server to be tested mainly refer to parameter control of real-time and non-real-time brushing of test logs of the database server to be tested, for example, innodb_flush_log_at_trx_commit=1 and sync_binlog=1 may be selected in configuration options of the database server to be tested. The size of the buffer pool can be modified according to the actual application requirement.
In this embodiment, the cpu mode, the disk scheduling manner, and the disk array card cache configuration may be combined into different configuration items as shown in fig. 2, which will not be described in detail herein.
Step 307, under different configuration items of the database server to be tested, in the pressure test time, controlling the database server to be tested to obtain the data amount of each test data lookup table from the test data lookup table according to the test type and the test thread number, and obtaining a plurality of test results.
In the embodiment of the application, under different configuration items of the database server to be tested, the database server is subjected to benchmark test according to the pressure test parameters to obtain a plurality of test results, and it can be understood how many configuration items correspond to how many test results, namely, the test results of the database server to be tested under different configurations are obtained.
In a first example, for example, under the control of parameters of real-time disk brushing of a log of a database server to be tested, under the configuration items that a central processor mode is energy-saving, a disk scheduling mode is a deadline scheduling program and a disk array card cache is configured as write-back, the service processing capacity of the database server to be tested is A, the query data capacity B per second, the average response time C, the minimum response time D, the maximum response time E and the total response time F are obtained.
In a second example, for example, under the parameter control of real-time disk brushing of the log of the database server to be tested, under the configuration items that the central processor mode is high performance, the disk scheduling mode is a deadline scheduler, and the disk array card cache is configured as write-back, the service processing amount of the database server to be tested is R, the query data amount S per second, the average response time Q, the minimum response time U, the maximum response time V and the total response time W are obtained.
Step 309, obtaining a target result with the minimum average response time and meeting the maximum service throughput and the maximum query data volume per second from the plurality of test results, and obtaining a target configuration item corresponding to the target result.
In the embodiment of the application, the target mode with the largest service processing amount, the largest query data amount per second and the smallest average response time can be selected, and the service test is further carried out.
And 311, acquiring the test service type, service test time and test service processing amount from the service test task configuration library, and controlling the data server to be tested to process the test service processing amount according to the test service type in the service test time under the target configuration item.
Step 313, obtaining the service type to be processed, and determining the testing condition as the average time consumption threshold and the service throughput threshold according to the service type to be processed.
Step 315, obtaining the average test time consumption and the test service throughput from the test result, and if the average test time consumption is less than or equal to the average service time consumption threshold and the test service throughput is greater than the service throughput threshold, determining that the database server to be tested meets the online requirement.
In the embodiment of the application, the test service type may be transaction service, clearing service, etc.; the second test time can be summarized and determined, such as one hour, according to historical test experience, and can be set according to service requirements; test traffic primarily refers to the ability of a database server to concurrently process traffic.
In the embodiment of the application, a service type to be processed is obtained, a test condition is determined to be a service average time consumption threshold and a service processing amount threshold according to the service type to be processed, test average time consumption and test service processing amount are obtained from a test result, and if the test average time consumption is smaller than or equal to the service average time consumption threshold and the test service processing amount is larger than the service processing amount threshold, the database server is determined to meet the online requirement.
In the embodiment of the present application, the test result of each configuration item may include the service throughput of the database server to be tested, the query data volume per second, the average response time, the minimum response time, the maximum response time, the total response time, and the parameter changes under different thread numbers and under the configuration item, so as to evaluate the performance of the database.
Further, for the optimal configuration (configuration item with maximum service processing capacity, maximum query data capacity per second and minimum average response time) selected in the pressure test process, the service sub-test is automatically performed, and the service processing capacity of the database server to be tested, the query data capacity per second, the average active thread number, the load of the database server, the memory, the consumption of the central processing unit, the average time consumption of the service, the maximum time consumption time, the minimum time consumption time and the time point of the maximum time consumption time occurrence can be counted in the service sub-test process. For time consumption of each transaction, a time consumption curve can be drawn, fluctuation in the whole test period can be seen, and chart display can be performed in a report form.
It should be noted that, the basic information of the system may also be obtained through an operating system command, for example: the system memory, the central processing core number, the hard disk size, whether the disk is a solid state disk or a common disk, the parameter configuration of the database server and other basic condition output are used for facilitating the subsequent operation environment such as the selection setting of an operating system and the like, and further meeting the user service processing requirements.
In the method for testing the database server, the brand identification of the database server to be tested is determined; according to the brand identification and a preset configuration management library, determining installation information matched with a database server to be tested, and installing a server driver on the database server to be tested according to the installation information; the corresponding relation between the brand identification and the installation information is stored in a preset configuration management library; determining a test task of a database server to be tested according to the brand identification and a preset configuration management library; the preset configuration management library also stores the corresponding relation between the brand identification and the configuration parameters of each configuration item; and performing pressure test on the database server to be tested based on the configuration parameters of each configuration item in the test task. Therefore, the technical problems of complicated operation, low accuracy and excessive labor cost of the test of the database server are solved, and the test efficiency and accuracy are improved while the cost is reduced.
In order to implement the above embodiment, the present application further provides a testing device for a database server
Fig. 5 is a schematic structural diagram of a testing device of a database server according to an embodiment of the present application.
As shown in fig. 5, the apparatus includes: a first determination module 401, a processing module 403, a second determination module 405, and a test module 407.
A first determining module 401, configured to determine a brand identifier of a database server to be tested.
The processing module 403 is configured to determine installation information matched with the database server to be tested according to the brand identifier and a preset configuration management library, and install a server driver on the database server to be tested according to the installation information; the corresponding relation between the brand identification and the installation information is stored in the preset configuration management library.
A second determining module 405, configured to determine a test task for the database server to be tested according to the brand identifier and the preset configuration management library; the preset configuration management library also stores the corresponding relation between the brand identification and the configuration parameters of each configuration item.
And the test module 407 is configured to perform a pressure test on the database server to be tested based on the configuration parameters of each configuration item in the test task.
Further, in one possible implementation manner of the embodiment of the present application, the stress test parameters include stress test time, test thread number, test type, test data lookup table, and data amount of each test data lookup table;
And the second determining module 405 is configured to control, in the pressure test time, the database server to be tested to perform multiple query processing on the corresponding test data lookup table according to the data amount of each test data lookup table based on the test type and the test thread number under the configuration parameters of different configuration items of the database server to be tested, so as to obtain multiple pressure test results.
Further, in one possible implementation manner of the embodiment of the present application, the pressure test parameters are obtained from a pressure test task configuration library; and the test module 407 is configured to perform multiple pressure tests on the database server to be tested according to the configuration parameters of each configuration item and the pressure test parameters, so as to obtain multiple pressure test results.
Further, in one possible implementation manner of the embodiment of the present application, the pressure test parameter includes a pressure test time, a test thread number, a test type, a test data lookup table, and a data amount of each test data lookup table; the test module 407 is configured to control, under the configuration parameters of different configuration items of the database server to be tested, the database server to be tested to perform multiple query processing on the corresponding test data lookup table according to the data amount of each test data lookup table based on the test type and the test thread number within the pressure test time, so as to obtain multiple pressure test results.
Further, in one possible implementation manner of the embodiment of the present application, a target result that meets a target screening condition is obtained from the multiple pressure test results, and a target configuration item corresponding to the target result is obtained.
Further, in one possible implementation manner of the embodiment of the present application, the target screening condition includes: and one or more of service processing capacity, query data amount per second, average response time, minimum response time, maximum response time and total response time of the database server to be tested.
Further, in a possible implementation manner of the embodiment of the present application, in a case where the target screening condition is a service processing amount of the database server to be tested, an amount of query data per second, and an average response time, the obtaining, from the plurality of pressure test results, a target result that meets the target screening condition, and obtaining a target configuration item corresponding to the target result includes: obtaining target results corresponding to the maximum amount of business processing amount and query data amount per second and the minimum average response time from the plurality of pressure test results; and obtaining a target configuration parameter corresponding to the target result by performing pressure test on the database server to be tested, and determining a target configuration item according to the target configuration parameter.
Further, in one possible implementation manner of the embodiment of the present application, after the obtaining the target configuration item corresponding to the target result, the method further includes: acquiring a test service type, service test time and test service processing amount from a service test task configuration library; under the configuration parameters of the target configuration items of the database server to be tested, controlling the data server to be tested to process the test service processing amount according to the test service type in the service test time to obtain a service test result; and under the condition that the service test result meets the preset test condition, determining that the database server to be tested meets the online requirement.
Further, in a possible implementation manner of the embodiment of the present application, when the service test result meets a preset test condition, determining that the database server to be tested meets an online requirement includes: acquiring a service type to be processed, and determining that the test condition is a service average time consumption threshold and a service throughput threshold according to the service type to be processed; and acquiring test average time consumption and test service processing amount from the service test result, and determining that the database server to be tested meets the online requirement under the condition that the test average time consumption is smaller than or equal to the service average time consumption threshold and the test service processing amount is larger than the service processing amount threshold.
It should be noted that the foregoing explanation of the method embodiment is also applicable to the apparatus of this embodiment, and will not be repeated here.
In the testing device of the database server, the brand identification of the database server to be tested is determined; according to the brand identification and a preset configuration management library, determining installation information matched with a database server to be tested, and installing a server driver on the database server to be tested according to the installation information; the corresponding relation between the brand identification and the installation information is stored in a preset configuration management library; determining a test task of a database server to be tested according to the brand identification and a preset configuration management library; the preset configuration management library also stores the corresponding relation between the brand identification and the configuration parameters of each configuration item; and performing pressure test on the database server to be tested based on the configuration parameters of each configuration item in the test task. Therefore, the technical problems of complicated operation, low accuracy and excessive labor cost of the test of the database server are solved, and the test efficiency and accuracy are improved while the cost is reduced.
In order to achieve the above embodiments, an embodiment of the present application provides an electronic device, including: the test method of the database server according to the embodiment of the method for executing the terminal equipment is realized when the processor executes the program.
In order to implement the foregoing embodiments, the embodiments of the present application provide a computer-readable storage medium having a computer program stored thereon, which when executed by a processor, implements the method for testing a database server according to the foregoing method embodiments.
In the description of the present specification, a description referring to terms "one embodiment," "some embodiments," "examples," "specific examples," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present application. In this specification, schematic representations of the above terms are not necessarily directed to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, the different embodiments or examples described in this specification and the features of the different embodiments or examples may be combined and combined by those skilled in the art without contradiction.
Furthermore, the terms "first," "second," and the like, are used for descriptive purposes only and are not to be construed as indicating or implying a relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defining "a first" or "a second" may explicitly or implicitly include at least one such feature. In the description of the present application, the meaning of "plurality" is at least two, such as two, three, etc., unless explicitly defined otherwise.
Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing specific logical functions or steps of the process, and additional implementations are included within the scope of the preferred embodiment of the present application in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the embodiments of the present application.
Logic and/or steps represented in the flowcharts or otherwise described herein, e.g., a ordered listing of executable instructions for implementing logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). In addition, the computer readable medium may even be paper or other suitable medium on which the program is printed, as the program may be electronically captured, via, for instance, optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner, if necessary, and then stored in a computer memory.
It is to be understood that portions of the present application may be implemented in hardware, software, firmware, or a combination thereof. In the above-described embodiments, the various steps or methods may be implemented in software or firmware stored in a memory and executed by a suitable instruction execution system. As with the other embodiments, if implemented in hardware, may be implemented using any one or combination of the following techniques, as is well known in the art: discrete logic circuits having logic gates for implementing logic functions on data signals, application specific integrated circuits having suitable combinational logic gates, programmable Gate Arrays (PGAs), field Programmable Gate Arrays (FPGAs), and the like.
Those of ordinary skill in the art will appreciate that all or a portion of the steps carried out in the method of the above-described embodiments may be implemented by a program to instruct related hardware, where the program may be stored in a computer readable storage medium, and where the program, when executed, includes one or a combination of the steps of the method embodiments.
In addition, each functional unit in each embodiment of the present application may be integrated in one processing module, or each unit may exist alone physically, or two or more units may be integrated in one module. The integrated modules may be implemented in hardware or in software functional modules. The integrated modules may also be stored in a computer readable storage medium if implemented in the form of software functional modules and sold or used as a stand-alone product.
The above-mentioned storage medium may be a read-only memory, a magnetic disk or an optical disk, or the like. Although embodiments of the present application have been shown and described above, it will be understood that the above embodiments are illustrative and not to be construed as limiting the application, and that variations, modifications, alternatives, and variations may be made to the above embodiments by one of ordinary skill in the art within the scope of the application.

Claims (12)

1. A method for testing a database server, comprising:
determining a brand identification of a database server to be tested;
determining installation information matched with the database server to be tested according to the brand identification and a preset configuration management library, and installing a server driver on the database server to be tested according to the installation information; wherein, the corresponding relation between the brand identification and the installation information is stored in the preset configuration management library;
determining a test task for the database server to be tested according to the brand identification and the preset configuration management library; wherein, the preset configuration management library also stores the corresponding relation between the brand identification and the configuration parameters of each configuration item;
and performing pressure test on the database server to be tested based on the configuration parameters of each configuration item in the test task.
2. The method for testing a database server according to claim 1, wherein determining a test task for the database server to be tested according to the brand identification and the preset configuration management library comprises:
acquiring configuration parameters of each configuration item of the database server to be tested from the preset configuration management library according to the brand identification; the configuration parameters comprise one or more of a central processing unit mode, a disk scheduling mode and a disk array card cache configuration;
acquiring control parameters of the database server to be tested;
and setting the test task of the database server to be tested according to the configuration parameters of the configuration items and the control parameters.
3. The method for testing a database server according to claim 1, further comprising:
acquiring pressure test parameters from a pressure test task configuration library;
the performing the pressure test on the database server to be tested based on the configuration parameters of each configuration item in the test task includes:
and carrying out multiple pressure tests on the database server to be tested according to the configuration parameters of each configuration item and the pressure test parameters to obtain multiple pressure test results.
4. The method for testing a database server according to claim 3,
the pressure test parameters comprise pressure test time, test thread number, test type, test data lookup tables and data volume of each test data lookup table;
and performing multiple pressure tests on the database server to be tested according to the configuration parameters of each configuration item and the pressure test parameters to obtain multiple pressure test results, wherein the multiple pressure test results comprise:
and under the configuration parameters of different configuration items of the database server to be tested, controlling the database server to be tested to perform multiple query processing on the corresponding test data query table according to the data quantity of each test data query table based on the test type and the test line number in the pressure test time, so as to obtain a plurality of pressure test results.
5. The method for testing a database server according to claim 3 or 4, further comprising:
and obtaining target results meeting target screening conditions from the plurality of pressure test results, and obtaining target configuration items corresponding to the target results.
6. The method for testing a database server according to claim 5,
The target screening conditions include: and one or more of service processing capacity, query data amount per second, average response time, minimum response time, maximum response time and total response time of the database server to be tested.
7. The method for testing a database server according to claim 6,
under the condition that the target screening condition is the service processing amount of the database server to be tested, the query data amount per second and the average response time, acquiring a target result meeting the target screening condition from the plurality of pressure test results, and acquiring a target configuration item corresponding to the target result, wherein the method comprises the following steps:
obtaining target results corresponding to the maximum amount of business processing amount and query data amount per second and the minimum average response time from the plurality of pressure test results;
and obtaining a target configuration parameter corresponding to the target result by performing pressure test on the database server to be tested, and determining a target configuration item according to the target configuration parameter.
8. The method for testing a database server according to claim 5, further comprising, after said obtaining a target configuration item corresponding to said target result:
Acquiring a test service type, service test time and test service processing amount from a service test task configuration library;
under the configuration parameters of the target configuration items of the database server to be tested, controlling the data server to be tested to process the test service processing amount according to the test service type in the service test time to obtain a service test result;
and under the condition that the service test result meets the preset test condition, determining that the database server to be tested meets the online requirement.
9. The method for testing a database server according to claim 8, wherein determining that the database server to be tested meets an online requirement when the service test result meets a preset test condition comprises:
acquiring a service type to be processed, and determining that the test condition is a service average time consumption threshold and a service throughput threshold according to the service type to be processed;
and acquiring test average time consumption and test service processing amount from the service test result, and determining that the database server to be tested meets the online requirement under the condition that the test average time consumption is smaller than or equal to the service average time consumption threshold and the test service processing amount is larger than the service processing amount threshold.
10. A database server testing apparatus, comprising:
the first determining module is used for determining brand identifiers of the database servers to be tested;
the processing module is used for determining installation information matched with the database server to be tested according to the brand identification and a preset configuration management library, and installing a server driver on the database server to be tested according to the installation information; wherein, the corresponding relation between the brand identification and the installation information is stored in the preset configuration management library;
the second determining module is used for determining a test task of the database server to be tested according to the brand identification and the preset configuration management library; wherein, the preset configuration management library also stores the corresponding relation between the brand identification and the configuration parameters of each configuration item;
and the test module is used for carrying out pressure test on the database server to be tested based on the configuration parameters of each configuration item in the test task.
11. An electronic device, comprising: memory, a processor and a computer program stored on the memory and executable on the processor, which processor, when executing the program, implements a method of testing a database server according to any one of claims 1-9.
12. A computer readable storage medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements a method of testing a database server according to any of claims 1-9.
CN202010845007.9A 2020-08-20 2020-08-20 Database server testing method and device, electronic equipment and storage medium Active CN114077449B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010845007.9A CN114077449B (en) 2020-08-20 2020-08-20 Database server testing method and device, electronic equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010845007.9A CN114077449B (en) 2020-08-20 2020-08-20 Database server testing method and device, electronic equipment and storage medium

Publications (2)

Publication Number Publication Date
CN114077449A CN114077449A (en) 2022-02-22
CN114077449B true CN114077449B (en) 2023-08-01

Family

ID=80282038

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010845007.9A Active CN114077449B (en) 2020-08-20 2020-08-20 Database server testing method and device, electronic equipment and storage medium

Country Status (1)

Country Link
CN (1) CN114077449B (en)

Citations (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103793328A (en) * 2014-02-24 2014-05-14 浪潮电子信息产业股份有限公司 Method for completing data base performance test by using automatic procedure
CN106708818A (en) * 2015-07-17 2017-05-24 阿里巴巴集团控股有限公司 Pressure testing method and system
WO2018072095A1 (en) * 2016-10-18 2018-04-26 深圳市福斯康姆智能科技有限公司 Load testing management method and system
CN108874637A (en) * 2017-05-09 2018-11-23 北京京东尚科信息技术有限公司 A kind of method of pressure test, system, electronic equipment and readable storage medium storing program for executing
CN109144846A (en) * 2017-06-28 2019-01-04 北京京东尚科信息技术有限公司 Test method and device for testing service device
CN109542712A (en) * 2018-11-02 2019-03-29 平安科技(深圳)有限公司 Server stress test method, device, computer equipment and storage medium
CN110096401A (en) * 2019-05-13 2019-08-06 苏州浪潮智能科技有限公司 A kind of server data process performance test method and device
CN110175110A (en) * 2019-05-31 2019-08-27 深圳前海微众银行股份有限公司 Method for testing pressure, device, system, equipment and computer readable storage medium
WO2019178967A1 (en) * 2018-03-22 2019-09-26 平安科技(深圳)有限公司 Jmeter-based stress testing method and apparatus, and device and storage medium
CN110764959A (en) * 2019-09-26 2020-02-07 苏州浪潮智能科技有限公司 Deployment method and device of test environment of server
CN111026627A (en) * 2019-12-10 2020-04-17 北京奇艺世纪科技有限公司 Pressure testing method and device and server
CN111143196A (en) * 2019-12-05 2020-05-12 武汉迎风聚智科技有限公司 Database testing method and device
WO2020119434A1 (en) * 2018-12-15 2020-06-18 深圳壹账通智能科技有限公司 Method and apparatus for interface data processing, method and apparatus for automated testing, device, and medium

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9280453B1 (en) * 2013-09-27 2016-03-08 Emc Corporation Method and system for test automation framework for backup and recovery applications
US10002071B2 (en) * 2016-03-23 2018-06-19 Wipro Limited Method and a system for automating test environment operational activities

Patent Citations (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103793328A (en) * 2014-02-24 2014-05-14 浪潮电子信息产业股份有限公司 Method for completing data base performance test by using automatic procedure
CN106708818A (en) * 2015-07-17 2017-05-24 阿里巴巴集团控股有限公司 Pressure testing method and system
WO2018072095A1 (en) * 2016-10-18 2018-04-26 深圳市福斯康姆智能科技有限公司 Load testing management method and system
CN108874637A (en) * 2017-05-09 2018-11-23 北京京东尚科信息技术有限公司 A kind of method of pressure test, system, electronic equipment and readable storage medium storing program for executing
CN109144846A (en) * 2017-06-28 2019-01-04 北京京东尚科信息技术有限公司 Test method and device for testing service device
WO2019178967A1 (en) * 2018-03-22 2019-09-26 平安科技(深圳)有限公司 Jmeter-based stress testing method and apparatus, and device and storage medium
CN109542712A (en) * 2018-11-02 2019-03-29 平安科技(深圳)有限公司 Server stress test method, device, computer equipment and storage medium
WO2020119434A1 (en) * 2018-12-15 2020-06-18 深圳壹账通智能科技有限公司 Method and apparatus for interface data processing, method and apparatus for automated testing, device, and medium
CN110096401A (en) * 2019-05-13 2019-08-06 苏州浪潮智能科技有限公司 A kind of server data process performance test method and device
CN110175110A (en) * 2019-05-31 2019-08-27 深圳前海微众银行股份有限公司 Method for testing pressure, device, system, equipment and computer readable storage medium
CN110764959A (en) * 2019-09-26 2020-02-07 苏州浪潮智能科技有限公司 Deployment method and device of test environment of server
CN111143196A (en) * 2019-12-05 2020-05-12 武汉迎风聚智科技有限公司 Database testing method and device
CN111026627A (en) * 2019-12-10 2020-04-17 北京奇艺世纪科技有限公司 Pressure testing method and device and server

Also Published As

Publication number Publication date
CN114077449A (en) 2022-02-22

Similar Documents

Publication Publication Date Title
US11016956B2 (en) Database management system with database hibernation and bursting
US7139846B1 (en) Computer system and method for performing low impact backup operations
US9098351B2 (en) Energy-aware job scheduling for cluster environments
EP2488929B1 (en) Memory object relocation for power savings
CN100533399C (en) Self-learning method and system for detecting abnormalities
US8117415B2 (en) Storage device estimating a completion time for a storage operation
US20060010101A1 (en) System, method and program product for forecasting the demand on computer resources
CN101593146B (en) Method and device for automatically testing page
JP2002041327A (en) Computer system for mounting polling agent in client management tool and its method
US20220327039A1 (en) Creating statistical analyses of data for transmission to servers
US20200249851A1 (en) Methods and apparatus for estimating the wear of a non-volatile memory
CN101246444B (en) Module testing method and system
CN113157411B (en) Celery-based reliable configurable task system and device
CN110297743B (en) Load testing method and device and storage medium
CN113010289A (en) Task scheduling method, device and system
CN110554929A (en) Data verification method and device, computer equipment and storage medium
CN114077449B (en) Database server testing method and device, electronic equipment and storage medium
US7680921B2 (en) Management system, management computer, managed computer, management method and program
CN110659183A (en) System power consumption testing method and device
US10255128B2 (en) Root cause candidate determination in multiple process systems
CN113806195B (en) Data processing method, device, equipment, system and storage medium
CN116841815A (en) Operation monitoring method, device, electronic equipment and storage medium
CN111752786A (en) Data storage method, data summarization method, equipment and medium in pressure test process
US6345337B1 (en) Method and system for determining a cache single reference residency time
CN114461470B (en) Memory power consumption testing method, system, equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant