The following tables describe the API operations available for use in Database Autonomy Service (DAS).

Instance connection

API Description
AddHDMInstance Adds a database instance.

SQL throttling

API Description
EnableSqlConcurrencyControl Controls the number of database access requests and concurrent SQL requests.
DisableSqlConcurrencyControl Disables a specific throttling rule.
DisableAllSqlConcurrencyControlRules Disables all throttling rules that are in effect.
GetRunningSqlConcurrencyControlRules Queries the throttling rules that are in effect.
GetSqlConcurrencyControlRulesHistory Queries the throttling rules that were triggered or the throttling rules that are in effect.
GetSqlConcurrencyControlKeywordsFromSqlText Generates throttling keyword strings based on the original SQL statements.

SQL diagnostics

API Description
CreateRequestDiagnosis Initiates an SQL statement diagnostic request on an instance connected to DAS.
GetRequestDiagnosisPage Displays SQL diagnostic history on multiple pages.
GetRequestDiagnosisResult Queries the results of an SQL statement diagnostic task.

Intelligent stress testing

API Description
DescribeCloudBenchTasks Queries the list of stress testing tasks.
DescribeCloudbenchTask Queries the details of a stress testing task.
DescribeCloudbenchTaskConfig Queries the configuration of a stress testing task.
RunCloudBenchTask Runs a stress testing task.
CreateCloudBenchTasks Creates a stress testing task.
DeleteCloudBenchTask Deletes a stress testing task.
StopCloudBenchTask Stops a stress testing task.
DeleteStopGateway Deletes the metadata of stopped DBGateways.

Diagnostic reports

API Description
CreateDiagnosticReport Creates a diagnostic report.
DescribeDiagnosticReportList Queries the list of diagnostic reports.

Automatic SQL optimization

API Description
GetSqlOptimizeAdvice Queries the SQL optimization suggestions that are generated by DAS.

Cache analysis

API Description
CreateCacheAnalysisJob Creates a cache analysis task.
DescribeCacheAnalysisJob Queries the details of a cache analysis task.
DescribeCacheAnalysisJobs Queries the list of cache analysis tasks.

Inspection and scoring

API Description
GetInstanceInspections Queries the inspection and scoring results of database instances.

Event notification

API Description
GetAutonomousNotifyEventContent Queries the details of a notification event.
GetAutonomousNotifyEventsInRange Queries notification events based on a specific severity level.

Hot key management for ApsaraDB for Redis instances

API Description
DescribeHotKeys Queries hot keys in an ApsaraDB for Redis instance.
DescribeHotBigKeys Queries hot keys and large keys in the memory of a database instance.
DescribeTopHotKeys Queries the top 20 hot keys within a specific period of time.
DescribeTopBigKeys Queries the top 20 large keys within a specific period of time.

Query governance

API Description
GetQueryOptimizeExecErrorStats Queries SQL templates that fail to be executed.
GetQueryOptimizeExecErrorSample Queries the failed SQL statements under a specified SQL template.
GetQueryOptimizeSolution Obtains suggestions provided by query governance for optimizing a specified SQL template.
GetQueryOptimizeRuleList Obtains the tags added by query governance to specified database instances.
GetQueryOptimizeDataTrend Obtains query governance trend data.
GetQueryOptimizeDataTop Queries information of the best-performing and worst-performing instances based on query governance data.
GetQueryOptimizeDataStats Obtains information of SQL templates based on query governance data.

SQL Explorer

API Description
GetAsyncErrorRequestStatByCode Asynchronously queries the MySQL error codes in SQL Explorer data and the number of SQL queries corresponding to each error code.
GetAsyncErrorRequestStatResult Asynchronously queries the number of failed executions of specified SQL templates based on SQL Explorer data.
GetAsyncErrorRequestListByCode Asynchronously queries the IDs of SQL queries that generate the specified MySQL error code in the SQL Explorer results of a database instance.
GetErrorRequestSample Asynchronously queries information of up to 20 failed SQL queries from SQL Explorer data.
GetFullRequestOriginStatByInstanceId Collects the full request statistics in the SQL Explorer results of a database instance by access source.
GetFullRequestStatResultByInstanceId Asynchronously collects the full request statistics in the SQL Explorer results of a database instance by SQL ID.

DAS Professional Edition management

API Description
EnableDasPro Enables DAS Professional Edition for a specified database instance.
DisableDasPro Disables DAS Professional Edition for a specified database instance.
GetDasProServiceUsage Queries SQL Explorer data usage of a specified database instance.
DescribeInstanceDasPro Indicates whether DAS Professional Edition is enabled for a specified database instance.

Session management

API Description
KillInstanceAllSession Terminates all sessions of a specified database instance.