Help Center/ Data Admin Service/ API Reference/ APIs (in OBT)/ Cloud DBA/ Querying Whether SQL Statement Concurrency Control Is Enabled

Updated on 2024-08-05 GMT+08:00

View PDF

Querying Whether SQL Statement Concurrency Control Is Enabled

Function

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

URI

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

**Table 1** Path parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Project ID. To obtain this value, see Obtaining a Project ID.
instance_id	Yes	String	Instance ID.

**Table 2** Query parameters
Parameter	Mandatory	Type	Description
datastore_type	Yes	String	Database type. The value can be: MySQL

Request Parameters

**Table 3** Request header parameters
Parameter	Mandatory	Type	Description
X-Auth-Token	Yes	String	User token.
X-Language	No	String	Language. The value can be: zh-cn en-us

Response Parameters

Status code: 200

**Table 4** Response body parameters
Parameter	Type	Description
switch_status	String	Switch status. The value can be: ON OFF

Status code: 400

**Table 5** Response body parameters
Parameter	Type	Description
error_code	String	Error code. Minimum length: 8 Maximum length: 36
error_msg	String	Error message. Minimum length: 2 Maximum length: 512

Status code: 500

**Table 6** Response body parameters
Parameter	Type	Description
error_code	String	Error code. Minimum length: 8 Maximum length: 36
error_msg	String	Error message. Minimum length: 2 Maximum length: 512

Example Requests

Querying whether SQL Statement Concurrency Control is enabled

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