Deleting a SQL Throttling Rule

Function

This API is used to delete a SQL throttling rule. Currently, this function is supported only for MySQL databases.

URI

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

**Table 1** URI parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Explanation: Project ID of a tenant in a region To obtain this value, see Obtaining a Project ID. Constraints: N/A Values: The value can contain 32 characters. Only letters and digits are allowed. Default value: N/A
instance_id	Yes	String	Explanation: Unique ID of an instance Constraints: N/A Values: The value can contain 32 characters. Only letters and digits are allowed. Default value: N/A

Request Parameters

**Table 2** Request body parameters
Parameter	Mandatory	Type	Description
datastore_type	Yes	String	Explanation: Database type Constraints: N/A Values: MySQL Default value: N/A
sql_limit_rule_ids	Yes	Array of strings	Explanation: ID of a SQL throttling rule Constraints: Multiple values need to be separated by commas (,). Values: N/A Default value: N/A
database_name	No	String	Explanation: Database name Constraints: Only MySQL databases are supported. Values: N/A Default value: N/A

Response Parameters

Status code: 200

None

Example Request

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" ]
}