Database Autonomy Service (DAS) provides the alerting feature. This feature allows you to customize alert rules. When an alert rule is triggered by a database instance, DAS automatically sends an alert notification. This topic describes how to configure and manage alert rules in the DAS console before you configure alerting.
Create an alert rule
The alert types in DAS are optimized by adding Autonomy Events and removing Event Alert. Your existing alert rules are still retained after the update. When you create an alert rule, you can now select only Threshold Alerting or Autonomy Events as the alert type.
Log on to the DAS console.
In the left-side navigation pane, choose .
On the Alert Rules page, click Add Rule in the upper-right corner.
In the Add Rule dialog box, configure the parameters that are described in the following table. Then, click OK.
Parameter
Description
Rule Name
The name of the alert rule.
Type
The type of the alert rule. Valid values:
Threshold Alerting: You can select an alert metric and specify the threshold that triggers the alert rule. For more information about the supported alert metrics, see the "Alert metrics" section of this topic.
Autonomy Events: You can select a specific autonomy event that triggers the alert rule.
Description
The conditions that trigger the alert rule.
NoteThis parameter is required if you set the Type parameter to Threshold Alerting.
The alert detection granularity is 1 minute.
Event Type
The type of the autonomy event that triggers the alert rule. Valid values:
Auto Scaling Event
Throttling Event
SQL Optimization
Storage Optimization
Metric Exception
NoteThis parameter is required if you set the Type parameter to Autonomy Events.
Alert Interval
The interval at which the system sends alert notifications to you when the alert rule is triggered.
Effective Time
The period of time within which the alert rule takes effect.
Alert Level
The alert level of the alert rule.
Notification Method
The method that is used to send alert notifications. DAS can send alert notifications by SMS message, webhook, and email.
NoteWebhook is supported for DingTalk, WeCom, Lark, and Application Real-Time Monitoring Service (ARMS).
After the alert rule is created, you can configure alerting. For more information, see Configure alerting.
Manage an alert rule
Log on to the DAS console.
In the left-side navigation pane, choose .
On the Alert Rules page, manage the created alert rules.
Find the alert rule that you want to manage and click the buttons in the Actions column. You can perform the following operations:
Search: View the details and alert history of the alert rule.
Edit: Modify the alert rule. For more information about the parameters that you can configure for alert rules, see the "Create an alert rule" section of this topic.
Disable: Disable the alert rule.
Delete: Delete the alert rule.
ImportantAfter you modify, disable, or delete an alert rule, all alert templates that contain the alert rule are affected. Proceed with caution.
Alert metrics
The alert metrics take effect only for Alibaba Cloud database instances.
MySQL
Alert metric | Unit | Description |
MySQL Disk Usage | % | The disk usage. |
MySQL CPU Utilization | % | The CPU utilization of the MySQL process. The maximum value of this metric is 100% for ApsaraDB RDS for MySQL instances. |
MySQL IOPS Usage | % | The IOPS usage. |
MySQL Memory Usage | % | The memory usage of the ApsaraDB RDS for MySQL instance, expressed as a percentage of the total memory of the operating system. |
MySQL Active Sessions | Count | The number of active sessions. |
MySQL Transactions per Second | Per second | The average number of transactions per second. |
MySQL QPS | Per second | The average number of requests per second. |
MySQL DELETE Statements Executed per Second | Per second | The average number of DELETE statements that are executed per second. |
MySQL INSERT Statements Executed per Second | Per second | The average number of INSERT statements that are executed per second. |
MySQL INSERT SELECT Statements Executed per Second | Per second | The average number of INSERT SELECT statements that are executed per second. |
MySQL REPLACE Statements Executed per Second | Per second | The average number of REPLACE statements that are executed per second. |
MySQL REPLACE SELECT Statements Executed per Second | Per second | The average number of REPLACE SELECT statements that are executed per second. |
MySQL SELECT Statements Executed per Second | Per second | The average number of SELECT statements that are executed per second. |
MySQL UPDATE Statements Executed per Second | Per second | The average number of UPDATE statements that are executed per second. |
MySQL Full Table Scans per Second | Per second | The number of full table scans that are executed per second. |
MySQL Tables Opened | Count | The number of opened tables. |
MySQL Files Opened | Count | The number of opened files. |
MySQL Rows Sorted per Second | Per second | The number of rows that are sorted per second. |
MySQL Secondary Node Replication Delay | Second | The replication delay of a secondary node. |
Average Rows Deleted from MySQL InnoDB per Second | Per second | The average number of InnoDB rows from which data is deleted per second. |
Average Rows Inserted into MySQL InnoDB per Second | Per second | The average number of InnoDB rows into which data is inserted per second. |
Average Rows Read from MySQL InnoDB per Second | Per second | The average number of InnoDB rows from which data is read per second. |
Average Rows Updated in MySQL InnoDB per Second | Per second | The average number of InnoDB rows in which data is updated per second. |
MySQL InnoDB Buffer Pool Read Requests per Second | Per second | The average number of logical page reads from the InnoDB buffer pool per second. |
MySQL InnoDB Buffer Pool Write Requests per Second | Per second | The average number of page writes to the InnoDB buffer pool per second. |
MySQL InnoDB Buffer Pool Dirty Page Ratio | % | The ratio of dirty pages in the InnoDB buffer pool. Calculation formula: Innodb_buffer_pool_pages_dirty/Innodb_buffer_pool_pages_data × 100%. |
MySQL InnoDB Buffer Pool Read Hit Ratio | % | The read hit ratio of the InnoDB buffer pool. Calculation formula: (Innodb_buffer_pool_read_requests - Innodb_buffer_pool_reads)/Innodb_buffer_pool_read_requests × 100%. |
Average Waits for Row Locks of MySQL InnoDB Table | Count | The average number of row lock waits of the InnoDB table. |
Maximum Wait Duration for Row Locks of MySQL InnoDB Table | ms | The maximum row lock wait duration of the InnoDB table. |
MySQL Total Storage Space Usage | MB | The total used space of the MySQL instance. |
PolarDB for MySQL
Alert metric | Unit | Description |
PolarDB for MySQL Disk Usage | % | The disk usage. |
PolarDB for MySQL CPU Utilization | % | The CPU utilization of the PolarDB process. A value of 200% indicates that two CPU cores are used. |
PolarDB for MySQL IOPS Usage | % | The IOPS usage. |
PolarDB for MySQL Memory Usage | % | The memory usage of the PolarDB for MySQL cluster, expressed as a percentage of the total memory of the operating system. |
PolarDB for MySQL Active Sessions | Count | The number of active sessions. |
PolarDB for MySQL Transactions per Second | Per second | The average number of transactions per second. Calculation formula: (Com_commit + Com_rollback)/Uptime. |
PolarDB for MySQL QPS | Per second | The average number of requests per second. Calculation formula: Queries/Uptime. |
PolarDB for MySQL DELETE Statements Executed per Second | Per second | The average number of DELETE statements that are executed per second. |
PolarDB for MySQL INSERT Statements Executed per Second | Per second | The average number of INSERT statements that are executed per second. |
PolarDB for MySQL INSERT SELECT Statements Executed per Second | Per second | The average number of INSERT SELECT statements that are executed per second. |
PolarDB for MySQL REPLACE Statements Executed per Second | Per second | The average number of REPLACE statements that are executed per second. |
PolarDB for MySQL REPLACE SELECT Statements Executed per Second | Per second | The average number of REPLACE SELECT statements that are executed per second. |
PolarDB for MySQL SELECT Statements Executed per Second | Per second | The average number of SELECT statements that are executed per second. |
PolarDB for MySQL UPDATE Statements Executed per Second | Per second | The average number of UPDATE statements that are executed per second. |
PolarDB for MySQL Multi-DELETE Statements Executed per Second | Per second | The average number of Multi-DELETE statements that are executed per second. |
PolarDB for MySQL Multi-UPDATE Statements Executed per Second | Per second | The average number of Multi-UPDATE statements that are executed per second. |
Rows Deleted from PolarDB for MySQL InnoDB per Second | Per second | The average number of rows that are deleted from the InnoDB table per second. |
Rows Inserted into PolarDB for MySQL InnoDB per Second | Per second | The average number of rows that are inserted into the InnoDB table per second. |
Rows Read from PolarDB for MySQL InnoDB per Second | Per second | The average number of rows that are read from the InnoDB table per second. |
Rows Updated in PolarDB for MySQL InnoDB per Second | Per second | The average number of rows that are updated in the InnoDB table per second. |
Redis
Alert metric | Unit | Description |
Redis Memory Usage | % | The memory usage. |
Redis Average Response Time | Microsecond | The average response time of Redis. |
Redis CPU Utilization | % | The CPU utilization of the Redis process. |
Redis Read Traffic Rate | KB/s | The size of data that is read from the database over the network per second. |
Redis Write Traffic Rate | KB/s | The size of data that is written to the database over the network per second. |
Redis Read Traffic Usage | % | The percentage of the read bandwidth to the total bandwidth. |
Redis Write Traffic Usage | % | The percentage of the write bandwidth to the total bandwidth. |
PostgreSQL
Alert metric | Unit | Description |
PostgreSQL CPU Utilization | % | The CPU utilization of the PostgreSQL process. |
PostgreSQL Active Sessions | Count | The number of active sessions. |
PostgreSQL IOPS Usage | % | The IOPS usage. |
PostgreSQL Disk Usage | % | The space usage of PostgreSQL. |
PolarDB for PostgreSQL
Alert metric | Unit | Description |
PolarDB for PostgreSQL CPU Utilization | % | The CPU utilization. |
PolarDB for PostgreSQL Memory Usage | % | The memory usage. |
PolarDB for PostgreSQL Active Sessions | Count | The number of active sessions. |
PolarDB for PostgreSQL Total IOPS | Per second | The total IOPS. |
Historical alert metrics
Starting from March 16, 2023, DAS provides new alert metrics. You can view the details of the historical alert metrics in this section. Historical alert metrics are no longer supported and will be discontinued. We recommend that you use the new alert metrics.