WO2020259391A1

WO2020259391A1 - Database script performance testing method and device

Info

Publication number: WO2020259391A1
Application number: PCT/CN2020/096905
Authority: WO
Inventors: 谢锐杰
Original assignee: 深圳前海微众银行股份有限公司
Priority date: 2019-06-26
Filing date: 2020-06-18
Publication date: 2020-12-30
Also published as: CN110287114A; CN110287114B

Abstract

A database script performance testing method and device. Said method comprises: acquiring table information of an online production database, table information of a test database, and database script information in a test process (201); preprocessing sentences in the database script information to obtain abstraction sentences corresponding to the database script information, and determining an execution frequency of the abstraction sentences (202); determining consumption of the abstraction sentences according to the table information of the production database and/or the table information of the test database, the abstraction sentences corresponding to the database script information, and an execution plan of the abstraction sentences (203); and determining performance indicators of a database script according to the consumption of the abstraction sentences and the execution frequency of the abstraction sentences (204). As the performance of the database script is tested by combining the table information of the on-line production database and the table information of the test database, number fabrication in a test environment or the human labour and resource overhead for preparing a quasi-production environment can be reduced.

Description

Method and device for testing database script performance

Cross references to related applications

This application claims the priority of a Chinese patent application filed with the Chinese Patent Office on June 26, 2019, the application number is 201910562575.5, and the application name is "a method and device for database script performance testing", the entire content of which is incorporated by reference In this application.

Technical field

The embodiment of the present invention relates to the field of financial technology (Fintech), and in particular to a method and device for testing database script performance.

Background technique

With the development of computer technology, more and more technologies (such as big data, distributed, Blockchain, artificial intelligence, etc.) are applied in the financial field. The traditional financial industry is gradually changing to Fintech. Performance testing technology is no exception, but due to the security and real-time requirements of the financial and payment industries, it also places higher requirements on technology.

At present, when banks/financial institutions conduct database script performance testing, there are usually two forms: The first one is for banks/financial institutions to simulate actual online production database data by calculating numbers in the test environment. The disadvantage of this scheme lies in the time cost of the number creation process, and it will inevitably increase the resource requirements of the test environment. When the amount of data is large, the test resources need to be expanded. If the amount of data is small, the data requirements for performance testing may not be met. The second is for banks/financial institutions to build a set of quasi-production environment database for performance testing through online production database data copies. The shortcomings of this solution are related to resource requirements. The database resource requirements of banks/financial institutions will double, resulting in a shortage of resources.

Summary of the invention

The embodiment of the present invention provides a method and device for testing database script performance, which is used to save the manpower and resource expenses of manufacturing a test environment or preparing a quasi-production environment.

In the first aspect, an embodiment of the present invention provides a method for testing database script performance, including:

Acquiring table information of the online production database, table information of the test database, and database script information during the test process of the test database;

Preprocessing the sentences in the database script information to obtain abstract sentences corresponding to the database script information; and determining the execution frequency of the abstract sentences;

Determine the consumption of the abstraction sentence according to the table information of the production database and/or the table information of the test database, the abstraction sentence corresponding to the database script information, and the execution plan of the abstraction sentence;

According to the consumption of the abstract sentences and the execution frequency of the abstract sentences, the performance index of the database script is determined.

In the above technical solution, since the table information of the online production database and the table information of the test database are combined to perform the performance test of the database script, the performance index of the database script is obtained, which is used to indicate the priority of determining the script optimization, which can save testing Human resources for environmental construction and reduction of resource expenditure for preparing quasi-production environment.

Optionally, the preprocessing of the statements in the database script information includes:

The information related to the actual business in the sentence of the database script information is deleted.

Optionally, the consumption of the abstract sentence includes current consumption and estimated consumption; the table information of the production database includes data volume information, index information, index discrimination information, and data growth trend; table information of the test database Including data volume information, index information, index discrimination information, and data growth trends;

Determining the consumption of the abstracted statement according to the table information of the production database and/or the table information of the test database, the abstracted statement corresponding to the database script information, and the execution plan of the abstracted statement, include:

For abstract sentences that exist in the table information of the production database, substituting the data volume information and/or index information and/or index discrimination information in the table information of the production database into the abstract statements that exist in the table information of the production database. The plan is to determine the current consumption of abstract sentences in the table information of the production database; and combine the data growth trend in the table information of the production database to substitute estimated recent data statistics into the table information of the production database The execution plan of the abstraction statement determines the estimated consumption of the abstraction statement that exists in the table information of the production database;

For abstract sentences that do not exist in the table information of the production database, the data volume information and/or index information and/or index discrimination degree in the table information of the test database corresponding to the abstract sentences in the table information of the production database are not present The information is converted according to a preset ratio, and the converted data volume information and/or index information and/or index discrimination information are substituted into the execution plan of the abstract statement that does not exist in the table information of the production database, and the non-existence is determined. The current consumption of abstract sentences that exist in the table information of the production database; and the data growth trend in the table information of the test database corresponding to the abstract sentences that do not exist in the table information of the production database is substituted into the estimated recent data statistics information The execution plan of the abstract sentence without the table information of the production database determines the estimated consumption of the abstract sentence without the table information of the production database.

Optionally, the determining the performance index of the database script according to the consumption of the abstraction sentence and the execution frequency of the abstraction sentence includes:

Determine the post-conversion consumption of the abstract sentence according to the consumption and consumption threshold of the abstract sentence;

Determine the converted frequency of the abstract sentence according to the execution frequency and the frequency threshold of the abstract sentence;

According to the consumption of the abstract sentence, the execution frequency of the abstract sentence, the post-conversion consumption of the abstract sentence, and the post-conversion frequency of the abstract sentence, a four-quadrant classification is performed to obtain the abstract sentence Performance.

Optionally, after determining the performance index of the database script, the method further includes:

If there is still synchronization information whose data verification status is verification failure, according to the time slicing information in the synchronization information whose data verification status is verification failure, re-read data from the database of the online processing system and insert it into all In the database of the batch processing system, and update the supplementary processing state according to the performance index of the database script, the characteristics of the database, the table information of the production database, the table information of the test database, and the abstraction The execution frequency of the statement determines the optimization plan of the database script.

In a second aspect, an embodiment of the present invention provides an apparatus for testing database script performance, including:

The obtaining unit is used to obtain table information of the online production database, table information of the test database, and database script information in the test database test process;

The processing unit is used to preprocess the sentences in the database script information to obtain the abstract sentences corresponding to the database script information; and determine the execution frequency of the abstract sentences; according to the table information of the production database And/or the table information of the test database, the abstraction sentence corresponding to the database script information, and the execution plan of the abstraction sentence, determine the consumption of the abstraction sentence; The execution frequency of the abstract statement determines the performance index of the database script.

Optionally, the processing unit is specifically configured to:

The processing unit is specifically used for:

Optionally, the processing unit is specifically configured to:

Optionally, the processing unit is further configured to:

After the performance index of the database script is determined, according to the performance index of the database script, the characteristics of the database, the table information of the production database, the table information of the test database, and the abstract sentence The execution frequency of the database script determines the optimization plan of the database script.

In the third aspect, an embodiment of the present invention also provides a computing device, including:

Memory, used to store program instructions;

The processor is configured to call the program instructions stored in the memory, and execute the above-mentioned database script performance test method according to the obtained program.

In a fourth aspect, embodiments of the present invention also provide a computer-readable non-volatile storage medium, including computer-readable instructions, which when the computer reads and executes the computer-readable instructions, cause the computer to execute the aforementioned database script performance Method of testing.

Description of the drawings

In order to more clearly describe the technical solutions in the embodiments of the present invention, the following will briefly introduce the drawings needed in the description of the embodiments. Obviously, the drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, without creative work, other drawings can be obtained from these drawings.

FIG. 1 is a schematic diagram of a system architecture provided by an embodiment of the present invention;

2 is a schematic flowchart of a method for testing database script performance according to an embodiment of the present invention;

Figure 3 is a schematic diagram of a four-quadrant distribution provided by an embodiment of the present invention;

FIG. 4 is a schematic structural diagram of an apparatus for testing database script performance provided by an embodiment of the present invention.

Detailed ways

In order to make the objectives, technical solutions and advantages of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all of them. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the protection scope of the present invention.

FIG. 1 exemplarily shows a system architecture to which the embodiment of the present invention is applicable. The system architecture may be a server 100 used by a bank/financial institution for database script testing. The server 100 may include a database statistical information collection module 110, The script sentence capture module 120, the sentence analysis module 130, and the report management module 140.

The database statistical information collection module 110 can collect database statistical information of banks/financial institutions, that is, table information, including table field information, data volume information, index information, index discrimination information, and data growth trends. For example, the database statistical information collection module 110 can collect table information of an online production database of a bank/financial institution and table information of a test database.

The script sentence capturing module 120 can capture the sentence information executed during the database test of the bank/financial institution in the test environment, abstract the captured sentences, classify and count the frequency.

The sentence analysis module 130 can calculate sentence consumption in combination with the sentence execution plan and the database statistics of the bank/financial institution.

The report management module 140 can perform four-quadrant classification based on the sentence frequency information and sentence consumption. And generate related statement performance test report.

It should be noted that the structure shown in FIG. 1 is only an example, which is not limited in the embodiment of the present invention.

Based on the above description, FIG. 2 exemplarily shows the process of a method for testing database script performance provided by an embodiment of the present invention. The process can be executed by a database script performance testing device, which can be located in the above-mentioned bank/financial institution. The server 100 of the bank/financial institution may also be the server 100.

It should be noted that in the following description of the database script performance test process, the SQL database will be taken as an example, and the statements involved are SQL statements. The embodiment of the present invention is only an example, and is not limited to the SQL database.

As shown in Figure 2, the process specifically includes:

Step 201: Obtain table information of the online production database, table information of the test database, and database script information in the test database test process.

In specific applications, the database statistical information collection module 110 can be used to collect table information of the online production database and collect table information of the test database. The script sentence capturing module 120 is used to capture the database script information during the test database test, and the script information includes a large amount of sentence information. It should be noted that when collecting the table information of the online generation database, the table information of the standby database of the production database can be collected. In the embodiment of the present invention, the table information may include table field information, data volume information, index information, index discrimination information, and data growth trends.

Step 202: Preprocess the sentences in the database script information to obtain abstract sentences corresponding to the database script information; and determine the execution frequency of the abstract sentences.

After the script statement capturing module 120 captures the script information of the database, it can delete the information related to the actual business in the statement of the database script information, and retain the main information required for execution plan analysis, which is equivalent to abstracting the statement. For example, you can delete the numerical information in the where condition, so that the script only retains the main information needed for execution plan analysis, and the rest are abstract statements.

For example, the SQL script information captured by the script statement capturing module 120 may be as shown in Table 1. In Table 1, in the composition of the SQL statement, the elements that affect the execution plan of the SQL statement include the table name (or subquery) after the From keyword, the field information after the where condition and the order of the fields, and the simple after the Select keyword The field name (the most commonly used), the constant data after the set keyword in the Update statement and the constant data after the where keyword in the Update statement do not affect the execution plan. Then the data in Table 1 above is abstracted and preprocessed, The obtained SQL abstraction statement can be shown in Figure 4.

Table 1

selectfrom student where class＝’103’and name＝’Tom’；selectfrom student where class=’103’and name=’Tom’;
select name,score from student where class＝’103’and name＝’Tom’；select name, score from student where class=’103’ and name=’Tom’;
select name,score from student where class＝’104’and name＝’Juily’；select name, score from student where class=’104’ and name=’Juily’;
delete from student where class＝’103’and name＝’Tom’；delete from student where class=’103’and name=’Tom’;
update student set score＝’100’where class＝’103’and name＝’Tom’；update student set score=’100’where class=’103’ and name=’Tom’;

Then classify the SQL abstract statements shown in Figure 2 and count according to the execution plan dependent factors.

Table 2

The five abstract sentences shown in Table 2 can be grouped into one category, as shown in Table 3. After completing the SQL abstraction sentence classification, the execution frequency of the SQL abstraction sentence is counted according to the number of occurrences, and the SQL abstraction sentence and its execution frequency are registered in the table.

table 3

Step 203: Determine the consumption of the abstract sentence according to the table information of the production database and/or the table information of the test database, the abstraction sentence corresponding to the database script information, and the execution plan of the abstraction sentence .

In the embodiment of the present invention, the consumption of abstract sentences includes current consumption and estimated consumption. When determining the consumption of the abstract sentence, it can be specifically: for the abstract sentence that exists in the table information of the production database, substituting the data volume information and/or index information and/or index discrimination information in the table information of the production database into There is an execution plan for the abstract statement of the table information of the production database, and the current consumption of the abstract statement of the table information of the production database is determined. And combined with the data growth trend in the table information of the production database, the estimated recent data statistics information is substituted into the execution plan of the abstract statement of the table information of the production database, and the estimation of the abstract statement of the table information of the production database is determined. Consumption.

For abstract statements that do not exist in the table information of the production database, the data volume information and/or index information and/or index discrimination information in the table information of the test database corresponding to the abstract statements in the table information of the production database are Perform conversion at a preset ratio, and substitute the converted data volume information and/or index information and/or index discrimination information into the execution plan of the abstract statement that does not exist in the production database table information, and determine that there is no production database table information The current consumption of abstract statements. And combined with the data growth trend in the table information of the test database corresponding to the abstract statement of the table information that does not exist in the production database, substitute the estimated recent data statistics into the execution plan of the abstract statement of the table information that does not exist in the production database, and determine The estimated consumption of abstract statements that do not exist in the production database table information.

For example, the statement analysis module 130 can be used to analyze the execution plan of the SQL abstract statement, and execute the Explain command that comes with the SQL database on the SQL abstract statement in the test environment to obtain the execution plan of the SQL abstract statement running in the test environment. .

For SQL abstract statements with table information in the production database, the statistical information collected by the production database (content included in the table information) is substituted into the execution plan to calculate SQL consumption. Here, the number of scanned rows in the execution plan is taken as the statistical latitude. SQL consumption statistics.

According to the statistics of the data volume information of the production database table corresponding to the SQL abstraction statement currently being counted, the current consumption of the SQL abstraction statement can be calculated, combined with the data growth trend, the estimated recent data statistics are substituted into the execution plan, and the calculation Estimated consumption of SQL abstraction statements. The estimated recent data is based on the data in the historical table combined with data growth trends.

For the query type "ALL" in the execution plan, the data volume information of the entire table substituted into the statistical data is used for consumption statistics. For the query types "range" and "index", the data volume information of the entire table and the index discrimination information are converted into index data volume information for consumption statistics.

For example, the execution plan of the SQL abstraction statement in the test environment as shown in Table 4.

Table 4

The statistical data in the table information of the production database is as follows:

The data volume in table a is 20000, and the growth trend is linear growth, with a periodical growth step of 3000;

The data volume in the statistics of table b is 50000, because table b is a primary key index, the amount of scanned data is 1;

The data volume of table c is 10000, and the increasing trend is that the statistical average value of the index discrimination degree of the first 8 bits of the tmpsno field is 1000, and the scanned data volume obtained by combining conversion is 10000/1000 about 10. The growth trend is a curve growth, and the slope change of the last few cycles is +0.15.

Substituting the above three tables a, b, and c into the execution plan, the current consumption of the SQL abstraction statement can be obtained: 20000*1+10 is about 20010.

The estimated consumption of SQL abstract statements is:

After 1 cycle, SQL consumption is 20000+(1*3000)+(10000+10000*0.15)/1000, which is about 23012.

After 3 cycles, the SQL consumption is 20000+(3*3000)+(10000*(1+0.15)^3/1000) about 29015.

If there is no data in production, according to the table information of the test database, it is converted according to a certain preset ratio and substituted into the calculation of the consumption of the SQL abstraction statement (including current consumption and estimated consumption). The preset ratio can be set based on experience.

Step 204: Determine the performance index of the database script according to the consumption of the abstract sentence and the execution frequency of the abstract sentence.

When the consumption of abstract sentences is obtained, the post-conversion consumption of abstract sentences can be determined according to the consumption and consumption threshold of abstract sentences, and the post-conversion consumption of abstract sentences can be determined according to the execution frequency and frequency threshold of abstract sentences. frequency. Then according to the consumption of abstract sentences, the execution frequency of abstract sentences, the consumption after conversion of abstract sentences, and the frequency after conversion of abstract sentences, the four-quadrant classification is performed to obtain the performance indicators of abstract sentences. The performance index of abstract sentences is the content after four-quadrant classification. Among them, the current consumption and estimated consumption of abstract sentences are classified into four quadrants respectively. The consumption threshold and frequency threshold can be set based on experience.

For example, suppose there is a set of consumption information as shown in Table 2, where the consumption threshold is 20000 and the frequency threshold is 500. The SQL consumption in Table 2 is the consumption of SQL abstract statements. The four-quadrant classification of the data in Table 2 above can obtain the four-quadrant distribution of SQL consumption as shown in Figure 3. Among them, when optimizing the database script, the SQL consumption value is a positive number that needs to be optimized, and the higher the frequency, the higher the optimization priority.

table 5

SQL抽象化语句编号SQL abstraction statement number	执行频次Execution frequency	SQL消耗SQL consumption	转换后频次Frequency after conversion	转换后消耗Consumption after conversion
11	1010	3200032000	-490-490	1200012000
22	150150	3030	-350-350	-19970-19970
33	350350	40004000	-150-150	-16000-16000
44	4040	40014001	-460-460	-15999-15999
55	280280	40024002	-220-220	-15998-15998
66	6060	40034003	-440-440	-15997-15997
77	55	40044004	-495-495	-15996-15996
88	8080	40054005	-420-420	-15995-15995
99	23twenty three	40064006	-477-477	-15994-15994
1010	100100	40074007	-400-400	-15993-15993
1111	110110	5000050000	-390-390	3000030000
1212	730730	4800048000	230230	2800028000
1313	750750	50005000	250250	-15000-15000
1414	770770	1500015000	270270	-5000-5000
1515	770770	33333333	270270	-16667-16667
1616	899899	5200052000	399399	3200032000

After obtaining the performance indicators of the abstract statement, an optimization plan for the database script can be determined based on the performance indicators of the database script, the characteristics of the database, the table information of the production database, the table information of the test database, and the execution frequency of the abstract statement.

Here, the report management module 140 is mainly used to provide the SQL script statement adjustment and optimization plan. The SQL script statement optimization has mature optimization implementation plans in the industry, and the optimization plan and business logic are relatively related. The embodiment of the present invention is based on the original optimization plan. On the basis of this, some special points related to the MYSQL database and the script sentence optimization proposal combined with statistical information are proposed.

For example, 1. The field order of SQL database query conditions will affect the execution consumption of SQL statements. According to the main information of SQL abstract statements, traverse the different sorting combinations in the query, respectively count the consumption of SQL abstract statements, and select the lowest cost sorting method Mark as the best sort. And mark the involved non-optimal sorted SQL abstraction statement as a sorted optimized SQL statement.

2. Combined with the table information of the production database and the table information of the test database, the index information in the basic statistical information of the database and the statistical information of the abstract sentence are obtained, and the secondary statistics are performed to obtain the fields in the query conditions corresponding to each table. The number of occurrences to determine whether the field has an index, index type, and the position of the field in the joint index. Count the fields corresponding to the frequently occurring tables. If the field has no index, it is marked as the field information that may need to be optimized.

Then the report management module 140 can sort the analysis results and the SQL script sentence optimization plan, generate related SQL script sentence performance test reports, and submit it to the project team for SQL script sentence optimization. The priority during optimization can be high frequency high consumption, low frequency high consumption.

It should be noted that in the specific implementation process, the data growth trend information in the table information may not be collected, which can save the workload of the database statistical information collection module 110 and can only analyze the current consumption of the current current SQL statements. In this case, the estimated consumption of SQL statements cannot be achieved, and early warning cannot be given.

Optionally, the execution frequency of the above abstract statements may not be counted. In this case, it is only necessary to perform full optimization on the SQL abstract statements analyzed as high consumption.

The embodiment of the present invention shows that by obtaining the table information of the online production database, the table information of the test database, and the database script information in the test process, the sentences in the database script information are preprocessed to obtain the abstract sentences corresponding to the database script information , And determine the execution frequency of the abstract statement, and determine the consumption of the abstract statement according to the table information of the production database and/or the table information of the test database, the abstract statement corresponding to the database script information, and the execution plan of the abstract statement. The consumption of abstract sentences and the execution frequency of the abstract sentences determine the performance index of the database script. Because the table information of the online production database and the table information of the test database are combined to perform the performance test of the database script, it can save the manpower and resource expenses of the test environment or the preparation of the quasi-production environment.

It should be noted that the database script performance test process in the embodiment of the present invention can be applied to various database script performance tests in banks/financial institutions.

Based on the same technical concept, FIG. 4 exemplarily shows the structure of a database script performance test device provided by an embodiment of the present invention. The device can execute the process of database script performance test. The device can be located in the server 100. , Or the server 100.

As shown in Figure 4, the device specifically includes:

The obtaining unit 401 is configured to obtain table information of the online production database, table information of the test database, and database script information during the test database test process;

The processing unit 402 is configured to preprocess the sentences in the database script information to obtain abstract sentences corresponding to the database script information; and determine the execution frequency of the abstract sentences; according to the table of the production database Information and/or the table information of the test database, the abstraction sentence corresponding to the database script information, and the execution plan of the abstraction sentence, determine the consumption of the abstraction sentence; according to the consumption sum of the abstraction sentence The execution frequency of the abstract sentence determines the performance index of the database script.

Optionally, the processing unit 402 is specifically configured to:

The processing unit 402 is specifically configured to:

Optionally, the processing unit 402 is specifically configured to:

Optionally, the processing unit 402 is further configured to:

Based on the same technical concept, an embodiment of the present invention also provides a computing device, including:

Memory, used to store program instructions;

Based on the same technical concept, the embodiments of the present invention also provide a computer-readable non-volatile storage medium, including computer-readable instructions. When the computer reads and executes the computer-readable instructions, the computer executes the above-mentioned database. Script performance testing method.

The present invention is described with reference to flowcharts and/or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and/or block in the flowchart and/or block diagram, and the combination of processes and/or blocks in the flowchart and/or block diagram can be implemented by computer program instructions. These computer program instructions can be provided to the processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing equipment to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing equipment can be generated It is a device that realizes the functions specified in one process or multiple processes in the flowchart and/or one block or multiple blocks in the block diagram.

These computer program instructions can also be stored in a computer-readable memory that can guide a computer or other programmable data processing equipment to work in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture including the instruction device. The device implements the functions specified in one process or multiple processes in the flowchart and/or one block or multiple blocks in the block diagram.

These computer program instructions can also be loaded on a computer or other programmable data processing equipment, so that a series of operation steps are executed on the computer or other programmable equipment to produce computer-implemented processing, so as to execute on the computer or other programmable equipment. The instructions provide steps for implementing functions specified in a flow or multiple flows in the flowchart and/or a block or multiple blocks in the block diagram.

Although the preferred embodiments of the present invention have been described, those skilled in the art can make additional changes and modifications to these embodiments once they learn the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications falling within the scope of the present invention.

Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. In this way, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalent technologies, the present invention is also intended to include these modifications and variations.

Claims

A method for testing database script performance, which is characterized in that it includes:

Acquiring table information of the online production database, table information of the test database, and database script information during the test process of the test database;

Preprocessing the sentences in the database script information to obtain abstract sentences corresponding to the database script information; and determining the execution frequency of the abstract sentences;

Determine the consumption of the abstraction sentence according to the table information of the production database and/or the table information of the test database, the abstraction sentence corresponding to the database script information, and the execution plan of the abstraction sentence;

According to the consumption of the abstract sentences and the execution frequency of the abstract sentences, the performance index of the database script is determined.
The method according to claim 1, wherein the preprocessing the sentences in the database script information comprises:

The information related to the actual business in the sentence of the database script information is deleted.
The method of claim 1, wherein the consumption of the abstract sentence includes current consumption and estimated consumption; the table information of the production database includes data volume information, index information, index discrimination information, and data growth Trend; the table information of the test database includes data volume information, index information, index discrimination information, and data growth trends;

Determining the consumption of the abstracted statement according to the table information of the production database and/or the table information of the test database, the abstracted statement corresponding to the database script information, and the execution plan of the abstracted statement, include:

For abstract sentences that exist in the table information of the production database, substituting the data volume information and/or index information and/or index discrimination information in the table information of the production database into the abstract statements that exist in the table information of the production database. The plan is to determine the current consumption of abstract sentences in the table information of the production database; and combine the data growth trend in the table information of the production database to substitute estimated recent data statistics into the table information of the production database The execution plan of the abstract statement determines the estimated consumption of the abstract statement in the table information of the production database;

For abstract sentences that do not exist in the table information of the production database, the data volume information and/or index information and/or index discrimination degree in the table information of the test database corresponding to the abstract sentences in the table information of the production database are not present The information is converted according to a preset ratio, and the converted data volume information and/or index information and/or index discrimination information are substituted into the execution plan of the abstract statement that does not exist in the table information of the production database, and the non-existence is determined. The current consumption of abstract sentences that exist in the table information of the production database; and the data growth trend in the table information of the test database corresponding to the abstract sentences that do not exist in the table information of the production database is substituted into the estimated recent data statistics information The execution plan of the abstract sentence without the table information of the production database determines the estimated consumption of the abstract sentence without the table information of the production database.
3. The method of claim 1, wherein the determining the performance index of the database script according to the consumption of the abstraction sentence and the execution frequency of the abstraction sentence comprises:

Determine the post-conversion consumption of the abstract sentence according to the consumption and consumption threshold of the abstract sentence;

Determine the converted frequency of the abstract sentence according to the execution frequency and the frequency threshold of the abstract sentence;

According to the consumption of the abstract sentence, the execution frequency of the abstract sentence, the post-conversion consumption of the abstract sentence, and the post-conversion frequency of the abstract sentence, a four-quadrant classification is performed to obtain the abstract sentence Performance.
The method according to any one of claims 1 to 4, wherein after the determining the performance index of the database script, the method further comprises:

According to the performance index of the database script, the characteristics of the database, the table information of the production database, the table information of the test database, and the execution frequency of the abstract sentence, an optimization plan for the database script is determined.
A device for testing database script performance, which is characterized in that it comprises:

The obtaining unit is used to obtain table information of the online production database, table information of the test database, and database script information in the test database test process;

The processing unit is used to preprocess the sentences in the database script information to obtain the abstract sentences corresponding to the database script information; and determine the execution frequency of the abstract sentences; according to the table information of the production database And/or the table information of the test database, the abstraction sentence corresponding to the database script information, and the execution plan of the abstraction sentence, determine the consumption of the abstraction sentence; The execution frequency of the abstract statement determines the performance index of the database script.
The device according to claim 6, wherein the processing unit is specifically configured to:

The information related to the actual business in the sentence of the database script information is deleted.
7. The device of claim 6, wherein the consumption of the abstract sentence includes current consumption and estimated consumption; the table information of the production database includes data volume information, index information, index discrimination information, and data growth Trend; the table information of the test database includes data volume information, index information, index discrimination information, and data growth trends;

The processing unit is specifically used for:

For abstract sentences that exist in the table information of the production database, substituting the data volume information and/or index information and/or index discrimination information in the table information of the production database into the abstract statements that exist in the table information of the production database. The plan is to determine the current consumption of abstract sentences in the table information of the production database; and combine the data growth trend in the table information of the production database to substitute estimated recent data statistics into the table information of the production database The execution plan of the abstraction statement determines the estimated consumption of the abstraction statement that exists in the table information of the production database;

For abstract sentences that do not exist in the table information of the production database, the data volume information and/or index information and/or index discrimination degree in the table information of the test database corresponding to the abstract sentences in the table information of the production database are not present The information is converted according to a preset ratio, and the converted data volume information and/or index information and/or index discrimination information are substituted into the execution plan of the abstract statement that does not exist in the table information of the production database, and the non-existence is determined. The current consumption of abstract sentences that exist in the table information of the production database; and the data growth trend in the table information of the test database corresponding to the abstract sentences that do not exist in the table information of the production database is substituted into the estimated recent data statistics information The execution plan of the abstract sentence without the table information of the production database determines the estimated consumption of the abstract sentence without the table information of the production database.
The device according to claim 6, wherein the processing unit is specifically configured to:

Determine the post-conversion consumption of the abstract sentence according to the consumption and consumption threshold of the abstract sentence;

Determine the converted frequency of the abstract sentence according to the execution frequency and the frequency threshold of the abstract sentence;

According to the consumption of the abstract sentence, the execution frequency of the abstract sentence, the post-conversion consumption of the abstract sentence, and the post-conversion frequency of the abstract sentence, a four-quadrant classification is performed to obtain the abstract sentence Performance.
The device according to any one of claims 6 to 9, wherein the processing unit is further configured to:

After the performance index of the database script is determined, according to the performance index of the database script, the characteristics of the database, the table information of the production database, the table information of the test database, and the abstract sentence The execution frequency of the database script determines the optimization plan of the database script.
A computing device, characterized by comprising:

Memory, used to store program instructions;

The processor is configured to call the program instructions stored in the memory, and execute the method according to any one of claims 1 to 5 according to the obtained program.
A computer-readable non-volatile storage medium, characterized by comprising computer-readable instructions, when the computer reads and executes the computer-readable instructions, the computer is caused to execute any one of claims 1 to 5 Methods.