Modifying a SQL Throttling Rule

Function

This API is used to modify a SQL throttling rule.

Before calling this API, learn how to authenticate it.
Before calling this API, learn about request header parameters.

URI

URI format
PUT /v3/{project_id}/instances/{instance_id}/sql-limit/update

Parameter description

**Table 1** Parameters
Parameter	Mandatory	Description
project_id	Yes	Definition Project ID of a tenant in a region. To obtain the value, see Obtaining a Project ID. Constraints N/A Range N/A Default Value N/A
instance_id	Yes	Definition Instance ID. Constraints N/A Range N/A Default Value N/A

Request

**Table 2** Parameters
Parameter	Mandatory	Type	Description
db_name	Yes	String	Definition Database name. Constraints N/A Range N/A Default Value N/A
id	Yes	String	Definition SQL throttling rule ID. Constraints N/A Range N/A Default Value N/A
max_concurrency	Yes	Integer	Definition Number of SQL statements that can be executed at the same time. Constraints N/A Range -1–50000. If the value is less than or equal to 0, the number is not limited. Default Value 0
max_waiting	Yes	Integer	Definition Maximum waiting time, in seconds. Constraints N/A Range N/A Default Value N/A

Example Request

Modify a SQL throttling rule.

PUT https://rds.ap-southeast-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/instances/49b9dd1d6f464ba4bc91df5cbd2e52ebin03/sql-limit/update

{ 
   "db_name" : "postgres", 
   "id" : "1", 
   "max_concurrency" : 10, 
   "max_waiting" : 10 
 }