Help Center/ Data Admin Service/ API Reference/ APIs (in OBT)/ Intelligent O&M/ Enabling or Disabling SQL Throttling
Updated on 2025-05-19 GMT+08:00

Enabling or Disabling SQL Throttling

Function

This API is used to enable or disable SQL throttling. Currently, this function is supported only for MySQL databases.

URI

POST /v3/{project_id}/instances/{instance_id}/sql-limit/switch

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

None

Table 2 Request body parameters

Parameter

Mandatory

Type

Description

switch_status

Yes

String

Explanation:

Switch status

Values:

  • ON
  • OFF

datastore_type

Yes

String

Explanation:

Database type

Values:

  • MySQL

Response Parameters

Status code: 200

Table 3 Response body parameter

Parameter

Type

Description

job_id

String

Explanation:

ID of a SQL throttling task

Values:

N/A

Example Request

Enabling SQL throttling

POST https://das.cn-north-1.myhuaweicloud.com/v3/054c630ff780d4cc2f40c00d7f6fb21d/instances/6243b3fcf2f948578d46ed4c52fb54eein01/sql-limit/switch

{
  "datastore_type" : "MySQL",
  "switch_status" : "ON"
}

Example Responses

Status code: 200

Successful request

{
  "job_id" : "15535"
}

Status Code

Status Code

Description

200

Successful request

400

Client error.

500

Server error.

Error Code

For details, see Error Codes.