Document Center

All Products

Document Center

List of operations by function

Last Updated: Oct 12, 2021

The following tables list API operations available for use in AnalyticDB for MySQL.

Cluster management

Operation	Description
CreateDBCluster	Creates an AnalyticDB for MySQL cluster.
DescribeDBClusters	Queries AnalyticDB for MySQL clusters that belong to an Alibaba Cloud account or a Resource Access Management (RAM) user.
ModifyDBCluster	Changes the configurations of an AnalyticDB for MySQL cluster.
DeleteDBCluster	Deletes an AnalyticDB for MySQL cluster.
DescribeDBClusterAttribute	Queries the details of an AnalyticDB for MySQL cluster.
ModifyDBClusterMaintainTime	Modifies the maintenance window of an AnalyticDB for MySQL cluster.
DescribeAutoRenewAttribute	Queries the auto-renewal status of a subscription AnalyticDB for MySQL cluster.
ModifyAutoRenewAttribute	Modifies the auto-renewal status of a subscription AnalyticDB for MySQL cluster.
ModifyDBClusterDescription	Modifies the description of an AnalyticDB for MySQL cluster to facilitate cluster maintenance and management.
DescribeAvailableResource	Queries the resources that are available within a specified zone.
ModifyDBClusterResourceGroup	Moves an AnalyticDB for MySQL cluster to a specified resource group.

Resource pool management

Operation	Description
CreateDBResourcePool	Creates a resource pool. This operation can be used only for AnalyticDB for MySQL elastic clusters.
DeleteDBResourcePool	Deletes a resource pool. This operation can be used only for AnalyticDB for MySQL elastic clusters.
DescribeDBResourcePool	Queries the resource pool information of a cluster. This operation can be used only for AnalyticDB for MySQL elastic clusters.
ModifyDBResourcePool	Updates resources within a resource pool. This operation can be used only for AnalyticDB for MySQL elastic clusters.
BindDBResourcePoolWithUser	Binds a resource pool to a database account. This operation can be used only for AnalyticDB for MySQL elastic clusters.
UnbindDBResourcePoolWithUser	Unbinds a user from a resource pool. This operation can be used only for AnalyticDB for MySQL elastic clusters.

Elastic plan management

Operation	Description
CreateElasticPlan	Creates an elastic plan. This operation can be used only for AnalyticDB for MySQL elastic clusters.
DeleteElasticPlan	Deletes an elastic plan. This operation can be used only for AnalyticDB for MySQL elastic clusters.
DescribeElasticDailyPlan	Queries the daily plan of an elastic plan. This operation can be used only for AnalyticDB for MySQL elastic clusters.
DescribeElasticPlan	Queries an elastic plan. This operation can be used only for AnalyticDB for MySQL elastic clusters.
ModifyElasticPlan	Modifies an elastic plan. This operation can be used only for AnalyticDB for MySQL elastic clusters.

Database management

Operation	Description
DescribeTables	Enumerates all tables of a specific database within a cluster.
DescribeAllDataSource	Enumerates all databases, tables, and columns within a cluster.
DescribeSchemas	Enumerates all databases within a cluster.
DescribeTableDetail	Queries the details of a table and the deviation extent of partitions.
DescribeProcessList	Queries the queries that are being executed within a cluster.
DescribeColumns	Enumerates the columns of a specific table within a cluster.
DescribeTaskInfo	Queries the progress of a task.
DescribeSQLPlan	Queries the basic information of an executed SQL statement and the information of a plan.
DescribeSQLPlanTask	Queries the information of a task.
KillProcess	Terminates an ongoing process.
DescribeTablePartitionDiagnose	Diagnoses list partitions of a table.

Log management

Operation	Description
DescribeSlowLogRecord	Queries slow query logs of an AnalyticDB for MySQL cluster.
DescribeSlowLogTrend	Queries the trend of slow query logs of an AnalyticDB for MySQL cluster.
DescribeAuditLogConfig	Queries the audit log configurations of an AnalyticDB for MySQL cluster.
ModifyAuditLogConfig	Modifies the audit log configurations of an AnalyticDB for MySQL cluster.
DescribeAuditLogRecords	Queries the SQL audit logs of an AnalyticDB for MySQL cluster.

Region management

Operation	Description
DescribeRegions	Queries the regions and zones where AnalyticDB for MySQL is available.

Network management

Operation	Description
AllocateClusterPublicConnection	Applies for a public endpoint for an AnalyticDB for MySQL cluster.
DescribeDBClusterNetInfo	Queries the network information of an AnalyticDB for MySQL cluster.
ReleaseClusterPublicConnection	Releases the public endpoint of an AnalyticDB for MySQL cluster.
ModifyClusterConnectionString	Modifies the endpoint of an AnalyticDB for MySQL cluster.

Account management

Operation	Description
CreateAccount	Creates a database account for an AnalyticDB for MySQL cluster.
DeleteAccount	Deletes a database account for an AnalyticDB for MySQL cluster.
DescribeAccounts	Queries the database account information of an AnalyticDB for MySQL cluster.
DescribeOperatorPermission	Queries the details of the permissions granted to the service account of an AnalyticDB for MySQL cluster.
GrantOperatorPermission	Grants permissions to the service account of an AnalyticDB for MySQL cluster.
ResetAccountPassword	Resets the password of a database account for an AnalyticDB for MySQL cluster.
RevokeOperatorPermission	Revokes permissions from the service account of an AnalyticDB for MySQL cluster.
ModifyAccountDescription	Modifies the description of a database account for an AnalyticDB for MySQL cluster.
DescribeAllAccounts	Queries the information of an account or the list of accounts of a specific database in a specific cluster.

Tag management

Operation	Description
TagResources	Adds tags to AnalyticDB for MySQL clusters.
ListTagResources	Queries tags that are added to one or more clusters, or clusters that have one or more tags added.
UntagResources	Removes tags from AnalyticDB for MySQL clusters. If the tags are not added to other clusters, the tags are deleted.

Backup and restoration

Operation	Description
DescribeBackups	Queries the backup sets of an AnalyticDB for MySQL cluster.
DescribeBackupPolicy	Queries the backup settings of an AnalyticDB for MySQL cluster.
ModifyBackupPolicy	Modifies the backup policy of an AnalyticDB for MySQL cluster.
ModifyLogBackupPolicy	Modifies the log backup configurations of an AnalyticDB for MySQL cluster.

Security management

Operation	Description
DescribeDBClusterAccessWhiteList	Queries the IP address whitelists of an AnalyticDB for MySQL cluster.
ModifyDBClusterAccessWhiteList	Modifies an IP address whitelist of an AnalyticDB for MySQL cluster.

Monitoring management

Operation	Description
DescribeDBClusterPerformance	Queries the performance data of an AnalyticDB for MySQL cluster.
DescribeDBClusterResourcePoolPerformance	Queries the monitoring information of resource pools within an AnalyticDB for MySQL elastic cluster.
DescribeInclinedTables	Queries the monitoring information of a table.
DescribeTableStatistics	Queries table information statistics in an AnalyticDB for MySQL cluster.

O&M events

Operation	Description
DescribeMaintenanceAction	Queries the details of an O&M event.
ModifyMaintenanceAction	Changes the switching time of a pending O&M event.

SQL diagnostics

Operation	Description
DescribeDiagnosisRecords	Queries the summary information of SQL queries that meet specific search conditions in an AnalyticDB for MySQL cluster.
DescribeDiagnosisDimensions	Queries the deduplicated statistics of SQL queries that meet specific search conditions in an AnalyticDB for MySQL cluster. These statistics include the resource group, database name, username, and source IP address.
DescribeDownloadRecords	Queries the most recent five download tasks for SQL queries in an AnalyticDB for MySQL cluster.
DownloadDiagnosisRecords	Downloads the summary information of SQL queries that meet specific conditions in an AnalyticDB for MySQL cluster.

Cluster running reports

Operation	Description
DescribeTableAccessCount	Queries the number of accesses to one or all tables within an AnalyticDB for MySQL cluster for a specified date.
DescribeSqlPattern	Queries the details of an SQL pattern within an AnalyticDB for MySQL cluster for a specified date.
DescribeDBClusterHealthReport	Queries the average and maximum values of key performance metrics such as CPU utilization, disk IOPS, and disk I/O throughput in the health report of an AnalyticDB for MySQL cluster for a specified date.
DescribeDBClusterForecast	Queries the trend forecast information of disk usage, queries per second (QPS), and transactions per second (TPS) of an AnalyticDB for MySQL cluster for a specified date.

How helpful was this page?

What might be the problems?

More suggestions?