Updated on 2024-06-07 GMT+08:00

Modifying a SQL Statement Concurrency Control Rule

Function

This API is used to modify a SQL statement concurrency control rule.

  • Before calling an API, you need to understand the API in Authentication.

URI

  • URI format

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

  • Parameter description
    Table 1 Parameters

    Parameter

    Mandatory

    Description

    project_id

    Yes

    Project ID of a tenant in a region.

    To obtain it, refer to Obtaining a Project ID.

    instance_id

    Yes

    Instance ID.

Request

Table 2 Parameters

Parameter

Mandatory

Type

Description

db_name

Yes

String

Database name.

id

Yes

String

Concurrency control rule ID.

max_concurrency

Yes

Integer

Number of SQL statements that can be executed at the same time. If the value is less than or equal to 0, the number is not limited. The default value is 0. The value range is from -1 to 50000.

max_waiting

Yes

Integer

Maximum waiting time, in seconds.

Example Request

Modify a SQL statement concurrency control 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 
 }

Response

  • Normal response
    Table 3 Parameters

    Parameter

    Type

    Description

    resp

    String

    Returns successful if the invoking is successful.

Status Code

Error Code

For details, see Error Codes.