The following tables list the API operations available for use in Database Autonomy Service (DAS).
Instance connection
Operation | Description |
Adds a database instance. |
SQL throttling
Operation | Description |
Controls the number of database access requests and concurrent SQL requests. | |
Disables a throttling rule. | |
Disables all throttling rules that are in effect. | |
Queries the throttling rules that are in effect. | |
Queries the throttling rules that were triggered or the throttling rules that are in effect. | |
Generates a throttling keyword string based on an SQL statement. |
SQL diagnostics
Operation | Description |
Initiates a request for SQL diagnostics on a database instance connected to DAS. | |
Queries SQL diagnostics history on multiple pages. | |
Queries the results of an SQL diagnostics task. |
Intelligent stress testing
Operation | Description |
Queries the information about stress testing tasks. | |
Queries the information about a stress testing task. | |
Queries the configurations of a stress testing task. | |
Runs a stress testing task. | |
Creates a stress testing task. | |
Deletes a stress testing task. | |
Stops a stress testing task. | |
Creates a stress testing task on Advanced Database & Application Migration (ADAM). | |
Deletes the metadata of stopped database gateways. |
Diagnostics reports
Operation | Description |
Creates a diagnostics report. | |
Queries the information about diagnostics reports. |
Automatic SQL optimization
Operation | Description |
Queries the SQL optimization suggestions that are generated by DAS. | |
Enables, modifies, or disables the automatic SQL optimization feature for multiple database instances at a time. | |
Collects statistics on automatic SQL optimization tasks within a period of time, such as the total number of tasks and maximum improvement. |
Cache analysis
Operation | Description |
Creates a cache analysis task. | |
Queries the information about a cache analysis task. | |
Queries the information about cache analysis tasks. |
Inspection and scoring
Operation | Description |
Queries the inspection and scoring results of database instances. |
Event notification
Operation | Description |
Configures the event subscription settings of a database instance. | |
Queries the event subscription settings of a database instance. | |
Queries the content of a notification event. | |
Queries notification events based on a severity level. |
Hot key management for ApsaraDB for Redis instances
Operation | Description |
Queries hot keys in an ApsaraDB for Redis instance. | |
Queries hot keys and large keys in the memory of an ApsaraDB for Redis instance. | |
Queries the top 20 hot keys within a period of time. | |
Queries the top 20 large keys within a period of time. |
Query governance
Operation | Description |
Queries SQL templates that fail to be executed. | |
Queries the failed SQL statements in an SQL template. | |
Queries the suggestions provided by query governance to optimize an SQL template. | |
Queries the information about tags added by query governance to slow queries in database instances. | |
Queries the trend data of query governance. | |
Queries the information about the best-performing and worst-performing database instances based on query governance data. | |
Queries the information about SQL templates based on query governance data. | |
Adds one or more tags to an SQL template. | |
Queries the tags of an SQL template. | |
Queries the sharing URL of query governance. |
SQL Explorer
Operation | Description |
Asynchronously queries the MySQL error codes in the SQL Explorer data of a database instance and the number of SQL queries corresponding to each error code. | |
Asynchronously queries the number of failed executions of SQL templates in the SQL Explorer data of a database instance. | |
Asynchronously queries the IDs of SQL queries that generate a MySQL error code in the SQL Explorer data of a database instance. | |
Asynchronously queries the SQL sample data of up to 20 failed SQL queries in the SQL Explorer data of a database instance. | |
Queries the full request data by access source in the SQL Explorer data of a database instance. | |
Asynchronously queries the full request data by SQL ID in the SQL Explorer data of a database instance. | |
Queries the SQL sample data of up to 20 SQL queries by SQL ID in the SQL Explorer data of a database instance. | |
Queries the hot storage data for the new version of the SQL Explorer and Audit feature of a database instance within the last seven days. |
DAS Professional Edition management
Operation | Description |
Enables DAS Professional Edition for a database instance. | |
Disables DAS Professional Edition for a database instance. | |
Queries the storage usage of the SQL Explorer data of a database instance. | |
Queries whether DAS Professional Edition is enabled for a database instance. |
Session management
Operation | Description |
Queries the data of the current session on an ApsaraDB for Redis instance. | |
Terminates all sessions of an ApsaraDB for Redis instance. | |
Creates a task that terminates the sessions of a database instance. | |
Queries the results of a task that terminates the sessions of a database instance. | |
Asynchronously queries the sessions of a database instance and collects statistics on the sessions from different dimensions. |
Automatic SQL throttling
Operation | Description |
Asynchronously specifies the parameters of automatic SQL throttling for multiple database instances at a time. | |
Queries the automatic SQL throttling rules of database instances. | |
Disables the automatic SQL throttling feature for multiple database instances at a time. |
Automatic tablespace optimization
Operation | Description |
Asynchronously specifies the parameters of the automatic tablespace fragment recycling feature for multiple database instances at a time. | |
Queries the automatic tablespace fragment recycling rules of database instances. | |
Disables the automatic tablespace fragment recycling feature for multiple database instances at a time. |
Auto scaling
Operation | Description |
Modifies the auto scaling configurations of a database instance. | |
Queries the auto scaling configurations of a database instance. | |
Disables the auto scaling feature for a database instance. |
Heatmap
Operation | Description |
Queries the access frequencies and hot data on the partitions of a PolarDB-X 2.0 instance. |
Performance insight (new version)
Operation | Description |
Queries the SQL sample data for the new version of the performance insight feature of a database instance. | |
Queries the trend of a metric for the new version of the performance insight feature of a database instance. | |
Queries the full request data by SQL ID for the new version of the performance insight feature of a database instance. |