Help Center/ Data Admin Service/ API Reference/ APIs (in OBT)/ Intelligent O&M/ Querying Whether SQL Throttling Is Enabled
Updated on 2025-11-26 GMT+08:00
View PDF
Share

Querying Whether SQL Throttling Is Enabled

Function

This API is used to query whether SQL throttling is enabled. Currently, this function is supported only for RDS for MySQL instances.

Authorization Information

Each account has permissions to call all APIs, but IAM users must have the required permissions specifically assigned.

  • If you are using role/policy-based authorization, see the required permissions in Permissions Policies and Supported Actions.
  • If you are using identity policy-based authorization, the following identity policy-based permissions are required.

    Action

    Access Level

    Resource Type (*: Required)

    Condition Key

    Alias

    Dependency

    das:clouddba:showSqlLimitSwitchStatus

    read

    Instance

    -

    -

    -

URI

GET /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
Table 2 Query parameter

Parameter

Mandatory

Type

Description

datastore_type

Yes

String

Explanation:

Database type

Constraints:

N/A

Values:

MySQL

Default value:

N/A

Request Parameters

None

Response Parameters

Status code: 200

Table 3 Response body parameter

Parameter

Type

Description

switch_status

String

Explanation:

Switch status

Values:

  • ON
  • OFF

Example Request

Querying whether SQL throttling is enabled

GET https://das.cn-north-1.myhuaweicloud.com/v3/054c630ff780d4cc2f40c00d7f6fb21d/instances/6243b3fcf2f948578d46ed4c52fb54eein01/sql-limit/switch?datastore_type=MySQL

Example Responses

Status code: 200

Successful request

{
  "switch_status" : "ON"
}

Status Code

Status Code

Description

200

Successful request

400

Client error

500

Server error

Error Code

For details, see Error Codes.

Parent topic: Intelligent O&M