OceanBase Autonomy Service is an all-in-one smart diagnostics and autonomy service oriented to developers, O&M engineers, and database administrators (DBAs). It provides visual monitoring, performance optimization, fault diagnostics, security management, capacity management, and other features to help you use ApsaraDB for OceanBase with simpler operations, lower costs, and higher performance.
Overview
Database O&M engineers used to optimize, diagnose, and manage databases by performing operations such as monitoring the dashboard, setting alert thresholds, defining inspection strategies, and analyzing SQL statements or monitoring data. In addition to drawbacks such as high labor costs, low efficiency, and limited cluster size, this management mode tends to cause O&M faults.
Features
On the service page, you can view the connection statistics, number of instances with suspicious SQL statements or slow SQL statements in the last six hours, and number of instances with optimization records in the last seven days.
You can also view the performance exception events in the last three days, including instances with node CPU exceptions and related information about exception events. Click SQL Statistics in the Actions column to go to the real-time diagnostics page of the instance and view diagnostic details.
This module is not displayed if there is no performance exception event in the last three days.
In the instance details list, you can view the following information about instances connected to OceanBase Autonomy Service: Instance Name, Suspicious SQL, SlowSQL, Capacity Risk, Optimization History, Capacity Usage, and Whether Expire in 7 Days.
OceanBase Autonomy Service also supports features described in the following topics.
Topic | Description |
Describes how to use the autonomy center. You can initiate one-click diagnostics and view diagnostic reports and exception events in the autonomy center. | |
Describes how to use the real-time diagnostics feature. You can view SQL diagnostics information and manage sessions on the page of real-time diagnostics. | |
Describes how to use the optimization center. You can view optimization suggestions and records in the optimization center. | |
Describes how to use the capacity center. You can view the resource usage trend of the database in the capacity center. | |
Describes how to use the security center. You can view SQL audit and security assessment information in the security center. |