CN110795319A - Performance test method, device and equipment of memory database and readable storage medium - Google Patents
Performance test method, device and equipment of memory database and readable storage medium Download PDFInfo
- Publication number
- CN110795319A CN110795319A CN201910931688.8A CN201910931688A CN110795319A CN 110795319 A CN110795319 A CN 110795319A CN 201910931688 A CN201910931688 A CN 201910931688A CN 110795319 A CN110795319 A CN 110795319A
- Authority
- CN
- China
- Prior art keywords
- database
- memory database
- transaction processing
- test
- performance
- 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
- 238000011056 performance test Methods 0.000 title claims abstract description 87
- 238000000034 method Methods 0.000 title claims abstract description 34
- 238000012360 testing method Methods 0.000 claims abstract description 211
- 238000012545 processing Methods 0.000 claims abstract description 128
- 238000004590 computer program Methods 0.000 claims description 10
- 230000000694 effects Effects 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- WVCHIGAIXREVNS-UHFFFAOYSA-N 2-hydroxy-1,4-naphthoquinone Chemical compound C1=CC=C2C(O)=CC(=O)C(=O)C2=C1 WVCHIGAIXREVNS-UHFFFAOYSA-N 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000012854 evaluation process Methods 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3466—Performance evaluation by tracing or monitoring
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3003—Monitoring arrangements specially adapted to the computing system or computing system component being monitored
- G06F11/302—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system component is a software system
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computing Systems (AREA)
- Quality & Reliability (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computer Hardware Design (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention discloses a performance test method of a memory database, which is applied to a preset master file and comprises the following steps: analyzing the received memory database performance test request to obtain target test duration; controlling each slave file to perform database transaction processing operation of target test duration on a memory database according to preset configuration information to obtain database transaction processing amount corresponding to each slave file; carrying out statistical operation on the database transaction processing amount of each slave file to obtain the total database transaction processing amount of the memory database in the target test duration; and performing performance test on the memory database according to the total transaction processing amount of the database to obtain a test result. The invention can better reflect the performance of the memory database in online transaction and improve the intuitiveness of the performance test of the memory database. The invention also discloses a performance testing device, equipment and a storage medium of the memory database, and the device, the equipment and the storage medium have corresponding technical effects.
Description
Technical Field
The present invention relates to the field of database technologies, and in particular, to a method, an apparatus, a device, and a computer-readable storage medium for testing performance of a memory database.
Background
With the development of internet technology, the memory capacity that an enterprise server can support is increased sharply, and in addition, with the increase of the data volume of an enterprise, the disk performance of a disk database represented by an Oracle database becomes a bottleneck. The market for memory database products, represented by a High-Performance analytical application (SAP HANA), is increasing. All data are stored in the memory by the memory database, and the transaction processing of all the databases does not have the operation of disk IO reading and writing, so that the performance of the databases can be greatly improved.
The existing performance test mode of the memory database in online transaction is to evaluate the performance of the memory database by analyzing the table structure in a TPC-C test model, executing a single SQL statement and counting the execution time of the SQL statement. The method can only evaluate the single SQL processing capacity of the memory database, cannot well reflect the performance of the memory database in online transaction, and has the defects of non-visual performance test of the memory database and poor user experience.
In summary, how to effectively solve the problems that the performance of the memory database in online transaction cannot be well reflected, the performance test of the memory database is not intuitive, the user experience is poor, and the like is a problem that needs to be solved by those skilled in the art at present.
Disclosure of Invention
The invention aims to provide a performance test method of a memory database, which can better reflect the performance of the memory database in online transaction and improve the intuitiveness of the performance test of the memory database; another object of the present invention is to provide a device, an apparatus and a computer readable storage medium for testing the performance of an in-memory database.
In order to solve the technical problems, the invention provides the following technical scheme:
a performance test method of a memory database is applied to a preset master file and comprises the following steps:
receiving a memory database performance test request sent by a pre-created test user, and analyzing the memory database performance test request to obtain a target test duration;
controlling each slave file to perform database transaction processing operation of the target test duration on a memory database according to preset configuration information in a pre-created test usage table to obtain database transaction processing amounts corresponding to each slave file;
performing statistical operation on the database transaction processing amount of each slave file by using a pre-created result statistical table to obtain the total database transaction processing amount of the memory database in the target test duration;
and performing performance test on the memory database according to the total transaction processing amount of the database to obtain a performance test result.
In a specific embodiment of the present invention, controlling each slave file to perform a database transaction operation of the target test duration on a memory database according to preset configuration information in a pre-created test usage table includes:
and controlling each slave file to perform database transaction processing operation of the target test duration on the memory database according to preset configuration information in a pre-created test use table and the index of the test use table.
In one embodiment of the present invention, the method further comprises:
adjusting the database transaction type proportion of each slave file to obtain an adjusted database transaction processing task corresponding to each slave file;
controlling each slave file to perform database transaction processing operation of the target test duration according to the respectively corresponding adjusted database transaction processing tasks;
acquiring the adjusted database transaction processing total amount of the memory database in the target test duration;
repeatedly executing the step of adjusting the database transaction type proportion of each slave file until obtaining the adjusted database transaction total amount of preset times, and performing performance test on the memory database according to the database transaction total amount, wherein the step of adjusting the database transaction type proportion of each slave file comprises the following steps:
and performing performance test on the memory database by combining the total database transaction processing amount and each adjusted total database transaction processing amount.
In a specific embodiment of the present invention, analyzing the memory database performance test request to obtain a target test duration includes:
analyzing the memory database performance test request to obtain the target test duration and the target identity information of the test user;
before controlling each slave file to perform database transaction processing operation of the target test duration on the memory database according to the preset configuration information in the pre-created test usage table, the method further includes:
performing authority authentication on the target identity information to obtain an authority authentication result;
and when the permission authentication result is determined to be passed, executing a step of controlling each slave file to perform database transaction processing operation of the target test duration on the memory database according to preset configuration information in a pre-created test use table.
A performance testing device of a memory database is applied to a preset master file and comprises the following components:
the request analysis module is used for receiving a memory database performance test request sent by a pre-created test user and analyzing the memory database performance test request to obtain a target test duration;
the transaction processing operation module is used for controlling each slave file to perform database transaction processing operation of the target test duration on the memory database according to preset configuration information in the pre-created test use table to obtain database transaction processing amount corresponding to each slave file;
a transaction total obtaining module, configured to perform a statistical operation on the database transaction amount of each slave file by using a pre-created result statistical table, to obtain a database transaction total of the memory database within the target test duration;
and the test result obtaining module is used for carrying out performance test on the memory database according to the total transaction processing amount of the database to obtain a performance test result.
In a specific embodiment of the present invention, the transaction processing operation module is specifically a module that controls each slave file to perform a database transaction processing operation on the memory database for the target test duration according to preset configuration information in a pre-created test usage table and an index of the test usage table.
In one embodiment of the present invention, the method further comprises:
the transaction type proportion adjusting module is used for adjusting the database transaction type proportion of each slave file to obtain an adjusted database transaction processing task corresponding to each slave file;
the transaction processing operation module is further configured to control each slave file to perform database transaction processing operation of the target test duration according to the respectively corresponding adjusted database transaction processing tasks;
the transaction total amount obtaining module is further configured to obtain the adjusted database transaction total amount of the memory database within the target test duration;
the performance testing module is specifically a module for performing performance testing on the memory database by combining the database transaction total amount and each adjusted database transaction total amount to obtain a performance testing result.
In a specific embodiment of the present invention, the request parsing module is a module that parses the memory database performance test request to obtain the target test duration and the target identity information of the test user;
the performance testing apparatus further includes:
the authority authentication result obtaining module is used for carrying out authority authentication on the target identity information to obtain an authority authentication result before controlling each slave file to carry out database transaction processing operation of the target test duration on the memory database according to preset configuration information in a pre-established test use table;
the transaction processing operation module is specifically a module for controlling each slave file to perform database transaction processing operation of the target test duration on the memory database according to preset configuration information in a pre-created test usage table when the permission authentication result is determined to pass.
A performance testing apparatus of an in-memory database, comprising:
a memory for storing a computer program;
and the processor is used for realizing the steps of the performance testing method of the memory database when the computer program is executed.
A computer-readable storage medium, having stored thereon a computer program which, when being executed by a processor, carries out the steps of the method for performance testing of an in-memory database as set forth above.
The invention provides a performance test method of a memory database, which comprises the following steps: the method comprises the steps of applying the method to a preset master file, receiving a memory database performance test request sent by a pre-established test user, and analyzing the memory database performance test request to obtain a target test duration; controlling each slave file to perform database transaction processing operation with target test duration on the memory database according to preset configuration information in a pre-created test use table to obtain database transaction processing amount corresponding to each slave file; carrying out statistical operation on the database transaction processing amount of each slave file by using a pre-created result statistical table to obtain the database transaction processing total amount of the memory database in the target test duration; and performing performance test on the memory database according to the total transaction processing amount of the database to obtain a performance test result.
According to the technical scheme, the master file is configured in advance, the slave files controlled by the master file are configured in advance, the test use table is created in advance, configuration information for testing the slave files aiming at the memory database is set in the test use table, the target test duration is set in advance, and the master file is used for controlling the slave files to perform database transaction processing operation on the memory database for the target test duration. The pre-created result statistical table is used for counting the database transaction processing amount of each slave file, so that the database transaction processing total amount of the memory database in the target test duration is obtained, the performance of the memory database is tested according to the database transaction processing total amount, the performance of the memory database in online transaction can be better reflected, the intuitiveness of the performance test of the memory database is improved, and the user experience is improved.
Correspondingly, the embodiment of the invention also provides a performance testing device, equipment and a computer readable storage medium of the memory database corresponding to the performance testing method of the memory database, which have the technical effects and are not described herein again.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flowchart illustrating an embodiment of a method for testing performance of a memory database according to the present invention;
FIG. 2 is a schematic diagram illustrating a connection relationship between a master file and each slave file according to an embodiment of the present invention;
FIG. 3 is a flowchart illustrating another embodiment of a method for testing performance of a memory database according to the present invention;
fig. 4 is a block diagram illustrating a performance testing apparatus for a memory database according to an embodiment of the present invention;
fig. 5 is a block diagram of a performance testing apparatus for a memory database according to an embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the disclosure, the invention will be described in further detail with reference to the accompanying drawings and specific embodiments. It is to be understood that the described embodiments are merely exemplary of the invention, and not restrictive of the full scope of the invention. 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 invention.
The first embodiment is as follows:
referring to fig. 1 and fig. 2, fig. 1 is a flowchart illustrating an implementation of a performance testing method for a memory database in an embodiment of the present invention, and fig. 2 is a schematic diagram illustrating a connection relationship between a master file and each slave file in an embodiment of the present invention, where the connection relationship is applied to a preset master file, and the method may include the following steps:
s101: and receiving a pre-created memory database performance test request sent by a test user, and analyzing the memory database performance test request to obtain a target test duration.
A test user (schema) for performing a performance test on the memory database may be created in advance by executing a related script, and a master file may be configured in advance for managing a performance test evaluation process of the memory database. When the performance test of the memory database is performed, a test user can send a memory database performance test request to a master file, the memory database performance test request can include a target test duration for performing database transaction amount statistics on the memory database, and the master file receives the memory database performance test request and analyzes the memory database performance test request to obtain the target test duration.
It should be noted that the target test duration may be set and adjusted according to actual situations, which is not limited in the embodiment of the present invention, for example, the target test duration may be set to 1 minute.
S102: and controlling each slave file to perform database transaction processing operation with target test duration on the memory database according to preset configuration information in the pre-created test use table to obtain the database transaction processing amount corresponding to each slave file.
As shown in fig. 2, a plurality of slave files respectively connected to a master file may be preconfigured, that is, a slave file 1, a slave file 2, and a slave file 3 … slave file n, where the master file is responsible for managing and scheduling the slave files to perform a stress test, and the number of names of the slave files, a port number when the master service is started, and the like may be set in the master file. And a test usage table can be created in advance by executing a relevant script, base data (such as a memory database drive type connected with each slave file, a memory database host address, a user and a password connected with the memory database, a data loading thread number for simulating the number of users, a data volume embodied by a warehouse parameter, and the like) used for performing performance test on the memory database can be loaded to the test usage table, and each base data constitutes preset configuration information.
After the target test duration is obtained through analysis, the positions and the names of the master file and the slave file of the test script can be adjusted according to the position and the name of the master parameter file and the position and the name of the slave parameter file, so that the master service and the slave service are started by executing the test script to start the pressure test. And controlling each slave file to perform database transaction processing operation with target test duration on the memory database according to preset configuration information in the pre-created test use table, such as database transaction processing work of querying, reading, inserting, updating and the like, so as to obtain the database transaction processing amount corresponding to each slave file.
S103: and carrying out statistical operation on the database transaction processing amount of each slave file by using a pre-created result statistical table to obtain the database transaction processing total amount of the memory database in the target test duration.
A result statistical table may be created in advance, and the result statistical table is used to perform statistical operation on the database transaction processing amount of each slave file, so as to obtain the total database transaction processing amount of the memory database in the target test duration.
S104: and performing performance test on the memory database according to the total transaction processing amount of the database to obtain a performance test result.
After the total database transaction processing amount of the memory database in the target test duration is obtained through statistics, performance test can be performed on the memory database according to the total database transaction processing amount, and therefore a performance test result is obtained. Therefore, the performance of the memory database can be intuitively reflected by counting the database transaction amount which can be processed by the memory database within the target test duration in the online transaction, so that the performance of the memory database is effectively evaluated, and the user experience is improved.
According to the technical scheme, the master file is configured in advance, the slave files controlled by the master file are configured in advance, the test use table is created in advance, configuration information for testing the slave files aiming at the memory database is set in the test use table, the target test duration is set in advance, and the master file is used for controlling the slave files to perform database transaction processing operation on the memory database for the target test duration. The pre-created result statistical table is used for counting the database transaction processing amount of each slave file, so that the database transaction processing total amount of the memory database in the target test duration is obtained, the performance of the memory database is tested according to the database transaction processing total amount, the performance of the memory database in online transaction can be better reflected, the intuitiveness of the performance test of the memory database is improved, and the user experience is improved.
It should be noted that, based on the first embodiment, the embodiment of the present invention further provides a corresponding improvement scheme. In the following embodiments, steps that are the same as or correspond to those in the first embodiment may be referred to each other, and corresponding advantageous effects may also be referred to each other, which are not described in detail in the following modified embodiments.
Referring to fig. 3, fig. 3 is a flowchart of another implementation of the method for testing the performance of the in-memory database according to the embodiment of the present invention, where the method is applied to a preset master file, and the method may include the following steps:
s301: and receiving a pre-created memory database performance test request sent by a test user, and analyzing the memory database performance test request to obtain target test duration and target identity information of the test user.
The memory database performance test request can also contain target identity information of a test user, and the master file can also obtain the target identity information of the test user by analyzing the memory database performance test request.
S302: and performing authority authentication on the target identity information to obtain an authority authentication result.
The master file can also carry out permission tests such as connection with the memory database, performance test of the memory database and the like for the test user. After the target identity information of the test user is obtained through analysis, authority authentication can be performed on the target identity information to obtain an authority authentication result. For example, the authority authentication can be performed by checking a user name and a password. The authority authentication is carried out on the test user, so that the legality of the test user is guaranteed, and the data security is improved.
S303: and when the permission authentication result is determined to be passed, controlling each slave file to perform database transaction processing operation with target test duration on the memory database according to the preset configuration information in the pre-created test use table and the index of the test use table, so as to obtain the database transaction processing amount corresponding to each slave file.
The index can be created for the test usage table in advance, so that database transaction processing work such as corresponding query, reading, insertion, updating and the like can be performed on each slave file and the memory database more conveniently, when the permission authentication result is determined to be passed, the test user is a legal user, the slave file can be controlled to perform database transaction processing operation with target test duration on the memory database according to preset configuration information in the pre-created test usage table and the index of the test usage table, and the database transaction processing amount corresponding to each slave file is obtained.
S304: and carrying out statistical operation on the database transaction processing amount of each slave file by using a pre-created result statistical table to obtain the database transaction processing total amount of the memory database in the target test duration.
S305: and adjusting the database transaction type proportion of each slave file to obtain the adjusted database transaction processing tasks corresponding to the slave files respectively.
The master file can also adjust the database transaction type proportion of each slave file, so as to obtain the adjusted database transaction processing tasks corresponding to each slave file. The concurrency is improved by adjusting the database transaction type proportion of each slave file, and the actual service scene can be simulated more truly according to the actual condition of the memory database.
S306: and controlling each slave file to perform database transaction processing operation of the target test duration according to the respectively corresponding adjusted database transaction processing tasks.
After the adjusted database transaction processing tasks corresponding to the slave files are obtained, the slave files can be controlled to perform database transaction processing operation with target test duration according to the adjusted database transaction processing tasks corresponding to the slave files.
S307: and acquiring the adjusted database transaction processing total amount of the memory database in the target test duration.
The adjusted total amount of database transactions of the in-memory database within the target test duration may be obtained.
S308: and judging whether the number of times of obtaining the adjusted database transaction total amount reaches a preset number, if so, executing step S309, and if not, executing step S305.
The database transaction type proportion of each slave file may be preset to be adjusted to obtain the number of times of the adjusted total transaction amount of the database, and it is determined whether the number of times of the adjusted total transaction amount of the database reaches the preset number of times, if so, step S309 may be continuously executed, and if not, step S305 may be continuously executed.
S309: and performing performance test on the memory database by combining the total transaction amount of the database and the adjusted total transaction amount of the database to obtain a performance test result.
After the database transaction type proportion of each slave file is adjusted for multiple times and the adjusted total transaction amount of the database is obtained, the performance of the memory database can be tested by combining the total transaction amount of the database and the adjusted total transaction amount of the database, and a performance test result is obtained. Therefore, the contingency is reduced, and the performance of the memory database is further accurately reflected by the performance test result.
Corresponding to the above method embodiments, the embodiments of the present invention further provide a performance testing apparatus for a memory database, where the performance testing apparatus for the memory database described below and the performance testing method for the memory database described above may be referred to each other correspondingly.
Referring to fig. 4, fig. 4 is a block diagram of a performance testing apparatus for a memory database according to an embodiment of the present invention, which is applied to a preset master file, and the apparatus may include:
a request analysis module 41, configured to receive a memory database performance test request sent by a pre-created test user, and analyze the memory database performance test request to obtain a target test duration;
the transaction processing operation module 42 is configured to control each slave file to perform database transaction processing operation with a target test duration on the memory database according to preset configuration information in the pre-created test usage table, so as to obtain database transaction processing amounts corresponding to each slave file;
a transaction total obtaining module 43, configured to perform a statistical operation on the database transaction amount of each slave file by using a pre-created result statistical table, so as to obtain a database transaction total of the memory database within a target test duration;
and the test result obtaining module 44 is configured to perform a performance test on the memory database according to the total transaction amount of the database, so as to obtain a performance test result.
According to the technical scheme, the master file is configured in advance, the slave files controlled by the master file are configured in advance, the test use table is created in advance, configuration information for testing the slave files aiming at the memory database is set in the test use table, the target test duration is set in advance, and the master file is used for controlling the slave files to perform database transaction processing operation on the memory database for the target test duration. The pre-created result statistical table is used for counting the database transaction processing amount of each slave file, so that the database transaction processing total amount of the memory database in the target test duration is obtained, the performance of the memory database is tested according to the database transaction processing total amount, the performance of the memory database in online transaction can be better reflected, the intuitiveness of the performance test of the memory database is improved, and the user experience is improved.
In a specific embodiment of the present invention, the transaction processing operation module 42 is a module that controls each slave file to perform database transaction processing operation with a target test duration on the memory database according to preset configuration information in the pre-created test usage table and an index of the test usage table.
In one embodiment of the present invention, the apparatus may further include:
the transaction type proportion adjusting module is used for adjusting the database transaction type proportion of each slave file to obtain an adjusted database transaction processing task corresponding to each slave file;
the transaction processing operation module 42 is further configured to control each slave file to perform database transaction processing operation with a target test duration according to the adjusted database transaction processing tasks respectively corresponding to the slave files;
the transaction total amount obtaining module 43 is further configured to obtain the adjusted transaction total amount of the database of the memory within the target test duration;
the test result obtaining module 44 is specifically a module that performs a performance test on the memory database by combining the total transaction amount of the database and the adjusted total transaction amount of the database to obtain a performance test result.
In a specific embodiment of the present invention, the request analyzing module 41 is a module that analyzes a performance test request of a memory database to obtain a target test duration and target identity information of a test user;
the performance testing apparatus may further include:
the permission authentication result obtaining module is used for carrying out permission authentication on the target identity information to obtain a permission authentication result before controlling each slave file to carry out database transaction processing operation of target test duration on the memory database according to preset configuration information in a pre-established test use table;
the transaction processing operation module 42 is specifically a module that controls each slave file to perform database transaction processing operation with a target test duration on the memory database according to preset configuration information in the pre-created test usage table when it is determined that the permission authentication result is passed.
In correspondence to the above method embodiment, referring to fig. 5, fig. 5 is a schematic diagram of a performance testing apparatus for a memory database provided in the present invention, where the apparatus may include:
a memory 51 for storing a computer program;
the processor 52, when executing the computer program stored in the memory 51, may implement the following steps:
receiving a pre-created memory database performance test request sent by a test user, and analyzing the memory database performance test request to obtain a target test duration; controlling each slave file to perform database transaction processing operation with target test duration on the memory database according to preset configuration information in a pre-created test use table to obtain database transaction processing amount corresponding to each slave file; carrying out statistical operation on the database transaction processing amount of each slave file by using a pre-created result statistical table to obtain the database transaction processing total amount of the memory database in the target test duration; and performing performance test on the memory database according to the total transaction processing amount of the database to obtain a performance test result.
For the introduction of the device provided by the present invention, please refer to the above method embodiment, which is not described herein again.
Corresponding to the above method embodiment, the present invention further provides a computer-readable storage medium having a computer program stored thereon, the computer program, when executed by a processor, implementing the steps of:
receiving a pre-created memory database performance test request sent by a test user, and analyzing the memory database performance test request to obtain a target test duration; controlling each slave file to perform database transaction processing operation with target test duration on the memory database according to preset configuration information in a pre-created test use table to obtain database transaction processing amount corresponding to each slave file; carrying out statistical operation on the database transaction processing amount of each slave file by using a pre-created result statistical table to obtain the database transaction processing total amount of the memory database in the target test duration; and performing performance test on the memory database according to the total transaction processing amount of the database to obtain a performance test result.
The computer-readable storage medium may include: various media capable of storing program codes, 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.
For the introduction of the computer-readable storage medium provided by the present invention, please refer to the above method embodiments, which are not described herein again.
The embodiments are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same or similar parts among the embodiments are referred to each other. The device, the apparatus and the computer-readable storage medium disclosed in the embodiments correspond to the method disclosed in the embodiments, so that the description is simple, and the relevant points can be referred to the description of the method.
The principle and the implementation of the present invention are explained in the present application by using specific examples, and the above description of the embodiments is only used to help understanding the technical solution and the core idea of the present invention. It should be noted that, for those skilled in the art, it is possible to make various improvements and modifications to the present invention without departing from the principle of the present invention, and those improvements and modifications also fall within the scope of the claims of the present invention.
Claims (10)
1. A performance test method of a memory database is characterized in that the method is applied to a preset master file and comprises the following steps:
receiving a memory database performance test request sent by a pre-created test user, and analyzing the memory database performance test request to obtain a target test duration;
controlling each slave file to perform database transaction processing operation of the target test duration on a memory database according to preset configuration information in a pre-created test usage table to obtain database transaction processing amounts corresponding to each slave file;
performing statistical operation on the database transaction processing amount of each slave file by using a pre-created result statistical table to obtain the total database transaction processing amount of the memory database in the target test duration;
and performing performance test on the memory database according to the total transaction processing amount of the database to obtain a performance test result.
2. The method for testing the performance of the in-memory database according to claim 1, wherein the step of controlling each slave file to perform the database transaction processing operation of the target test duration on the in-memory database according to the preset configuration information in the pre-created test usage table comprises:
and controlling each slave file to perform database transaction processing operation of the target test duration on the memory database according to preset configuration information in a pre-created test use table and the index of the test use table.
3. The in-memory database performance testing method according to claim 2, further comprising:
adjusting the database transaction type proportion of each slave file to obtain an adjusted database transaction processing task corresponding to each slave file;
controlling each slave file to perform database transaction processing operation of the target test duration according to the respectively corresponding adjusted database transaction processing tasks;
acquiring the adjusted database transaction processing total amount of the memory database in the target test duration;
repeatedly executing the step of adjusting the database transaction type proportion of each slave file until obtaining the adjusted database transaction total amount of preset times, and performing performance test on the memory database according to the database transaction total amount, wherein the step of adjusting the database transaction type proportion of each slave file comprises the following steps:
and performing performance test on the memory database by combining the total database transaction processing amount and each adjusted total database transaction processing amount.
4. The method for testing the performance of the in-memory database according to any one of claims 1 to 3, wherein analyzing the in-memory database performance test request to obtain a target test duration comprises:
analyzing the memory database performance test request to obtain the target test duration and the target identity information of the test user;
before controlling each slave file to perform database transaction processing operation of the target test duration on the memory database according to the preset configuration information in the pre-created test usage table, the method further includes:
performing authority authentication on the target identity information to obtain an authority authentication result;
and when the permission authentication result is determined to be passed, executing a step of controlling each slave file to perform database transaction processing operation of the target test duration on the memory database according to preset configuration information in a pre-created test use table.
5. A performance testing device of a memory database is characterized in that the performance testing device is applied to a preset master file and comprises the following components:
the request analysis module is used for receiving a memory database performance test request sent by a pre-created test user and analyzing the memory database performance test request to obtain a target test duration;
the transaction processing operation module is used for controlling each slave file to perform database transaction processing operation of the target test duration on the memory database according to preset configuration information in the pre-created test use table to obtain database transaction processing amount corresponding to each slave file;
a transaction total obtaining module, configured to perform a statistical operation on the database transaction amount of each slave file by using a pre-created result statistical table, to obtain a database transaction total of the memory database within the target test duration;
and the test result obtaining module is used for carrying out performance test on the memory database according to the total transaction processing amount of the database to obtain a performance test result.
6. The apparatus according to claim 5, wherein the transaction processing operation module is specifically a module that controls each slave file to perform the database transaction processing operation with the target test duration on the memory database according to preset configuration information in a pre-created test usage table and an index of the test usage table.
7. The in-memory database performance testing apparatus according to claim 6, further comprising:
the transaction type proportion adjusting module is used for adjusting the database transaction type proportion of each slave file to obtain an adjusted database transaction processing task corresponding to each slave file;
the transaction processing operation module is further configured to control each slave file to perform database transaction processing operation of the target test duration according to the respectively corresponding adjusted database transaction processing tasks;
the transaction total amount obtaining module is further configured to obtain the adjusted database transaction total amount of the memory database within the target test duration;
the test result obtaining module is specifically a module for performing performance test on the memory database by combining the database transaction total amount and each adjusted database transaction total amount to obtain a performance test result.
8. The device for testing the performance of the in-memory database according to any one of claims 5 to 7, wherein the request parsing module is specifically a module that parses the in-memory database performance test request to obtain the target test duration and the target identity information of the test user;
the performance testing apparatus further includes:
the authority authentication result obtaining module is used for carrying out authority authentication on the target identity information to obtain an authority authentication result before controlling each slave file to carry out database transaction processing operation of the target test duration on the memory database according to preset configuration information in a pre-established test use table;
the transaction processing operation module is specifically a module for controlling each slave file to perform database transaction processing operation of the target test duration on the memory database according to preset configuration information in a pre-created test usage table when the permission authentication result is determined to pass.
9. A performance testing apparatus for in-memory databases, comprising:
a memory for storing a computer program;
a processor for implementing the steps of the method for testing the performance of the in-memory database according to any one of claims 1 to 4 when executing the computer program.
10. A computer-readable storage medium, having stored thereon a computer program which, when being executed by a processor, carries out the steps of the method for performance testing of an in-memory database according to any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910931688.8A CN110795319A (en) | 2019-09-29 | 2019-09-29 | Performance test method, device and equipment of memory database and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910931688.8A CN110795319A (en) | 2019-09-29 | 2019-09-29 | Performance test method, device and equipment of memory database and readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110795319A true CN110795319A (en) | 2020-02-14 |
Family
ID=69438757
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910931688.8A Withdrawn CN110795319A (en) | 2019-09-29 | 2019-09-29 | Performance test method, device and equipment of memory database and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110795319A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113064837A (en) * | 2021-05-07 | 2021-07-02 | 中国工商银行股份有限公司 | Database benchmark test method and device based on transaction scene |
-
2019
- 2019-09-29 CN CN201910931688.8A patent/CN110795319A/en not_active Withdrawn
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113064837A (en) * | 2021-05-07 | 2021-07-02 | 中国工商银行股份有限公司 | Database benchmark test method and device based on transaction scene |
| CN113064837B (en) * | 2021-05-07 | 2024-04-09 | 中国工商银行股份有限公司 | Database benchmark test method and device based on transaction scene |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8386419B2 (en) | Data extraction and testing method and system | |
| CN108984389B (en) | Application program testing method and terminal equipment | |
| CN107092535B (en) | Method and apparatus for data storage of test interface | |
| US9940215B2 (en) | Automatic correlation accelerator | |
| CN110109824B (en) | Big data autoregression test method and device, computer equipment and storage medium | |
| CN107153609B (en) | Automatic testing method and device | |
| CN112269697B (en) | Equipment storage performance testing method, system and related device | |
| CN113127356A (en) | Pressure measurement method and device, electronic equipment and storage medium | |
| CN110895537A (en) | Method and device for freely inquiring authority control | |
| CN104391789A (en) | Web application stress testing method | |
| CN113220597B (en) | Test method, test device, electronic equipment and storage medium | |
| CN117331846B (en) | Internet-based software development, operation, test and management system | |
| CN110795319A (en) | Performance test method, device and equipment of memory database and readable storage medium | |
| CN111177119A (en) | Database-based full-data comparison method, device, equipment and storage medium | |
| CN117009196A (en) | Performance test method, test device and test platform for enterprise-level solid state disk | |
| CN109669829A (en) | A kind of diagnosis adjustment method, device and server based on BMC | |
| CN111339560A (en) | Data isolation method, device and system | |
| CN113448867B (en) | Software pressure testing method and device | |
| CN115061924A (en) | Automatic test case generation method and generation device | |
| CN114048139A (en) | SQL statement auditing method and device, electronic equipment and storage medium | |
| CN113886205A (en) | Database performance bottleneck positioning analysis method, device and system and storage medium | |
| CN109828913A (en) | A kind of test report generation method and device | |
| CN116661758B (en) | Method, device, electronic equipment and medium for optimizing log framework configuration | |
| CN111339748B (en) | Evaluation method, device, equipment and medium of analytical model | |
| CN110309038B (en) | Performance test method and device, electronic equipment and computer readable 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: 20200214 |