English

Query Testing

YMatrix provides a graphical interface for experiencing database functionality. Users can customize query testing scenarios on the page to experience YMatrix's powerful query performance under high-concurrency workloads.

Note!
Database performance also depends on server capabilities. We recommend using physical machines for testing whenever possible.

Recommended server configuration:

CPU	Memory	Disk Capacity
8 cores or more	16 GB or more	50 GB or more

1 Preparation

1.1 Log In

Enter the IP address of the machine where MatrixGate is running (by default, the IP of mdw) and the port number in your browser:

http://<IP>:8240

After successful login, you will be directed to the data stream list page.

2 Querying

Select the Quering module from the Quick Experience section.

2.1 Select Test Table

YMatrix automatically generates several data tables during the Getting Started and Write Testing processes. You may select any of these tables for query testing.

2.2 Query Performance

You can choose the desired SQL query, set the concurrency level and number of execution loops. The page displays the execution progress of the query plan. YMatrix Database provides six metrics to help analyze query performance:

Total Execution Time: Total time spent executing the selected query under the specified concurrency and loop count.
Average Execution Time: Average time per query execution, calculated from total execution time and number of executions.
Average QPS: Average queries executed per second.
75th Percentile: After completing all query executions, 75% of the queries finished within this time.
50th Percentile: After completing all query executions, 50% of the queries finished within this time.
25th Percentile: After completing all query executions, 25% of the queries finished within this time.

Version Release History