CN114817213A - Server database tuning test method, device, terminal and storage medium - Google Patents
Server database tuning test method, device, terminal and storage medium Download PDFInfo
- Publication number
- CN114817213A CN114817213A CN202210609820.5A CN202210609820A CN114817213A CN 114817213 A CN114817213 A CN 114817213A CN 202210609820 A CN202210609820 A CN 202210609820A CN 114817213 A CN114817213 A CN 114817213A
- Authority
- CN
- China
- Prior art keywords
- test
- pressure test
- pressure
- parameter
- server database
- 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.)
- Withdrawn
Links
- 238000010998 test method Methods 0.000 title claims abstract description 22
- 238000012360 testing method Methods 0.000 claims abstract description 337
- 238000000034 method Methods 0.000 claims description 26
- 230000002159 abnormal effect Effects 0.000 claims description 17
- 230000001960 triggered effect Effects 0.000 claims description 13
- 238000012544 monitoring process Methods 0.000 claims description 11
- 230000002452 interceptive effect Effects 0.000 claims description 9
- 238000009530 blood pressure measurement Methods 0.000 abstract description 35
- 230000008569 process Effects 0.000 description 8
- 238000004891 communication Methods 0.000 description 6
- 238000013515 script Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000007423 decrease Effects 0.000 description 1
- 238000013101 initial test Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/22—Detection or location of defective computer hardware by testing during standby operation or during idle time, e.g. start-up testing
- G06F11/2268—Logging of test results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/22—Detection or location of defective computer hardware by testing during standby operation or during idle time, e.g. start-up testing
- G06F11/2273—Test methods
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Measuring Fluid Pressure (AREA)
Abstract
The invention relates to the field of server database tuning test, and particularly discloses a server database tuning test method, a device, a terminal and a storage medium, wherein a database instance for pressure test is created, and pressure test data is filled; backing up the database example filled with the pressure test data to generate a backup file; configuring test parameter items and recording parameter values of the test parameter items; triggering pressure test starting; after the pressure test is successfully completed, collecting a pressure test result, automatically adjusting the test parameter value again, copying the backed-up file, and performing a new pressure test; and analyzing all pressure test results to obtain the optimal parameter values of the database under the configured test parameter items. The invention automatically adjusts the configuration parameters and resets the pressure measurement environment without manual intervention, thereby improving the test efficiency.
Description
Technical Field
The invention relates to the field of server database tuning test, in particular to a server database tuning test method, a device, a terminal and a storage medium.
Background
And (4) carrying out database configuration on the server, wherein a stress test is an important loop, and finding the optimal configuration of the database through the stress test. The database operation pressure test is often accompanied by rapid increase of CPU utilization rate, and the current method for finding the optimal configuration is to use linux basic commands such as top, iostat and vmstat to check the service condition of system resources, then to judge where the database goes wrong, and then to adjust the database so as to obtain a better operation state. This approach requires manual intervention, takes a long time, and is inefficient.
Disclosure of Invention
In order to solve the problems, the invention provides a server database tuning test method, a device, a terminal and a storage medium, which can automatically adjust configuration parameters and reset a pressure test environment without manual intervention and improve test efficiency.
In a first aspect, a technical solution of the present invention provides a server database tuning test method, including the following steps:
creating a database example for pressure test, and filling pressure test data;
backing up the database example filled with the pressure test data to generate a backup file;
configuring test parameter items and recording parameter values of the test parameter items;
triggering the pressure test to start;
after the pressure test is successfully completed, collecting a pressure test result, automatically adjusting the test parameter value again, copying the backed-up file, and performing a new pressure test;
and analyzing all pressure test results to obtain the optimal parameter values of the database under the configured test parameter items.
Further, the method specifically comprises the following steps:
monitoring the pressure test state, and judging whether the pressure test is successfully completed;
if the pressure test is successfully completed, collecting a pressure test result, readjusting a test parameter value, copying the backed-up file, and performing a new pressure test;
and if the pressure test is not completed successfully, sending an exception log.
Further, the method comprises the following steps:
analyzing the abnormal log and judging whether to continue the pressure test;
if the pressure test is not required to be continued, ending the pressure test;
if the pressure test needs to be continued, the test parameters are reconfigured, the parameter values are recorded, and the pressure test is triggered to start again.
Further, the method specifically comprises the following steps:
configuring test parameter items through a pressure test calling program interactive interface and inputting parameter values of all the test parameter items;
and after the pressure test of the one-class configuration test parameter item is finished, the next-class test parameter item configuration is carried out, and the pressure test is triggered to start again.
In a second aspect, an embodiment of the present invention provides a server database tuning test apparatus, including,
an instance creation module: creating a database example for pressure test, and filling pressure test data;
the file backup module: backing up the database example filled with the pressure test data to generate a backup file;
a parameter configuration module: configuring test parameter items and recording parameter values of the test parameter items;
the test triggering module: triggering the pressure test to start;
a result collection and parameter adjustment module: after the pressure test is successfully completed, collecting a pressure test result, readjusting a test parameter value, copying the backed-up file, and performing a new pressure test;
an optimal parameter value acquisition module: and analyzing all pressure test results to obtain the optimal parameter values of the database under the configured test parameter items.
Further, the device also comprises a control device,
pressure test monitoring module: monitoring the pressure test state, and judging whether the pressure test is successfully completed;
an exception log issuing module: if the pressure test is not completed successfully, an abnormal log is sent out;
and if the pressure test is completed successfully, triggering the result collection and parameter adjustment module to execute.
Further, the device also comprises a control device,
an exception log analysis module: analyzing the abnormal log and judging whether to continue the pressure test;
a pressure test ending module: if the pressure test is not required to be continued, ending the pressure test;
and if the pressure test needs to be continued, triggering the parameter configuration module to reconfigure the test parameters and record parameter values, and triggering the pressure test to start again.
Furthermore, the parameter configuration module configures the test parameter items through the interactive interface of the pressure test calling program and inputs the parameter values of each test parameter item;
and after the pressure test of the one-class configuration test parameter item is finished, the next-class test parameter item configuration is carried out, and the pressure test is triggered to start again.
In a third aspect, a technical solution of the present invention provides a terminal, including:
the memory is used for storing the tuning test program of the server database;
and the processor is used for realizing the steps of the server database tuning test method in any one of the above steps when the server database tuning test program is executed.
In a fourth aspect, the present invention provides a computer-readable storage medium, where a server database tuning test program is stored on the computer-readable storage medium, and when executed by a processor, the server database tuning test program implements the steps of the server database tuning test method according to any one of the above items.
Compared with the prior art, the server database tuning test method, the device, the terminal and the storage medium provided by the invention have the following beneficial effects: the tester carries out the configuration of initial parameters, then the pressure test automatically runs, and the configuration parameters are automatically adjusted during the new pressure test without manual intervention; meanwhile, the data file is backed up, and when a new round of pressure test is carried out, the backed-up data file is copied to reset the pressure test environment without manual intervention. The invention automatically adjusts the configuration parameters and resets the pressure measurement environment without manual intervention, thereby improving the test efficiency.
Drawings
For a clearer explanation of the embodiments or technical solutions of the prior art of the present application, the drawings needed for the description of the embodiments or prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
Fig. 1 is a schematic flow chart of a server database tuning test method according to an embodiment of the present invention.
Fig. 2 is a block diagram illustrating a structure of a server database tuning test apparatus according to an embodiment of the present invention.
Fig. 3 is a schematic structural diagram of a terminal according to an embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the disclosure, the following detailed description will be given with reference to the accompanying drawings. It is to be understood that the embodiments described are only a few embodiments of the present application and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The core of the invention is that the optimal configuration of the database on the machine type is quickly found by configuring different database configuration parameters and parameter values, the parameter values can be automatically configured in the test process, and the test environment is automatically configured by using the backup database example without manual parameters, thereby improving the working efficiency.
Fig. 1 is a schematic flowchart of a method for testing tuning of a server database according to an embodiment of the present invention, and as shown in fig. 1, the method includes the following steps.
S101, creating a database example for pressure testing, and filling pressure testing data.
It can be understood that the database is subjected to pressure test, and a database instance is created in advance, and meanwhile, pressure test data is filled in the database instance.
And S102, backing up the database example filled with the pressure test data to generate a backup file.
And after the database examples are filled with the pressure test data, backing up the database examples filled with the pressure test data to generate a backup file. The backup file is copied when the pressure test environment is reset, and the copied backup file is used for carrying out pressure test again, so that pressure test data do not need to be filled again, manual participation is not needed, and the test efficiency is improved.
S103, configuring the test parameter items and recording the parameter values of the test parameter items.
Preparing a test case, and configuring test parameters, including configuring test parameter items, that is, configuring which class parameters, and configuring parameter values of each test parameter item.
It should be noted that, during the initial test, the initial values of the test parameter items are configured here, and may be configured manually, and then when a new round of pressure test is continued, the automatic pressure test script automatically completes the adjustment and modification of the test parameter values, without manual participation.
And S104, triggering the pressure test to start.
And preparing an example, and triggering the pressure test to start after initial parameters and environment are configured, so as to start the pressure test.
The stress test may be performed by 100 concurrent tests.
And S105, after the pressure test is successfully completed, collecting a pressure test result, automatically adjusting the test parameter value again, and copying the backed-up file to perform a new pressure test.
After each pressure test is successfully completed, collecting the results of the pressure test for subsequent analysis, simultaneously readjusting the test parameter values, copying the backed-up files, configuring the test environment, and performing a new pressure test.
It should be noted that, in the method, an automatic pressure measurement script is used, and an adjustment rule of a test parameter value is stored in the automatic pressure measurement script, for example, 1 is added each time, a specific adjustment rule may be determined according to a specific actual situation and a user requirement, and different rules do not affect implementation of the embodiment of the present application.
And S106, analyzing all pressure test results, and acquiring the optimal parameter values of the database under the configured test parameter items.
And after all the pressure tests are executed, finding out the optimal parameter values under the configured test parameter items according to the collected test results. It can be understood that the test parameter items are configured, each pressure test corresponds to a group of test parameter values, and the pressure test results are analyzed to find out the optimal parameter value corresponding to different pressure test results.
According to the server database tuning test method provided by the embodiment of the invention, a tester configures initial parameters, then the pressure test automatically runs, and the configuration parameters are automatically adjusted in a new pressure test without manual intervention; meanwhile, the data file is backed up, and when a new round of pressure test is carried out, the backed-up data file is copied to reset the pressure test environment without manual intervention. The invention automatically adjusts the configuration parameters and resets the pressure measurement environment without manual intervention, thereby improving the test efficiency.
On the basis of the above embodiment, as a preferred implementation, the method specifically includes:
monitoring the pressure test state, and judging whether the pressure test is successfully completed;
if the pressure test is successfully completed, collecting a pressure test result, readjusting a test parameter value, copying the backed-up file, and performing a new pressure test;
and if the pressure test is not completed successfully, sending an exception log.
And during pressure testing, monitoring the state of the pressure testing in real time, detecting whether the pressure testing is abnormal or not, further judging whether the pressure testing is successfully completed or not, collecting the pressure testing result on the premise of successfully completing the pressure testing, readjusting the testing parameter value, and copying the backed-up file to perform a new round of pressure testing. If the pressure test is not completed successfully, namely an exception occurs, an exception log is thrown out so as to analyze and judge the exception condition in the following process.
On the basis of the above embodiment, as a preferred implementation, the method further includes:
analyzing the abnormal log and judging whether to continue the pressure test;
if the pressure test is not required to be continued, ending the pressure test;
if the pressure test needs to be continued, the test parameters are reconfigured, the parameter values are recorded, and the pressure test is triggered to start again.
If the database is abnormal in the pressure test, the abnormal log is thrown out, and then the abnormal log is analyzed, so that whether the pressure test needs to be continued or not can be judged according to the abnormal type and the specific abnormal condition. If the pressure test is not required to be continuously carried out, the pressure test interface is directly ended, if the pressure test is required to be continuously carried out, the test parameters are required to be reconfigured, the parameter values are input, the pressure test is triggered to be started again, and it needs to be noted that the configuration of the test parameter values can be automatically adjusted and finished without manual intervention.
On the basis of the above embodiment, as a preferred implementation, the method further includes:
configuring test parameter items through a pressure test calling program interactive interface and inputting parameter values of all the test parameter items;
and after the pressure test of the one-class configuration test parameter item is finished, the next-class test parameter item configuration is carried out, and the pressure test is triggered to start again.
It can be understood that before the test starts, the test parameter items and the parameter values need to be manually configured, the test parameter items are manually configured through the interactive interface of the pressure test calling program, the parameter values of the test parameter items are input, and then the automatic pressure test process is started. And the pressure measurement calling program interactive interface can be scheduled by using java development application and can also be scheduled by using shell scripts. The user can configure different types of test parameter items according to different requirements, and each type of test parameter item is configured to perform the pressure test again. Wherein each type of test parameter item may comprise a plurality of test parameter items.
In order to further understand the present invention, a specific embodiment is provided below to further illustrate the present invention. This embodiment includes the following steps.
Step one, preparing a pressure measurement environment, and deploying a database and tools such as benchmarks ql and nmon on a server. An instance of a database for pressure measurements is also created. And (5) filling pressure measurement data. And placing the automatic pressure measurement script on a pressure measurement machine.
And step two, backing up the data file of the pressure measurement database instance.
Backed up is a data file of the pressure measurement data that has been injected. The backup file is copied when the pressure measurement environment is reset, pressure measurement can be carried out again only by modifying the configuration parameters, and pressure measurement data do not need to be filled again.
And step three, inputting configuration parameters and different parameter values through a pressure measurement calling program interactive interface, and then entering an automatic pressure measurement process.
The interaction can be scheduled by java development application or by shell script.
And step four, 100, starting pressure measurement.
After the step, entering a program automatic pressure testing process, and carrying out 100 concurrent pressure tests according to the input initial parameter value 1.
And step five, judging whether the pressure measurement is successful.
And collecting the pressure measurement result while the pressure measurement is successful. And if the pressure measurement fails, throwing an abnormal log to analyze the problem.
And step six, after the pressure measurement is successful and the pressure measurement result is collected, the configuration parameters of the database are adjusted again. And entering the next round of pressure measurement process.
And step seven, resetting the pressure measurement environment, wherein after the previous pressure measurement, the database size is increased, new filling data is needed for pressure measurement, and the process can replace the existing data file by using the data file backed up before and then substitute the data file into the configuration file of the configuration parameters of the new pressure measurement. The database is then restarted in preparation for a new round of pressure testing.
Analyzing the pressure measurement result, when all pressure measurement scenes are tested, analyzing the performance index and the trend chart of the database according to the collected pressure measurement result, and finding out the optimal parameter value of the type of configuration parameter, wherein the type of parameter value is not necessarily the parameter with the optimal performance of the database, and the configuration parameter must meet the linear increase, the performance of the database does not decline along with the change of the parameter or the performance tends to be stable, and the configuration parameter value is always maintained at a high processing capacity level.
The above embodiment of the server database tuning test method is described in detail, and based on the server database tuning test method described in the above embodiment, the embodiment of the present invention further provides a server database tuning test apparatus corresponding to the method.
Fig. 2 is a schematic block diagram of a server database tuning test apparatus according to an embodiment of the present invention, and as shown in fig. 2, the apparatus includes: the system comprises an example creating module 101, a file backup module 102, a parameter configuration module 103, a test triggering module 104, a result collecting and parameter adjusting module 105, an optimal parameter value acquiring module 106, a pressure test monitoring module 107, an abnormal log sending module 108, an abnormal log analyzing module 109 and a pressure test ending module 110.
The instance creation module 101: and creating a database example for the pressure test, and filling pressure test data.
The file backup module 102: and backing up the database example filled with the pressure test data to generate a backup file.
The parameter configuration module 103: configuring test parameter items and recording parameter values of the test parameter items.
The parameter configuration module 103 configures test parameter items through a pressure test calling program interactive interface and inputs parameter values of each test parameter item; and after the pressure test of the one-class configuration test parameter item is finished, the next-class test parameter item configuration is carried out, and the pressure test is triggered to start again.
The test trigger module 104: triggering the pressure test to start.
The result collection and parameter adjustment module 105: and after the pressure test is successfully completed, collecting a pressure test result, readjusting test parameter values, and copying the backed-up file to perform a new pressure test.
The optimal parameter value obtaining module 106: and analyzing all pressure test results to obtain the optimal parameter values of the database under the configured test parameter items.
Pressure test monitoring module 107: and monitoring the pressure test state, and judging whether the pressure test is successfully completed.
The exception log issuance module 108: and if the pressure test is not completed successfully, sending an exception log.
If the pressure test is successfully completed, the result collection and parameter adjustment module 105 is triggered to execute.
The anomaly log analysis module 109: and analyzing the abnormal log and judging whether to continue the pressure test.
End of stress test module 110: and if the pressure test does not need to be continued, ending the pressure test.
If the pressure test needs to be continued, the parameter configuration module 103 is triggered to reconfigure the test parameters and record parameter values, and the pressure test is triggered to start again.
The server database tuning test device of this embodiment is used to implement the foregoing server database tuning test method, so that the specific implementation manner in the device can be seen in the foregoing embodiment section of the server database tuning test method, and therefore, the specific implementation manner thereof may refer to the description of the corresponding partial embodiments, and is not described herein again.
In addition, since the server database tuning test apparatus of this embodiment is used to implement the foregoing server database tuning test method, its role corresponds to that of the foregoing method, and details are not described here.
Fig. 3 is a schematic structural diagram of a terminal device 300 according to an embodiment of the present invention, including: a processor 310, a memory 320, and a communication unit 330. The processor 310 is configured to implement the server database tuning test program stored in the memory 320, and implement the following steps:
creating a database example for pressure test, and filling pressure test data;
backing up the database example filled with the pressure test data to generate a backup file;
configuring test parameter items and recording parameter values of the test parameter items;
triggering the pressure test to start;
after the pressure test is successfully completed, collecting a pressure test result, automatically adjusting the test parameter value again, copying the backed-up file, and performing a new pressure test;
and analyzing all pressure test results to obtain the optimal parameter values of the database under the configured test parameter items.
According to the invention, a tester carries out configuration of initial parameters, then the pressure test automatically runs, and the configuration parameters are automatically adjusted in a new pressure test without manual intervention; meanwhile, the data file is backed up, and when a new round of pressure test is carried out, the backed-up data file is copied to reset the pressure test environment without manual intervention. The invention automatically adjusts the configuration parameters and resets the pressure measurement environment without manual intervention, thereby improving the test efficiency.
The terminal device 300 includes a processor 310, a memory 320, and a communication unit 330. The components communicate via one or more buses, and those skilled in the art will appreciate that the architecture of the servers shown in the figures is not intended to be limiting, and may be a bus architecture, a star architecture, a combination of more or less components than those shown, or a different arrangement of components.
The memory 320 may be used for storing instructions executed by the processor 310, and the memory 320 may be implemented by any type of volatile or non-volatile storage terminal or combination thereof, such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic disk or optical disk. The executable instructions in memory 320, when executed by processor 310, enable terminal 300 to perform some or all of the steps in the method embodiments described below.
The processor 310 is a control center of the storage terminal, connects various parts of the entire electronic terminal using various interfaces and lines, and performs various functions of the electronic terminal and/or processes data by operating or executing software programs and/or modules stored in the memory 320 and calling data stored in the memory. The processor may be composed of an Integrated Circuit (IC), for example, a single packaged IC, or a plurality of packaged ICs connected with the same or different functions. For example, the processor 310 may include only a Central Processing Unit (CPU). In the embodiment of the present invention, the CPU may be a single operation core, or may include multiple operation cores.
A communication unit 330, configured to establish a communication channel so that the storage terminal can communicate with other terminals. And receiving user data sent by other terminals or sending the user data to other terminals.
Embodiments of the present invention further provide a computer storage medium, where the storage medium may be a magnetic disk, an optical disk, a read-only memory (ROM) or a Random Access Memory (RAM).
The computer storage medium stores a server database tuning test program that when executed by a processor performs the steps of:
creating a database example for pressure test, and filling pressure test data;
backing up the database example filled with the pressure test data to generate a backup file;
configuring test parameter items and recording parameter values of the test parameter items;
triggering the pressure test to start;
after the pressure test is successfully completed, collecting a pressure test result, automatically adjusting the test parameter value again, copying the backed-up file, and performing a new pressure test;
and analyzing all pressure test results to obtain the optimal parameter values of the database under the configured test parameter items.
According to the invention, a tester carries out configuration of initial parameters, then the pressure test automatically runs, and the configuration parameters are automatically adjusted in a new pressure test without manual intervention; meanwhile, the data file is backed up, and when a new round of pressure test is carried out, the backed-up data file is copied to reset the pressure test environment without manual intervention. The invention automatically adjusts the configuration parameters and resets the pressure measurement environment without manual intervention, thereby improving the test efficiency.
Those skilled in the art will readily appreciate that the techniques of the embodiments of the present invention may be implemented as software plus a required general purpose hardware platform. Based on such understanding, the technical solutions in the embodiments of the present invention may be embodied in the form of a software product, where the computer software product is stored in a storage medium, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and the like, and the storage medium can store program codes, and includes instructions for enabling a computer terminal (which may be a personal computer, a server, or a second terminal, a network terminal, and the like) to perform all or part of the steps of the method in the embodiments of the present invention.
In the embodiments provided in the present invention, it should be understood that the disclosed system, apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.
The above disclosure is only for the preferred embodiments of the present invention, but the present invention is not limited thereto, and any non-inventive changes that can be made by those skilled in the art and several modifications and amendments made without departing from the principle of the present invention shall fall within the protection scope of the present invention.
Claims (10)
1. A server database tuning test method is characterized by comprising the following steps:
creating a database example for pressure test, and filling pressure test data;
backing up the database example filled with the pressure test data to generate a backup file;
configuring test parameter items and recording parameter values of the test parameter items;
triggering the pressure test to start;
after the pressure test is successfully completed, collecting a pressure test result, automatically adjusting the test parameter value again, copying the backed-up file, and performing a new pressure test;
and analyzing all pressure test results to obtain the optimal parameter values of the database under the configured test parameter items.
2. The server database tuning test method according to claim 1, wherein the method specifically comprises the steps of:
monitoring the pressure test state, and judging whether the pressure test is successfully completed;
if the pressure test is successfully completed, collecting a pressure test result, readjusting a test parameter value, copying the backed-up file, and performing a new pressure test;
and if the pressure test is not completed successfully, sending an exception log.
3. The server database tuning test method of claim 2, further comprising the steps of:
analyzing the abnormal log and judging whether to continue the pressure test;
if the pressure test is not required to be continued, ending the pressure test;
if the pressure test needs to be continued, the test parameters are reconfigured, the parameter values are recorded, and the pressure test is triggered to start again.
4. The server database tuning test method according to claim 3, wherein the method specifically comprises:
configuring test parameter items through a pressure test calling program interactive interface and inputting parameter values of all the test parameter items;
and after the pressure test of the one-class configuration test parameter item is finished, the next-class test parameter item configuration is carried out, and the pressure test is triggered to start again.
5. A server database tuning test device is characterized by comprising,
an instance creation module: creating a database example for pressure test, and filling pressure test data;
the file backup module: backing up the database example filled with the pressure test data to generate a backup file;
a parameter configuration module: configuring test parameter items and recording parameter values of the test parameter items;
the test triggering module: triggering the pressure test to start;
a result collection and parameter adjustment module: after the pressure test is successfully completed, collecting a pressure test result, readjusting a test parameter value, copying the backed-up file, and performing a new pressure test;
an optimal parameter value acquisition module: and analyzing all pressure test results to obtain the optimal parameter values of the database under the configured test parameter items.
6. The server database tuning test apparatus of claim 5, further comprising,
pressure test monitoring module: monitoring the pressure test state, and judging whether the pressure test is successfully completed;
an exception log issuing module: if the pressure test is not completed successfully, an abnormal log is sent out;
and if the pressure test is successfully completed, triggering the result collection and parameter adjustment module to execute.
7. The server database tuning test device of claim 6, further comprising,
an exception log analysis module: analyzing the abnormal log and judging whether to continue the pressure test;
a pressure test ending module: if the pressure test is not required to be continued, ending the pressure test;
and if the pressure test needs to be continued, triggering the parameter configuration module to reconfigure the test parameters and record parameter values, and triggering the pressure test to start again.
8. The server database tuning test device according to claim 7, wherein the parameter configuration module configures the test parameter items through the press test calling program interactive interface and enters parameter values of each test parameter item;
and after the pressure test of the one-class configuration test parameter item is finished, the next-class test parameter item configuration is carried out, and the pressure test is triggered to start again.
9. A terminal, comprising:
the memory is used for storing the tuning test program of the server database;
a processor for implementing the steps of the server database tuning test method according to any one of claims 1-4 when executing the server database tuning test program.
10. A computer-readable storage medium, having stored thereon a server database tuning test program, which when executed by a processor, performs the steps of the server database tuning test method according to any one of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210609820.5A CN114817213A (en) | 2022-05-31 | 2022-05-31 | Server database tuning test method, device, terminal and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210609820.5A CN114817213A (en) | 2022-05-31 | 2022-05-31 | Server database tuning test method, device, terminal and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114817213A true CN114817213A (en) | 2022-07-29 |
Family
ID=82519007
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210609820.5A Withdrawn CN114817213A (en) | 2022-05-31 | 2022-05-31 | Server database tuning test method, device, terminal and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114817213A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115292097A (en) * | 2022-08-22 | 2022-11-04 | 广州鼎甲计算机科技有限公司 | Database instance creation method, database instance creation apparatus, database instance creation device, storage medium, and program product |
| CN117271318A (en) * | 2023-09-13 | 2023-12-22 | 广州融朋信息科技有限公司 | Database compatibility testing method and device |
-
2022
- 2022-05-31 CN CN202210609820.5A patent/CN114817213A/en not_active Withdrawn
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115292097A (en) * | 2022-08-22 | 2022-11-04 | 广州鼎甲计算机科技有限公司 | Database instance creation method, database instance creation apparatus, database instance creation device, storage medium, and program product |
| CN117271318A (en) * | 2023-09-13 | 2023-12-22 | 广州融朋信息科技有限公司 | Database compatibility testing method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN114817213A (en) | Server database tuning test method, device, terminal and storage medium | |
| CN111428431A (en) | Method and system for supporting automatic test and recording of EDA (electronic design automation) software | |
| CN113419747A (en) | Middleware deployment method, device, equipment and storage medium | |
| CN106776165A (en) | Server performance method of testing and system | |
| CA3127343A1 (en) | Test data acquisition method and device, computer equipment and storage medium | |
| CN111966551A (en) | Method, system, terminal and storage medium for verifying remote command execution result | |
| CN112269697B (en) | Equipment storage performance testing method, system and related device | |
| CN116909800B (en) | Method and device for locating crash information and storage medium | |
| CN114064465A (en) | Stability testing method based on Linux cloud platform | |
| CN113238935A (en) | Application testing method, system, device, medium, and computer program product | |
| CN112148599A (en) | Performance pressure measurement method, device and equipment | |
| CN111639022A (en) | Transaction testing method and device, storage medium and electronic device | |
| CN113722240B (en) | Stability testing method and system for linux operating system management platform | |
| CN111176917A (en) | Method, system, terminal and storage medium for testing functional stability of CPU SST-BF | |
| CN116087752A (en) | Chip testing method, system, device and medium | |
| CN110543394A (en) | server sensor information consistency testing method, system, terminal and storage medium | |
| CN116302989A (en) | Pressure testing method and system, storage medium and computer equipment | |
| CN111666200A (en) | Testing method and terminal for time consumption of cold start of PC software | |
| CN115455431A (en) | Method, device, terminal and medium for automatic code security detection and vulnerability repair | |
| CN111400117B (en) | Method for automatically testing Ceph cluster | |
| CN114461458A (en) | Server memory test method, system, terminal and storage medium | |
| CN112346994A (en) | Test information correlation method and device, computer equipment and storage medium | |
| CN113485933A (en) | Automatic testing method and distributed system | |
| CN108989144B (en) | Method and system for testing NAS cluster reset under Linux | |
| CN111858198A (en) | Multi-scheme memory plugging test method, system, terminal 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 | ||
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20220729 |