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
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
Parameter |
Mandatory |
Type |
Description |
---|---|---|---|
switch_status |
Yes |
String |
Explanation: Switch status Values:
|
datastore_type |
Yes |
String |
Explanation: Database type Values:
|
Response Parameters
Status code: 200
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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot