Query Test

YMatrix supports graphical experience database function, and users can customize query testing solutions according to business scenarios on the page to experience YMatrix's strong query performance in high concurrency scenarios.

Notes!
The performance of the database also depends on the performance of the server, and we recommend using a physical machine to complete the test whenever possible.

The server configuration is as follows:

| CPU | Memory | Hard disk capacity | | --- | --- | | 8 cores and above | 16G and above | 50G and above |

1 Preparation

1.1 Login

Enter the IP of the machine where MatrixGate is located (the default is mdw's IP) and port number in the browser:

http://<IP>:8240

After successfully logging in, enter the data flow list page

2 Query Test

Select the Query Test module in the Quick Experience section.

2.1 Select the test table

In "Easy to Get Started" and "Write Test", YMatrix automatically generates several data tables, and you can choose any of them for query testing.

2.2 Query performance

You can select the query statement you want to execute, customize the concurrency and the number of loop executions, and the page will feedback the execution progress of the query plan. YMatrix database provides 6 metrics to help analyze query performance:

Total time consumption: The total time consumption of executing the selected query statement according to the set concurrency degree and the number of cycle executions.
Average time consumption: The average time consumption of a single time is calculated from the total time consumption and the number of executions performed by the selected query statement.
Average QPS: Average number of queries executed per second
75 Quantile: After the selected query statement is executed, 75% of the query takes less than the result displayed in this field.
50 Quantile: After the selected query statement is executed, 50% of the query takes less than the result displayed in this field.
25 Quantile: After the selected query statement is completed, 25% of the query takes less than the result displayed in this field.