Modifying a SQL Throttling Rule

Function

This API is used to modify a SQL throttling rule. Currently, this function is only available to RDS for PostgreSQL.

URI

PUT /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: PostgreSQL Default value: N/A
sql_limit_rule_ids	Yes	Array of strings	Explanation: ID of a SQL throttling rule Constraints: N/A Values: N/A Default value: N/A
database_name	No	String	Explanation: Database name Constraints: Mandatory for RDS for PostgreSQL Values: N/A Default value: N/A
sql_limit_rule	Yes	Objects in Table 3	Explanation: SQL throttling rule to be modified Constraints: N/A Values: N/A Default value: N/A

**Table 3** UpdateSqlLimitRuleOption
Parameter	Mandatory	Type	Description
max_concurrency	Yes	Integer	Explanation: Maximum concurrent SQL statements Constraints: N/A Values: [0, 2^31-1]. The actual value depends on the query result. Default value: N/A
max_waiting	No	Integer	Explanation: Maximum waiting time Constraints: N/A Values: [0, 2^31-1]. The actual value depends on the query result. Default value: N/A

Response Parameters

Status code: 200

None

Example Request

Creating a SQL throttling rule

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

{
    "datastore_type": "postgresql",
    "database_name": "postgres",
    "sql_limit_rule_ids": [
        "1",
        "4"
    ],
    "sql_limit_rule": {
        "max_concurrency": 5,
        "max_waiting": 5
    }
}