Load Analysis

This document introduces the load analysis function of YMatrix graphical interface.

In the daily work of database operation and maintenance, querying execution history information is a crucial resource. Therefore, we can deeply understand the operation status of the database system and obtain valuable information from it, helping us better solve problems such as performance optimization, troubleshooting, resource management, capacity planning and query optimization, so that the database system can run stably and efficiently.

1 Entrance

![](https://img.ymatrix.cn/ymatrix_home/load analysis 1_1698304516.png)

2 Introduction

Click Overview, select a database, and you can drill down to the type of SQL executed by the corresponding database. The more times a certain type of SQL is executed, the larger the area. The same applies to the Execution Time tree diagram.

![](https://img.ymatrix.cn/ymatrix_home/load analysis 2_1698304730.png)

You can view the query history from the two angles of SQL execution times and SQL total execution time. Select a column to see how many times SQL has been executed in the corresponding time period. Each color in the column represents a type of SQL. Each type of SQL is arranged from large to small according to the number of executions, and the three types with the largest number of executions are displayed by default.

![](https://img.ymatrix.cn/ymatrix_home/Load Analysis 3_1698305018.png)

The cursor floats on a certain type of SQL, which can display the number of executions of this type of SQL. At the same time, similar SQLs in other periods will also be highlighted to help position optimization or problem SQL.

![](https://img.ymatrix.cn/ymatrix_home/Load Analysis 4_1698305023.png)

Select a certain type of SQL and click Detail. The corresponding SQL will be located in the table. The details table supports sorting by total execution times, total execution time, etc.

![](https://img.ymatrix.cn/ymatrix_home/load analysis 5_1698305031.png)

Click the corresponding SQL details to view more relevant information to help further analysis.

![](https://img.ymatrix.cn/ymatrix_home/load analysis 6_1698305036.png)

3 Configuration

Supports modifying the relevant parameter settings for data collection.

![](https://img.ymatrix.cn/ymatrix_home/load analysis 7_1698305044.png)