Method and device for determining target throughput, equipment, medium and program product

Abstract

The invention relates to the technical field of testing, and provides a target throughput determination method and device, equipment, a medium and a program product. In the method, in response to a processing request, a read test script and a write test script are obtained through a production server; obtaining an actual read throughput and an actual write throughput corresponding to the production server; determining a target read throughput and a target write throughput in the target throughput according to the actual read throughput and the actual write throughput; adjusting the target throughput at least once until the test read-write ratio is consistent with the target read-write ratio; the test read-write ratio is determined according to a test result; the test result is obtained by controlling the test server to execute a read test script and a write test script based on the target throughput so as to perform access processing on the database server; generating processing completion information; the processing completion information indicates the target throughput obtained through at least one adjustment processing. According to the method provided by the embodiment of the invention, the efficiency of determining the target throughput is improved.

Description

Technical Field

[0001] The present application relates to the field of testing technology, and in particular to a method, device, equipment, medium and program product for determining a target throughput. Background Art

[0002] During the test, the target read throughput needs to be used as an input parameter of the read test script, and the target write throughput needs to be used as an input parameter of the write test script, so that the read test script and the write test script can be used to access the database server. Therefore, the target read throughput and the target write throughput need to be determined in advance.

[0003] In the related art, in the process of determining the target read throughput and the target write throughput, the tester needs to manually obtain the actual read throughput and the actual write throughput from the production server, and then manually adjust the actual read throughput and the actual write throughput based on work experience to obtain the target read throughput and the target write throughput.

[0004] However, the methods of the related art have the problem of low efficiency. Summary of the invention

[0005] The embodiments of the present application provide a method, apparatus, device, medium, and program product for determining a target throughput, which improves the efficiency of determining a target read throughput and a target write throughput.

[0006] In a first aspect, an embodiment of the present application provides a method for determining a target throughput, including:

[0007] Responsive to the processing request, obtaining a read test script and a write test script through the production server;

[0008] Get the actual read throughput and actual write throughput of the production server.

[0009] According to the actual read throughput and the actual write throughput, determine the target read throughput and the target write throughput in the target throughput; the target read throughput corresponds to the read test script, and the target write throughput corresponds to the write test script;

[0010] The target throughput is adjusted at least once until the test read-write ratio is consistent with the target read-write ratio; wherein the test read-write ratio is determined according to the test result; the test result is obtained by controlling the test server to execute the read test script and the write test script based on the target throughput to access the database server;

[0011] Generate processing completion information; the processing completion information is used to indicate the target throughput obtained after at least one adjustment process.

[0012] In one implementation, the target throughput is adjusted at least once until the test read-write ratio is consistent with the target read-write ratio, including:

[0013] Based on the i-1th target read throughput and the i-1th target write throughput in the i-1th target throughput, controlling the test server to execute the read test script and the write test script to obtain the i-1th test result; the i-1th test result includes the i-1th test read throughput and the i-1th test write throughput;

[0014] Calculate the read-write ratio of the i-1th test according to the i-1th test read throughput and the i-1th test write throughput;

[0015] When it is determined that the i-1th test read-write ratio is inconsistent with the target read-write ratio, adjusting the i-1th target read throughput in the i-1th target throughput or the i-1th target write throughput in the i-1th target throughput to obtain the i-th target throughput;

[0016] Among them, i is 1, 2, ... in sequence until the i-1th test read-write ratio is consistent with the target read-write ratio; the 0th target read throughput is the target read throughput, and the 0th target write throughput is the target write throughput.

[0017] In one implementation, adjusting the target read throughput in the (i-1)th target throughput or the (i-1)th target write throughput in the (i-1)th target throughput includes:

[0018] When the read-write ratio of the i-1th test is greater than the target read-write ratio, the load of the write test server is obtained; the test server includes a write test server, and the write test server is a test server that executes the write test script;

[0019] Determine whether the load of the write test server is greater than the preset load;

[0020] If yes, the i-1th target read throughput in the i-1th target throughput is lowered;

[0021] If not, the i-1th target write throughput in the i-1th target throughput is increased.

[0022] In one implementation, adjusting the target read throughput in the (i-1)th target throughput or the (i-1)th target write throughput in the (i-1)th target throughput includes:

[0023] When the read-write ratio of the i-1th test is less than the target read-write ratio, the load of the read test server is obtained; the test server includes a read test server, and the read test server is a test server that executes the read test script;

[0024] Determine whether the load of the read test server is greater than the preset load;

[0025] If yes, the i-1th target write throughput in the i-1th target throughput is lowered;

[0026] If not, the i-1th target read throughput in the i-1th target throughput is increased.

[0027] In one implementation, based on the i-1th target read throughput and the i-1th target write throughput in the i-1th target throughput, controlling the test server to execute the read test script and the write test script to obtain the i-1th test result includes:

[0028] Based on the i-1th target read throughput, controlling the read test server in the test server to execute the read test script to perform access processing on the database server, and obtaining the i-1th test read throughput in the i-1th test result;

[0029] Based on the i-1th target write throughput, a write test server in the test server is controlled to execute a write test script to perform access processing on the database server to obtain the i-1th test write throughput in the i-1th test result.

[0030] In one implementation, before adjusting the target throughput at least once until the test read-write ratio is consistent with the target read-write ratio, the method further includes:

[0031] Determine a read test server among the test servers from multiple candidate servers according to the actual read throughput and the throughput corresponding to each candidate server;

[0032] According to the actual write throughput and the throughput corresponding to each candidate server, a write test server among the test servers is determined from the multiple candidate servers.

[0033] In one implementation, processing a request including a target duration type; determining a target read throughput and a target write throughput in the target throughput according to an actual read throughput and an actual write throughput, including:

[0034] Get the candidate read-write ratio corresponding to the target duration type;

[0035] The candidate read-write ratio corresponding to the target duration type is determined as the target read-write ratio;

[0036] Determine the target read throughput based on the actual read throughput and target duration type;

[0037] Determine the target write throughput based on the actual write throughput and target duration type.

[0038] In one implementation, in response to a processing request, obtaining a read test script and a write test script through a production server includes:

[0039] In response to the processing request, obtaining, by the production server, at least one read statement and at least one write statement;

[0040] Generate a read test script according to the test script template and at least one read statement;

[0041] A write test script is generated according to a test script template and at least one write statement.

[0042] In a second aspect, an embodiment of the present application provides a device for determining a target throughput, including:

[0043] An acquisition module, for acquiring a read test script and a write test script through a production server in response to a processing request;

[0044] The acquisition module is also used to obtain the actual read throughput and actual write throughput corresponding to the production server;

[0045] A processing module, used to determine a target read throughput and a target write throughput in the target throughput according to the actual read throughput and the actual write throughput; the target read throughput corresponds to the read test script, and the target write throughput corresponds to the write test script;

[0046] The processing module is further used to adjust the target throughput at least once until the test read-write ratio is consistent with the target read-write ratio; wherein the test read-write ratio is determined according to the test result; the test result is obtained by controlling the test server to execute the read test script and the write test script based on the target throughput to access the database server;

[0047] The processing module is further used to generate processing completion information; the processing completion information is used to indicate the target throughput obtained after at least one adjustment process.

[0048] In one implementation, the processing module is specifically configured to:

[0049] Based on the i-1th target read throughput and the i-1th target write throughput in the i-1th target throughput, controlling the test server to execute the read test script and the write test script to obtain the i-1th test result; the i-1th test result includes the i-1th test read throughput and the i-1th test write throughput;

[0050] Calculate the read-write ratio of the i-1th test according to the i-1th test read throughput and the i-1th test write throughput;

[0051] When it is determined that the i-1th test read-write ratio is inconsistent with the target read-write ratio, adjusting the i-1th target read throughput in the i-1th target throughput or the i-1th target write throughput in the i-1th target throughput to obtain the i-th target throughput;

[0052] Among them, i is 1, 2, ... in sequence until the i-1th test read-write ratio is consistent with the target read-write ratio; the 0th target read throughput is the target read throughput, and the 0th target write throughput is the target write throughput.

[0053] In one implementation, the processing module is specifically configured to:

[0054] When the read-write ratio of the i-1th test is greater than the target read-write ratio, the load of the write test server is obtained; the test server includes a write test server, and the write test server is a test server that executes the write test script;

[0055] Determine whether the load of the write test server is greater than the preset load;

[0056] If yes, the i-1th target read throughput in the i-1th target throughput is lowered;

[0057] If not, the i-1th target write throughput in the i-1th target throughput is increased.

[0058] In one implementation, the processing module is specifically configured to:

[0059] When the read-write ratio of the i-1th test is less than the target read-write ratio, the load of the read test server is obtained; the test server includes a read test server, and the read test server is a test server that executes the read test script;

[0060] Determine whether the load of the read test server is greater than the preset load;

[0061] If yes, the i-1th target write throughput in the i-1th target throughput is lowered;

[0062] If not, the i-1th target read throughput in the i-1th target throughput is increased.

[0063] In one implementation, the processing module is specifically configured to:

[0064] Based on the i-1th target read throughput, controlling the read test server in the test server to execute the read test script to perform access processing on the database server, and obtaining the i-1th test read throughput in the i-1th test result;

[0065] Based on the i-1th target write throughput, a write test server in the test server is controlled to execute a write test script to perform access processing on the database server to obtain the i-1th test write throughput in the i-1th test result.

[0066] In one implementation, the processing module is further configured to:

[0067] Determine a read test server among the test servers from multiple candidate servers according to the actual read throughput and the throughput corresponding to each candidate server;

[0068] According to the actual write throughput and the throughput corresponding to each candidate server, a write test server among the test servers is determined from the multiple candidate servers.

[0069] In one implementation, the processing request includes a target duration type; and the processing module is specifically configured to:

[0070] Get the candidate read-write ratio corresponding to the target duration type;

[0071] The candidate read-write ratio corresponding to the target duration type is determined as the target read-write ratio;

[0072] Determine the target read throughput based on the actual read throughput and target duration type;

[0073] Determine the target write throughput based on the actual write throughput and target duration type.

[0074] In one implementation, the acquisition module is specifically used to:

[0075] In response to the processing request, obtaining, by the production server, at least one read statement and at least one write statement;

[0076] Generate a read test script according to the test script template and at least one read statement;

[0077] A write test script is generated according to a test script template and at least one write statement.

[0078] In a third aspect, an embodiment of the present application provides a computing device, including:

[0079] A processor, and a memory communicatively connected to the processor;

[0080] Memory is used to store computer executable instructions;

[0081] The processor is used to execute the computer-executable instructions stored in the memory to implement the method of the first aspect.

[0082] In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, in which computer-executable instructions are stored. When the computer-executable instructions are executed by a processor, they are used to implement the method of the first aspect.

[0083] In a fifth aspect, an embodiment of the present application provides a computer program product, including a computer program, which is used to implement the method of the first aspect when the computer program is executed by a processor.

[0084] The embodiments of the present application provide a method, apparatus, device, medium and program product for determining a target throughput. In the method, a computing device can obtain a read test script and a write test script through a production server in response to a processing request. The computing device can obtain the actual read throughput and the actual write throughput corresponding to the production server. The computing device can determine the target read throughput and the target write throughput in the target throughput according to the actual read throughput and the actual write throughput; the target read throughput corresponds to the read test script, and the target write throughput corresponds to the write test script. The computing device can adjust the target throughput at least once until the test read-write ratio is consistent with the target read-write ratio; wherein the test read-write ratio is determined according to the test result; the test result is obtained by controlling the test server to execute the read test script and the write test script based on the target throughput to access the database server. After the adjustment is completed, the computing device can generate processing completion information, wherein the processing completion information is used to indicate the target throughput obtained after at least one adjustment process. Through the above method, on the one hand, the target throughput (target read throughput and target write throughput) can be automatically and quickly determined, thereby improving the efficiency and accuracy of determining the target throughput (target read throughput and target write throughput); on the other hand, the test read-write ratio obtained by testing based on the target throughput obtained after at least one adjustment process can be made consistent with the target read-write ratio, thereby improving the test accuracy. BRIEF DESCRIPTION OF THE DRAWINGS

[0085] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the related technologies, the following is a brief introduction to the drawings required for use in the embodiments or the related technical descriptions. Obviously, the drawings described below are some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0086] Figure 1 A schematic diagram of an application scenario applicable to an embodiment of the present application;

[0087] Figure 2 A flowchart of a method for determining a target throughput according to an embodiment of the present application;

[0088] Figure 3 A flowchart of a second embodiment of a method for determining a target throughput provided in an embodiment of the present application;

[0089] Figure 4 A flowchart of a method for determining a target throughput according to a third embodiment of the present application;

[0090] Figure 5 A flowchart of a fourth embodiment of a method for determining a target throughput provided in an embodiment of the present application;

[0091] Figure 6 A schematic diagram of the structure of a device for determining a target throughput provided in an embodiment of the present application;

[0092] Figure 7 A structural diagram of a computing device provided for this application. DETAILED DESCRIPTION

[0093] In order to make the purpose, technical solution and advantages of the embodiments of the present application clearer, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments made by ordinary technicians in this field under the enlightenment of the embodiments belong to the scope of protection of the present application.

[0094] The terms "first", "second", "third", "fourth", etc. (if any) in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0095] In the technical solution of this application, the collection, storage, use, processing, transmission, provision and disclosure of information such as financial data or user data involved shall comply with the provisions of relevant laws and regulations and shall not violate public order and good morals.

[0096] It should be noted that in the embodiments of the present application, certain software, components, models and other existing solutions in the industry may be mentioned, and they should be regarded as exemplary. Their purpose is only to illustrate the feasibility of implementing the technical solution of the present application, but it does not mean that the applicant has or will necessarily use the solution.

[0097] During the test, the target read throughput needs to be used as an input parameter of the read test script, and the target write throughput needs to be used as an input parameter of the write test script, so that the read test script and the write test script can be used to access the database server. Therefore, the target read throughput and the target write throughput need to be determined in advance.

[0098] In the related art, in the process of determining the target read throughput and the target write throughput, the tester needs to manually obtain the actual read throughput and the actual write throughput from the production server, and then manually adjust the actual read throughput and the actual write throughput based on work experience to obtain the target read throughput and the target write throughput. However, the method of the related art has the problem of low efficiency.

[0099] Based on the above technical problems, an embodiment of the present application provides a method for determining a target throughput. In this method, the computing device can first determine the actual read throughput and actual write throughput corresponding to the production server as the target read throughput and target write throughput in the target throughput, and then adjust the target throughput (target read throughput and target write throughput) at least once until the test read-write ratio is consistent with the target read-write ratio. Among them, the test read-write ratio is determined based on the test results; the test results are obtained by controlling the test server to execute a read test script and a write test script based on the target throughput to access the database server. In the above manner, the target read throughput and target write throughput can be automatically and quickly determined, which improves the efficiency and accuracy of determining the target read throughput and target write throughput.

[0100] For ease of understanding, the following Figure 1 The examples are used to illustrate the application scenarios to which the embodiments of the present application are applicable.

[0101] For example, Figure 1 Schematic diagram of an application scenario applicable to the embodiment of the present application. Figure 1 As shown, the application scenarios include:

[0102] Computing device 10 , production server 20 , and database server 30 .

[0103] The computing device 10 runs a target throughput determination device 101 , the production server 20 runs a production system 201 and stores usage logs, and the database server 30 runs a database 301 .

[0104] The computing device 10 may be connected in communication with the database server 30, and the computing device 10 may be connected in communication with the production server 20. The production server 20 may be connected in communication with the database server 30.

[0105] It should be noted that the computing device 10 may be a terminal device, a server, or a server cluster, and the embodiments of the present application are not limited to this.

[0106] It should be noted that the database server may be a single server or a server cluster consisting of multiple servers.

[0107] The technical solution of the present application is described in detail below through specific embodiments. It should be noted that the following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be described in detail in some embodiments.

[0108] Figure 2 A flowchart of a method for determining a target throughput according to an embodiment of the present application is provided. Figure 2 , the method specifically comprises the following steps:

[0109] S201: In response to a processing request, obtaining a read test script and a write test script through a production server.

[0110] In this embodiment, the computing device can obtain the read test script and the write test script through the production server in response to the processing request. In one implementation, the processing request can include a target duration type. Exemplarily, the target duration type can be a full-day type or a busy-hour type.

[0111] In one implementation,

[0112] The computing device may obtain, through the production server, at least one read statement and at least one write statement in response to the processing request.

[0113] The computing device may generate a read test script according to the test script template and at least one read statement. In one implementation, the read test script may include at least one read statement. In one implementation, the read test script may include multiple sub-read test scripts, each of which may include a read statement.

[0114] The computing device may generate a write test script according to the test script template and at least one write statement. In one implementation, the write test script may include at least one write statement. In one implementation, the write test script may include multiple sub-write test scripts, each of which may include a write statement.

[0115] In addition, it should be noted that after establishing a secure shell protocol (Secure Shell, SSH for short) connection with the production server, the computing device can obtain at least one read statement and at least one write statement through the production server.

[0116] The following describes the process of establishing an SSH connection between a computing device and a production server.

[0117] In one implementation,

[0118] The computing device can use the SSH key generation tool (ssh-keygen) to generate a pair of keys. It should be noted that in the process of generating keys by the computing device, the computing device can select the key type (such as Rivest-Shamir-Adleman (RSA), Elliptic Curve Digital Signature Algorithm (ECDSA), etc.) and the key length (such as 2048 bits, 4096 bits, etc.).

[0119] The computing device can deploy the generated public key to the production server that needs to be accessed. In one implementation, the computing device can add the public key to the ~ / .ssh / authorized_keys file of the production server.

[0120] When the computing device uses SSH to connect to the production server, the computing device can obtain encrypted challenge information (challenge) sent by the production server.

[0121] The computing device can use the key to decrypt the challenge information, generate response information, and send the response information to the production server.

[0122] The production server can verify the response information and determine to establish a connection after the verification is passed.

[0123] S202: Obtain the actual read throughput and actual write throughput corresponding to the production server.

[0124] In this embodiment, the computing device may obtain the actual read throughput and the actual write throughput corresponding to the production server. In one implementation, the actual read throughput is the actual read data volume corresponding to the preset time length of the production server. The actual write throughput is the actual write data volume corresponding to the preset time length of the production server. For example, the preset time length may be 24 hours.

[0125] The actual read throughput may include the sub-actual read throughput corresponding to each read statement.

[0126] The actual write throughput may include sub-actual write throughputs corresponding to each write statement.

[0127] S203: Determine a target read throughput and a target write throughput in the target throughput according to the actual read throughput and the actual write throughput.

[0128] In this embodiment, the computing device may determine the target read throughput and the target write throughput in the target throughput according to the actual read throughput and the actual write throughput.

[0129] The target read throughput corresponds to the read test script, and the target write throughput corresponds to the write test script.

[0130] In one implementation,

[0131] The computing device may obtain a to-be-selected read-write ratio corresponding to the target duration type. For example, the to-be-selected read-write ratio corresponding to the all-day type (duration type) is 10. For another example, the to-be-selected read-write ratio corresponding to the busy time type (duration type) is 23.

[0132] The computing device may determine the target read-write ratio to be selected corresponding to the target duration type as the target read-write ratio. For example, the computing device may determine the target read-write ratio to be 10.

[0133] The computing device may determine the target read throughput according to the actual read throughput and the target duration type.

[0134] The computing device may determine the target write throughput according to the actual write throughput and the target duration type.

[0135] The following describes a process in which a computing device determines a target read throughput based on an actual read throughput and a target duration type through a specific example.

[0136] In one implementation,

[0137] The actual read throughput is the actual read data volume of the production server in 24 hours. When the target duration type is the busy time type, the computing device can use 80% of the actual read data volume in 24 hours as the actual read data volume of 4.8 hours (24 hours * 20%) in the busy time scenario. The computing device can calculate the target read throughput in the busy time scenario based on the actual read data volume of 4.8 hours (24 hours * 20%) in the busy time scenario.

[0138] For example, if the actual read data volume in 24 hours is 10 million bytes, the computing device can determine that the actual read data volume in 4.8 hours is 8 million bytes. The computing device can determine that the target read throughput in the busy hour scenario is 463 (8 million / (4.8*3600)) bytes / second.

[0139] In one implementation,

[0140] The actual read throughput is the actual read data volume of the production server in 24 hours. When the target duration type is all-day, the computing device can directly determine the target read throughput in the all-day scenario based on the actual read data volume in 24 hours.

[0141] For example, if the actual read data volume in 24 hours is 10 million bytes, the computing device can determine that the actual read data volume in 24 hours is 10 million bytes. The computing device can determine that the target read throughput in the full-day scenario is 116 (10 million / (24*3600) bytes / second.

[0142] The following describes a process in which a computing device determines a target write throughput according to an actual write throughput and a target duration type through a specific example.

[0143] In one implementation,

[0144] The actual write throughput is the actual write data volume of the production server in 24 hours. When the target duration type is the busy type, the computing device can use 50% of the actual write data volume in 24 hours as the actual write data volume of 7.2 hours (24 hours * 30%) in the busy scenario. The computing device can calculate the target write throughput in the busy scenario based on the actual write data volume of 7.2 hours (24 hours * 30%) in the busy scenario.

[0145] For example, when the actual amount of data written in 24 hours is 2 million bytes, the computing device can determine that the actual amount of data written in 7.2 hours is 1 million bytes. The computing device can determine that the target write throughput in the busy scenario is 39 (1 million / (7.2*3600)) bytes / second.

[0146] In one implementation,

[0147] The actual write throughput is the actual write data volume of the production server in 24 hours. When the target duration type is all-day, the computing device can directly determine the target read throughput in the all-day scenario based on the actual read data volume in 24 hours.

[0148] For example, when the actual amount of data written in 24 hours is 2 million bytes, the computing device can determine that the actual amount of data written in 24 hours is 2 million bytes. The computing device can determine that the target write throughput in the full-day scenario is 23 (2 million / (24*3600) bytes / second.

[0149] S204: Adjust the target throughput at least once until the test read-write ratio is consistent with the target read-write ratio.

[0150] In this embodiment, the computing device may determine a test server from a plurality of candidate servers after adjusting the target throughput at least once until the test read-write ratio is consistent with the target read-write ratio.

[0151] Next, a process of determining a test server from a plurality of candidate servers by a computing device is described.

[0152] In one implementation,

[0153] The computing device can determine a read test server among the test servers from multiple servers to be selected based on the actual read throughput and the throughput corresponding to each server to be selected. It should be noted that in the case where the read test script includes multiple sub-read test scripts, and each sub-read test script includes a read statement, the computing device can determine at least one read test server from multiple servers to be selected. Each read test server is used to execute at least one sub-read test script. In the case where the read test script includes multiple read statements, the computing device can determine a read test server from multiple servers to be selected. The read test server is used to execute the read test script.

[0154] The computing device can determine a write test server among the test servers from multiple servers to be selected based on the actual write throughput and the throughput corresponding to each server to be selected. It should be noted that in the case where the write test script includes multiple sub-write test scripts, and each sub-write test script includes a write statement, the computing device can determine at least one write test server from multiple servers to be selected. Each write test server is used to execute at least one sub-write test script. In the case where the write test script includes multiple write statements, the computing device can determine a write test server from multiple servers to be selected. The write test server is used to execute the write test script.

[0155] After determining the test server from multiple candidate servers, the computing device may adjust the target throughput at least once until the test read-write ratio is consistent with the target read-write ratio.

[0156] The test read-write ratio is determined according to the test results.

[0157] The test results are obtained by controlling the test server to execute the read test script and the write test script based on the target throughput to access the database server.

[0158] The following describes a process in which the computing device adjusts the target throughput at least once until the test read-write ratio is consistent with the target read-write ratio.

[0159] In one implementation,

[0160] The computing device may control the test server to execute the read test script and the write test script based on the i-1th target read throughput and the i-1th target write throughput in the i-1th target throughput to obtain the i-1th test result, wherein the i-1th test result includes the i-1th test read throughput and the i-1th test write throughput.

[0161] The computing device may calculate the i-1th test read-write ratio according to the i-1th test read throughput and the i-1th test write throughput.

[0162] When determining that the i-1th test read-write ratio is inconsistent with the target read-write ratio, the computing device may adjust the i-1th target read throughput in the i-1th target throughput or the i-1th target write throughput in the i-1th target throughput to obtain the i-th target throughput. The i-th target throughput includes the i-th target read throughput and the i-th target write throughput.

[0163] Here, i is 1, 2, ..., until the i-1th test read-write ratio is consistent with the target read-write ratio. It should be noted that the 0th target read throughput is the target read throughput (the target read throughput determined according to the actual read throughput), and the 0th target write throughput is the target write throughput (the target write throughput determined according to the actual write throughput).

[0164] Beneficial effects of this embodiment: In this embodiment, the computing device can obtain a read test script and a write test script through a production server in response to a processing request. The computing device can obtain the actual read throughput and the actual write throughput corresponding to the production server. The computing device can determine the target read throughput and the target write throughput in the target throughput according to the actual read throughput and the actual write throughput; the target read throughput corresponds to the read test script, and the target write throughput corresponds to the write test script. The computing device can adjust the target throughput at least once until the test read-write ratio is consistent with the target read-write ratio; wherein the test read-write ratio is determined according to the test result; the test result is obtained by controlling the test server to execute the read test script and the write test script based on the target throughput to access the database server. The computing device can generate processing completion information after the adjustment is completed, wherein the processing completion information is used to indicate the target throughput obtained after at least one adjustment process. In the above manner, the target read throughput and the target write throughput can be automatically and quickly determined, thereby improving the efficiency and accuracy of determining the target read throughput and the target write throughput.

[0165] Figure 3This is a flow chart of a second embodiment of a method for determining a target throughput provided in an embodiment of the present application. Figure 3 , the method specifically comprises the following steps:

[0166] S301: Based on the i-1th target read throughput and the i-1th target write throughput in the i-1th target throughput, control the test server to execute the read test script and the write test script to obtain a test result.

[0167] In this embodiment, the computing device can control the test server to execute the read test script and the write test script based on the i-1th target read throughput and the i-1th target write throughput in the i-1th target throughput to obtain the i-1th test result. The i-1th test result includes the i-1th test read throughput and the i-1th test write throughput.

[0168] In one implementation,

[0169] The computing device may control the read test server in the test server to execute the read test script based on the i-1th target read throughput to access the database server and obtain the i-1th test read throughput in the i-1th test result. In one implementation, when the read test script includes multiple sub-read test scripts, each of which includes a read statement, the i-1th target read throughput includes the i-1th sub-target read throughput corresponding to each sub-read test script. For each sub-read test script, the computing device may control the read test server to execute the sub-read test script based on the i-1th sub-target read throughput corresponding to the sub-read test script to access the database server and obtain the i-1th test read throughput corresponding to the sub-read test script in the i-1th test result.

[0170] The computing device may control the write test server in the test server to execute the write test script based on the i-1th target write throughput to access the database server and obtain the i-1th test write throughput in the i-1th test result. In one implementation, when the write test script includes multiple sub-write test scripts, each of which includes a write statement, the i-1th target write throughput includes the i-1th sub-target write throughput corresponding to each sub-write test script. For each sub-write test script, the computing device may control the read test server to execute the sub-write test script based on the i-1th sub-target write throughput corresponding to the sub-write test script to access the database server and obtain the i-1th test write throughput corresponding to the sub-test script in the i-1th test result.

[0171] S302: Calculate the i-1th test read-write ratio according to the i-1th test read throughput and the i-1th test write throughput.

[0172] In this embodiment, the computing device may calculate the i-1th test read-write ratio according to the i-1th test read throughput and the i-1th test write throughput.

[0173] In one implementation, the computing device may determine a ratio of the (i-1)th test read throughput to the (i-1)th test write throughput as the (i-1)th test read-write ratio.

[0174] S303: When it is determined that the i-1th test read-write ratio is inconsistent with the target read-write ratio, adjust the i-1th target read throughput in the i-1th target throughput or the i-1th target write throughput in the i-1th target throughput to obtain the i-th target throughput.

[0175] In this embodiment, when determining that the i-1th test read-write ratio is inconsistent with the target read-write ratio, the computing device may adjust the i-1th target read throughput in the i-1th target throughput or the i-1th target write throughput in the i-1th target throughput to obtain the i-th target throughput. The i-th target throughput includes the i-th target read throughput and the i-th target write throughput.

[0176] Among them, i is 1, 2, ... in sequence until the i-1th test read-write ratio is consistent with the target read-write ratio; the 0th target read throughput is the target read throughput, and the 0th target write throughput is the target write throughput.

[0177] In one implementation,

[0178] The computing device may obtain the load of the write test server when the i-1th test read-write ratio is greater than the target read-write ratio. The test server includes a write test server, which is a test server that executes a write test script.

[0179] The computing device can determine whether the load of the write test server is greater than a preset load.

[0180] If so, the computing device may lower the i-1th target read throughput in the i-1th target throughput.

[0181] If not, the computing device may increase the i-1th target write throughput in the i-1th target throughput.

[0182] In one implementation,

[0183] The computing device may obtain the load of the read test server when the i-1th test read-write ratio is less than the target read-write ratio. The test server includes a read test server, which is a test server that executes a read test script.

[0184] The computing device may determine whether the load of the read test server is greater than a preset load.

[0185] If so, the computing device may lower the i-1th target write throughput in the i-1th target throughput.

[0186] If not, the computing device may increase the i-1th target read throughput in the i-1th target throughput.

[0187] Beneficial effects of this embodiment: The computing device can control the test server to execute the read test script and the write test script based on the i-1th target read throughput and the i-1th target write throughput in the i-1th target throughput to obtain the i-1th test result (including the i-1th test read throughput and the i-1th test write throughput). The computing device can calculate the i-1th test read-write ratio based on the i-1th test read throughput and the i-1th test write throughput, and when it is determined that the i-1th test read-write ratio is inconsistent with the target read-write ratio, adjust the i-1th target read throughput in the i-1th target throughput or the i-1th target write throughput in the i-1th target throughput to obtain the i-th target throughput. Among them, i is 1, 2, ..., until the i-1th test read-write ratio is consistent with the target read-write ratio; the 0th target read throughput is the target read throughput, and the 0th target write throughput is the target write throughput. By continuously adjusting the target throughput as described above, the target read throughput and target write throughput that can make the test read-write ratio consistent with the target read-write ratio can be quickly determined, thereby improving the efficiency and accuracy of determining the target read throughput and target write throughput, thereby improving the test efficiency.

[0188] Figure 4 This is a flow chart of a third embodiment of a method for determining a target throughput provided in an embodiment of the present application. Figure 4 , the method specifically comprises the following steps:

[0189] S401: When the test read-write ratio is greater than the target read-write ratio, obtain the load of the write test server.

[0190] In this embodiment, the computing device can obtain the load of the write test server when the test read-write ratio is greater than the target read-write ratio. It should be noted that when there are multiple write test servers, the computing device can obtain the load of each write test server when the test read-write ratio is greater than the target read-write ratio.

[0191] It should be noted that the test server used to execute the read test script and the write test script includes a write test server and a read test server.

[0192] The write test server is a test server that executes a write test script, and the read test server is a test server that executes a read test script.

[0193] S402: Determine whether the load of the write test server is greater than a preset load.

[0194] In this embodiment, after obtaining the load of the write test server, the computing device may determine whether the load of the write test server is greater than a preset load.

[0195] If yes, the computing device may execute S403;

[0196] If not, the computing device may execute S404.

[0197] In one implementation, the computing device may measure the load of the write test server by the occupancy rate of the central processing unit and the memory usage rate. For the write test server, the computing device may determine that the load of the write test server is greater than the preset load when it is determined that the occupancy rate of the central processing unit is greater than the preset occupancy rate and the memory usage rate is greater than the preset usage rate.

[0198] In one implementation, when there are multiple write test servers, the computing device may determine whether the load of each write test server is greater than a preset load.

[0199] If yes, the computing device may execute S403;

[0200] If not, the computing device may execute S404.

[0201] S403: lowering the i-1th target read throughput in the i-1th target throughput.

[0202] In this embodiment, when the computing device determines that the load of the write test server is greater than a preset load, the computing device may lower the i-1th target read throughput in the i-1th target throughput.

[0203] In one implementation, when the computing device determines that the load of the write test server is greater than a preset load, the computing device may reduce the i-1th target read throughput in the i-1th target throughput according to a preset reduction ratio.

[0204] In one implementation, when the computing device determines that the load of the write test server is greater than a preset load, the computing device may lower the i-1th target read throughput in the i-1th target throughput according to a preset lowering value.

[0205] S404: increasing the i-1th target write throughput in the i-1th target throughput.

[0206] In this embodiment, the computing device may increase the i-1th target write throughput in the i-1th target throughput when determining that the load of the write test server is less than or equal to a preset load.

[0207] In one implementation, the computing device may increase the i-1th target write throughput in the i-1th target throughput according to a preset increase ratio when determining that the load of the write test server is less than or equal to a preset load.

[0208] In one implementation, the computing device may increase the i-1th target write throughput in the i-1th target throughput according to a preset increase value when determining that the load of the write test server is less than or equal to a preset load.

[0209] Beneficial effects of this embodiment: In this embodiment, the computing device can obtain the load of the write test server when the i-1th test read-write ratio is greater than the target read-write ratio. The computing device can determine whether the load of the write test server is greater than the preset load; if so, the computing device can lower the i-1th target read throughput in the i-1th target throughput; if not, the computing device can increase the i-1th target write throughput in the i-1th target throughput. Through the above method, the selected adjustment method for the i-1th target throughput (adjusting the i-1th target write throughput or adjusting the i-1th target read throughput) can be determined based on the load situation of the write test server, and the i-1th target throughput can be accurately adjusted, thereby improving the efficiency of determining the target throughput, and then improving the efficiency of subsequent tests based on the target throughput.

[0210] Figure 5 This is a flow chart of a fourth embodiment of a method for determining a target throughput provided in an embodiment of the present application. Figure 5 , the method specifically comprises the following steps:

[0211] S501: When the test read-write ratio is less than the target read-write ratio, obtain the load of the read test server.

[0212] In this embodiment, the computing device can obtain the load of the read test server when the test read-write ratio is less than the target read-write ratio. It should be noted that when there are multiple read test servers, the computing device can obtain the load of each read test server when the test read-write ratio is less than the target read-write ratio.

[0213] The test server includes a read test server and a write test server. The read test server is a test server that executes a read test script, and the write test server is a test server that executes a write test script.

[0214] S502: Determine whether the load of the read test server is greater than a preset load.

[0215] In this embodiment, after obtaining the load of the read test server, the computing device may determine whether the load of the read test server is greater than a preset load.

[0216] If yes, the computing device may execute S503;

[0217] If not, the computing device may execute S504.

[0218] In one implementation, the computing device may measure the load of the read test server by the occupancy rate of the central processing unit and the memory usage rate. The computing device may determine that the load of the read test server is greater than the preset load when it is determined that the occupancy rate of the central processing unit is greater than the preset occupancy rate and the memory usage rate is greater than the preset usage rate.

[0219] In one implementation, when there are multiple read test servers, the computing device may determine whether the load of each read test server is greater than a preset load.

[0220] If yes, the computing device may execute S503;

[0221] If not, the computing device may execute S504.

[0222] S503: lowering the i-1th target write throughput in the i-1th target throughput.

[0223] In this embodiment, the computing device may lower the i-1th target write throughput in the i-1th target throughput when determining that the load of the read test server is greater than a preset load.

[0224] In one implementation, when the computing device determines that the load of the read test server is greater than a preset load, the computing device may reduce the i-1th target write throughput in the i-1th target throughput according to a preset reduction ratio.

[0225] In one implementation, when the computing device determines that the load of the read test server is greater than a preset load, the computing device may reduce the i-1th target write throughput in the i-1th target throughput according to a preset reduction value.

[0226] S504: increasing the i-1th target read throughput in the i-1th target throughput.

[0227] In this embodiment, the computing device may increase the i-1th target read throughput in the i-1th target throughput when determining that the load of the read test server is less than or equal to a preset load.

[0228] In one implementation, the computing device may increase the i-1th target read throughput in the i-1th target throughput according to a preset increase ratio when determining that the load of the read test server is less than or equal to a preset load.

[0229] In one implementation, the computing device may increase the i-1th target read throughput in the i-1th target throughput according to a preset increase value when determining that the load of the read test server is less than or equal to a preset load.

[0230] Beneficial effects of this embodiment: the computing device can obtain the load of the read test server when the i-1th test read-write ratio is less than the target read-write ratio. The computing device can determine whether the load of the read test server is greater than the preset load. If so, the computing device can lower the i-1th target write throughput in the i-1th target throughput; if not, the computing device can increase the i-1th target read throughput in the i-1th target throughput. Through the above method, the selected adjustment method for the i-1th target throughput (adjusting the i-1th target write throughput or adjusting the i-1th target read throughput) can be determined based on the load situation of the read test server, and the i-1th target throughput can be accurately adjusted, thereby improving the efficiency of determining the target throughput, and then improving the efficiency of subsequent tests based on the target throughput.

[0231] Figure 6 A schematic diagram of a target throughput determination device provided in an embodiment of the present application. Figure 6 As shown, the target throughput determination device 60 includes: an acquisition module 61 and a processing module 62 .

[0232] in,

[0233] An acquisition module 61, for acquiring a read test script and a write test script through a production server in response to a processing request;

[0234] The acquisition module 61 is further used to obtain the actual read throughput and the actual write throughput corresponding to the production server;

[0235] A processing module 62 is used to determine a target read throughput and a target write throughput in the target throughput according to the actual read throughput and the actual write throughput; the target read throughput corresponds to the read test script, and the target write throughput corresponds to the write test script;

[0236] The processing module 62 is further used to adjust the target throughput at least once until the test read-write ratio is consistent with the target read-write ratio; wherein the test read-write ratio is determined according to the test result; the test result is obtained by controlling the test server to execute the read test script and the write test script based on the target throughput to access the database server;

[0237] The processing module 62 is further used to generate processing completion information; the processing completion information is used to indicate the target throughput obtained after at least one adjustment process.

[0238] The target throughput determination device provided in the embodiment of the present application can execute the technical solution shown in the above method embodiment, and its implementation principle and beneficial effects are similar, which will not be repeated here.

[0239] In one implementation, the processing module 62 is specifically configured to:

[0240] Based on the i-1th target read throughput and the i-1th target write throughput in the i-1th target throughput, controlling the test server to execute the read test script and the write test script to obtain the i-1th test result; the i-1th test result includes the i-1th test read throughput and the i-1th test write throughput;

[0241] Calculate the read-write ratio of the i-1th test according to the i-1th test read throughput and the i-1th test write throughput;

[0242] When it is determined that the i-1th test read-write ratio is inconsistent with the target read-write ratio, adjusting the i-1th target read throughput in the i-1th target throughput or the i-1th target write throughput in the i-1th target throughput to obtain the i-th target throughput;

[0243] Among them, i is 1, 2, ... in sequence until the i-1th test read-write ratio is consistent with the target read-write ratio; the 0th target read throughput is the target read throughput, and the 0th target write throughput is the target write throughput.

[0244] The target throughput determination device provided in the embodiment of the present application can execute the technical solution shown in the above method embodiment, and its implementation principle and beneficial effects are similar, which will not be repeated here.

[0245] In one implementation, the processing module 62 is specifically configured to:

[0246] When the read-write ratio of the i-1th test is greater than the target read-write ratio, the load of the write test server is obtained; the test server includes a write test server, and the write test server is a test server that executes the write test script;

[0247] Determine whether the load of the write test server is greater than the preset load;

[0248] If yes, the i-1th target read throughput in the i-1th target throughput is lowered;

[0249] If not, the i-1th target write throughput in the i-1th target throughput is increased.

[0250] The target throughput determination device provided in the embodiment of the present application can execute the technical solution shown in the above method embodiment, and its implementation principle and beneficial effects are similar, which will not be repeated here.

[0251] In one implementation, the processing module 62 is specifically configured to:

[0252] When the read-write ratio of the i-1th test is less than the target read-write ratio, the load of the read test server is obtained; the test server includes a read test server, and the read test server is a test server that executes the read test script;

[0253] Determine whether the load of the read test server is greater than the preset load;

[0254] If yes, the i-1th target write throughput in the i-1th target throughput is lowered;

[0255] If not, the i-1th target read throughput in the i-1th target throughput is increased.

[0256] The target throughput determination device provided in the embodiment of the present application can execute the technical solution shown in the above method embodiment, and its implementation principle and beneficial effects are similar, which will not be repeated here.

[0257] In one implementation, the processing module 62 is specifically configured to:

[0258] Based on the i-1th target read throughput, controlling the read test server in the test server to execute the read test script to perform access processing on the database server, and obtaining the i-1th test read throughput in the i-1th test result;

[0259] Based on the i-1th target write throughput, a write test server in the test server is controlled to execute a write test script to perform access processing on the database server to obtain the i-1th test write throughput in the i-1th test result.

[0260] The target throughput determination device provided in the embodiment of the present application can execute the technical solution shown in the above method embodiment, and its implementation principle and beneficial effects are similar, which will not be repeated here.

[0261] In one implementation, the processing module 62 is further configured to:

[0262] Determine a read test server among the test servers from multiple candidate servers according to the actual read throughput and the throughput corresponding to each candidate server;

[0263] According to the actual write throughput and the throughput corresponding to each candidate server, a write test server among the test servers is determined from the multiple candidate servers.

[0264] The target throughput determination device provided in the embodiment of the present application can execute the technical solution shown in the above method embodiment, and its implementation principle and beneficial effects are similar, which will not be repeated here.

[0265] In one implementation, the processing request includes a target duration type; the processing module 62 is specifically configured to:

[0266] Get the candidate read-write ratio corresponding to the target duration type;

[0267] The candidate read-write ratio corresponding to the target duration type is determined as the target read-write ratio;

[0268] Determine the target read throughput based on the actual read throughput and target duration type;

[0269] Determine the target write throughput based on the actual write throughput and target duration type.

[0270] The target throughput determination device provided in the embodiment of the present application can execute the technical solution shown in the above method embodiment, and its implementation principle and beneficial effects are similar, which will not be repeated here.

[0271] In one implementation, the acquisition module 61 is specifically configured to:

[0272] In response to the processing request, obtaining, by the production server, at least one read statement and at least one write statement;

[0273] Generate a read test script according to the test script template and at least one read statement;

[0274] A write test script is generated according to a test script template and at least one write statement.

[0275] The target throughput determination device provided in the embodiment of the present application can execute the technical solution shown in the above method embodiment, and its implementation principle and beneficial effects are similar, which will not be repeated here.

[0276] Figure 7 This is a structural diagram of a computing device provided by this application. Figure 7 As shown, the computing device 70 includes a processor 71 and a memory 72. The processor 71 is in communication connection with the memory 72, and the memory 72 is used to store computer-executable instructions; the processor 71 is configured to execute the technical solution in any of the above method embodiments by executing the computer-executable instructions stored in the memory 72.

[0277] Optionally, the memory 72 may be independent or integrated with the processor 71. Optionally, when the memory 72 is a device independent of the processor 71, the computing device 70 may further include: a bus 73 for connecting the above devices.

[0278] The computing device is used to execute the technical solution in any of the aforementioned method embodiments, and its implementation principle and technical effects are similar and will not be repeated here.

[0279] An embodiment of the present application also provides a computer-readable storage medium, in which computer-executable instructions are stored. When the computer-executable instructions are executed by a processor, they are used to implement the technical solution provided by any of the aforementioned method embodiments.

[0280] An embodiment of the present application also provides a computer program product, including a computer program, which is used to implement the technical solution provided by the aforementioned method embodiment when executed by a processor.

[0281] Those skilled in the art can understand that all or part of the steps of implementing the above-mentioned method embodiments can be completed by hardware related to program instructions. The aforementioned program can be stored in a computer-readable storage medium. When the program is executed, the steps of the above-mentioned method embodiments are executed; and the aforementioned storage medium includes: ROM, RAM, disk or optical disk and other media that can store program codes.

[0282] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit it. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein with equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present application.

Claims

1. A method for determining a target throughput, characterized in that: include: Responsive to the processing request, obtaining a read test script and a write test script through the production server; Obtaining an actual read throughput and an actual write throughput corresponding to the production server; Determine a target read throughput and a target write throughput in a target throughput according to the actual read throughput and the actual write throughput; The target read throughput corresponds to a read test script, and the target write throughput corresponds to a write test script; The target throughput is adjusted at least once until the test read-write ratio is consistent with the target read-write ratio; wherein the test read-write ratio is determined according to the test result; the test result is obtained by controlling the test server to execute the read test script and the write test script based on the target throughput to access the database server; Generate processing completion information; the processing completion information is used to indicate the target throughput obtained after at least one adjustment process.

2. The method according to claim 1, characterized in that The step of adjusting the target throughput at least once until the test read-write ratio is consistent with the target read-write ratio includes: Based on the i-1th target read throughput and the i-1th target write throughput in the i-1th target throughput, controlling the test server to execute the read test script and the write test script to obtain an i-1th test result; the i-1th test result includes the i-1th test read throughput and the i-1th test write throughput; Calculating an i-1th test read-write ratio according to the i-1th test read throughput and the i-1th test write throughput; When it is determined that the i-1th test read-write ratio is inconsistent with the target read-write ratio, adjusting the i-1th target read throughput in the i-1th target throughput or the i-1th target write throughput in the i-1th target throughput to obtain an i-th target throughput; Among them, the i is successively 1, 2, ..., until the i-1th test read-write ratio is consistent with the target read-write ratio; the 0th target read throughput is the target read throughput, and the 0th target write throughput is the target write throughput.

3. The method according to claim 2, characterized in that The adjusting process of the target read throughput in the i-1th target throughput or the i-1th target write throughput in the i-1th target throughput includes: In the case where the i-1th test read-write ratio is greater than the target read-write ratio, obtaining the load of the write test server; the test server includes the write test server, and the write test server is a test server that executes the write test script; Determine whether the load of the write test server is greater than a preset load; If yes, the i-1th target read throughput in the i-1th target throughput is lowered; If not, the i-1th target write throughput in the i-1th target throughput is increased.

4. The method according to claim 2, characterized in that: The adjusting process of the target read throughput in the i-1th target throughput or the i-1th target write throughput in the i-1th target throughput includes: When the read-write ratio of the i-1th test is less than the target read-write ratio, obtaining the load of the read test server; the test server includes the read test server, and the read test server is a test server that executes the read test script; Determine whether the load of the read test server is greater than a preset load; If yes, the i-1th target write throughput in the i-1th target throughput is lowered; If not, the i-1th target read throughput in the i-1th target throughput is increased.

5. The method according to claim 2, characterized in that: The step of controlling the test server to execute the read test script and the write test script based on the i-1th target read throughput and the i-1th target write throughput in the i-1th target throughput to obtain the i-1th test result includes: Based on the i-1th target read throughput, controlling a read test server in the test server to execute the read test script to perform access processing on the database server, and obtaining the i-1th test read throughput in the i-1th test result; Based on the i-1th target write throughput, a write test server in the test servers is controlled to execute the write test script to perform access processing on the database server to obtain the i-1th test write throughput in the i-1th test result.

6. The method according to any one of claims 3 to 5, characterized in that: After adjusting the target throughput at least once until the test read-write ratio is consistent with the target read-write ratio, the method further includes: Determine a read test server among the test servers from a plurality of candidate servers according to the actual read throughput and the throughput corresponding to each candidate server; A write test server among the test servers is determined from a plurality of candidate servers according to the actual write throughput and the throughput corresponding to each candidate server.

7. The method according to claim 1, characterized in that The processing request includes a target duration type; and determining a target read throughput and a target write throughput in the target throughput according to the actual read throughput and the actual write throughput includes: Obtain a read-write ratio to be selected corresponding to the target duration type; Determine the to-be-selected read-write ratio corresponding to the target duration type as the target read-write ratio; Determining the target read throughput according to the actual read throughput and the target duration type; The target write throughput is determined according to the actual write throughput and the target duration type.

8. The method according to claim 1, characterized in that The step of obtaining a read test script and a write test script through a production server in response to the processing request includes: In response to the processing request, obtaining, through the production server, at least one read statement and at least one write statement; Generate the read test script according to the test script template and at least one of the read statements; The write test script is generated according to the test script template and at least one of the write statements.

9. A device for determining a target throughput, characterized in that: include: An acquisition module, for acquiring a read test script and a write test script through a production server in response to a processing request; The acquisition module is further used to acquire the actual read throughput and the actual write throughput corresponding to the production server; A processing module, configured to determine a target read throughput and a target write throughput in a target throughput according to the actual read throughput and the actual write throughput; The target read throughput corresponds to a read test script, and the target write throughput corresponds to a write test script; The processing module is further used to adjust the target throughput at least once until the test read-write ratio is consistent with the target read-write ratio; wherein the test read-write ratio is determined according to the test result; the test result is obtained by controlling the test server to execute the read test script and the write test script based on the target throughput to access the database server; The processing module is further used to generate processing completion information; the processing completion information is used to indicate the target throughput obtained after at least one adjustment process.

10. A computing device, characterized in that include: A processor, and a memory communicatively connected to the processor; The memory is used to store computer-executable instructions; The processor is configured to execute the computer-executable instructions stored in the memory to implement the method according to any one of claims 1 to 8.

11. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions, and when the computer-executable instructions are executed by a processor, they are used to implement the method according to any one of claims 1 to 8.

12. A computer program product, characterized in that The invention comprises a computer program, which is used to implement the method according to any one of claims 1 to 8 when being executed by a processor.

Images