ApsaraDB for OceanBase:Overview

Background information

Database O&M engineers used to optimize, diagnose, and manage databases by performing operations such as monitoring the dashboard, setting alert metrics, 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.

OceanBase Autonomy Service 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 page

On the Autonomy Service page, you can view the connection statistics, the number of instances with suspicious and slow SQL statements in the last six hours, and the number of instances with optimization history in the last seven days.

You can also view performance exceptions in the last three days, such as instances with CPU exceptions of nodes and information about these exceptions. You can click Root cause analysis in the Actions column of an instance to go to the Exceptions tab of Autonomy Center for diagnostic details.

In the Instance Details section, you can view the instance information in the following columns: Instance Name, Suspicious SQL, SlowSQL, Capacity Risk, Optimization History, Capacity Usage and Whether Expire in 7 Days. You can search for clusters by entering keywords in the search box on the right.

Monitoring Dashboard

On the Monitoring Dashboard page of Autonomy Service, you can comprehensively monitor associated instances or tenants. You can also select monitoring objects and add metrics as needed for specific monitoring.

To view and edit information on the Monitoring Dashboard page, click Monitoring Dashboard in the upper-right corner of the Instance Details section.

Default Dashboard

The default monitoring dashboard displays common performance monitoring metrics of clusters and tenants.

You can also add or edit a dashboard as needed to achieve monitoring in more scenarios.

Add a dashboard

1. Go to the Monitoring Dashboard page.

2. Click Add Dashboard.

3. On the Add Dashboard page, specify the dashboard name, which must be unique.

4. Select the monitoring objects and metrics as needed in the Monitoring Dashboard Configuration section.

   1. Tenant performance monitoring

      1. You can enable Tenant Performance Monitoring to monitor tenant performance.

      2. In the Monitoring Tenants section, select the tenants to be monitored on the left and click to add the selected tenants.

      3. In the Monitoring Metrics section, select the monitoring metrics on the left as needed, and click to add the selected metrics.

   2. Cluster host monitoring

      1. You can enable Cluster Host Monitoring to monitor hosts in a cluster.

      2. In the text box of the Cluster section, select the clusters to be monitored.

      3. In the Monitoring Metrics section, select the monitoring metrics on the left as needed, and click to add the selected metrics.

Edit a dashboard

1. Go to the Monitoring Dashboard page.

2. Hover over the dashboard name and select Edit.

   Note

   You cannot edit the default dashboard.

3. On the Edit Dashboard page, modify the dashboard name, which must be unique.

4. Select the monitoring objects and metrics as needed in the Monitoring Dashboard Configuration section.

   1. Tenant performance monitoring

      1. You can enable Tenant Performance Monitoring to monitor tenant performance.

      2. In the Monitoring Tenants section, select the tenants to be monitored on the left and click to add the selected tenants.

      3. In the Monitoring Metrics section, select the monitoring metrics on the left as needed, and click to add the selected metrics.

   2. Cluster host monitoring

      1. You can enable Cluster Host Monitoring to monitor hosts in a cluster.

      2. In the text box of the Cluster section, select the clusters to be monitored.

      3. In the Monitoring Metrics section, select the monitoring metrics on the left as needed, and click to add the selected metrics.

Delete a dashboard

1. Go to the Monitoring Dashboard page.

2. Hover over the dashboard name and select Delete.

3. In the dialog box that appears, click Delete.

Other supported features