Function Overview
Description
DBA Assistant provides visualized database O&M and intelligent diagnosis for developers and database administrators (DBAs), making database O&M easy and efficient. By analyzing alarms, resource usage, health status, performance metrics, and storage usage, it helps you quickly locate faults and keep track of instance statuses.
To use DBA Assistant on the GaussDB(for MySQL) console, you need to ensure that IAM users must have the GaussDB FullAccess, DAS FullAccess, DAS Administrator, and CES FullAccess permissions. For details, see Creating a User and Granting GaussDB(for MySQL) Permissions.
Functions
Table 1 lists the functions supported by DBA Assistant.
|
Function |
Description |
Reference |
|---|---|---|
|
Dashboard |
Shows the status of your instance, including alarms, resource usages, and key performance metrics. DBA Assistant diagnoses instance health using operational data analytics and intelligent algorithms, and provides you with solutions and suggestions for handling detected exceptions. |
|
|
Sessions |
The Sessions page displays slow sessions, active sessions, and total sessions. You can quickly filter slow sessions or active sessions by user, host IP address, or database name. Kill Session and Concurrency Control can be used for urgent instance recovery to ensure database availability. |
|
|
Performance |
The Performance page displays key metrics of your instance and provides metric comparison between different days. You can keep track of metric changes and detect exceptions in a timely manner. Monitoring by Seconds helps accurately locate faults. |
|
|
Storage Analysis |
Storage occupied by data and logs and changes of storage usage are important for database performance. The Storage Analysis page displays storage overview and disk space distribution of your instance. In addition, DBA Assistant can estimate the available days of your storage based on historical data and intelligent algorithms, so that you can scale up storage in a timely manner. Autoscaling, Tablespaces, Top 50 Databases, and Top 50 Tables are also available on this page. |
|
|
Slow Query Log |
Displays slow queries within a specified time period. You can view top 5 slow query logs by user or IP address, sort statistics, and identify sources of slow SQL statements. |
|
|
SQL Explorer |
After Collect All SQL Statements is enabled, you can gain a comprehensive insight into SQL statements on the SQL Explorer page. Top SQL helps you locate exceptions. |
|
|
Concurrency Control |
Concurrency Control restricts the execution of SQL statements based on specified rules when there are SQL statements that cannot be optimized timely or a resource (for example, vCPU) bottleneck occurs. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
