Updated on 2026-01-20 GMT+08:00

Deleting a SQL Throttling Rule

Function

  • This API is used to delete a SQL throttling rule.
  • Currently, only MySQL is supported.

Authorization Information

Each account has permissions to call all APIs, but IAM users must have the required permissions specifically assigned.

  • If you are using role/policy-based authorization, see the required permissions in Permissions Policies and Supported Actions.
  • If you are using identity policy-based authorization, the following identity policy-based permissions are required.

    Action

    Access Level

    Resource Type (*: required)

    Condition Key

    Alias

    Dependencies

    das:clouddba:deleteSqlLimitRules

    Write

    Instance

    -

    -

    -

URI

DELETE /v3/{project_id}/instances/{instance_id}/sql-limit/rules

Table 1 URI parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Definition

Project ID of a tenant in a region

To obtain this value, see Obtaining a Project ID.

Constraints

N/A

Range

The value can contain 32 characters, including only letters and digits.

Default Value

N/A

instance_id

Yes

String

Definition

Unique ID of an instance

Constraints

N/A

Range

The value can contain 32 characters, including only letters and digits.

Default Value

N/A

Request Parameters

Table 2 Request body parameters

Parameter

Mandatory

Type

Description

datastore_type

Yes

String

Definition

Database type

Constraints

N/A

Range

  • MySQL

Default Value

N/A

sql_limit_rule_ids

Yes

Array of strings

Definition

ID of a SQL throttling rule

Constraints

Multiple values need to be separated by commas (,).

Range

N/A

Default Value

N/A

database_name

No

String

Definition

Database name

Constraints

Only MySQL databases are supported.

Range

N/A

Default Value

N/A

Response Parameters

Status code: 200

None

Example Requests

Deleting a SQL throttling rule

DELETE https://das.cn-north-1.myhuaweicloud.com/v3/054c630ff780d4cc2f40c00d7f6fb21d/instances/d871e13ee1044e21a473330cd67047cbin01/sql-limit/rules

{
  "datastore_type" : "MySQL",
  "sql_limit_rule_ids" : [ "6", "7" ]
}

Example Responses

None

Status Codes

Status Code

Description

200

Successful response

400

Client error

500

Server error

Error Codes

See Error Codes.