Quick onboard
Deployment
Data Modeling
Connecting
Migration
Query
Operations and Maintenance
Common Maintenance
Partition
Backup and Restore
Expansion
Mirroring
Resource Management
Security
Monitoring
Performance Tuning
Troubleshooting
Reference Guide
Tool guide
Data type
Storage Engine
Executor
Stream
DR (Disaster Recovery)
Configuration
Index
Extension
SQL Reference
This document describes the workload analysis feature in the YMatrix graphical user interface.
Query execution history is a critical resource in daily database operations. It provides deep insights into the behavior of the database system, enabling users to extract valuable information for performance tuning, troubleshooting, resource management, capacity planning, and query optimization. This ensures stable and efficient operation of the database system.
Click Overview and select a database to drill down into the types of SQL statements executed on that database. The larger the area, the higher the execution count for that type of SQL. The same principle applies to the treemap view Execution Time.
You can view query history from two perspectives: SQL Execution Count and SQL Total Execution Time. Selecting a bar displays the number of SQL executions within that time period. Each color in the bar represents a different SQL category, with categories ranked by execution frequency in descending order. By default, the top three most frequently executed SQL types are displayed.
Hovering over a specific SQL category shows its execution count and highlights the same SQL category across other time periods, helping identify problematic or optimization-targeted SQL statements.
Select a SQL category and click Details to locate the corresponding SQL statements in the table. The details table supports sorting by total execution count, total execution time, and other metrics.
Clicking on a specific SQL entry reveals additional details for further analysis.
Allows modification of data collection parameters.
