Adding a SQL Statement Concurrency Control Rule for a Database
Function
This API is used to add a SQL statement concurrency control rule for a database.
- Before calling an API, you need to understand the API in Authentication.
URI
- 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
Parameter |
Mandatory |
Type |
Description |
---|---|---|---|
db_name |
Yes |
String |
Database name. |
query_id |
No |
Long |
Internal hash code calculated by the SQL parse tree. The default value is 0. The value range is from -9223372036854775808 to 9223372036854775807. |
query_string |
No |
String |
Text format of an SQL statement. Only either query_id or query_string can be specified. |
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. |
search_path |
No |
String |
Schema search order set for names that are not schema-qualified. The default value is public. |
Example Request
Add a SQL statement concurrency control rule for a database.
POST https://rds.ap-southeast-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/instances/49b9dd1d6f464ba4bc91df5cbd2e52ebin03/sql-limit { "db_name" : "postgres", "query_id" : 1, "max_concurrency" : 10, "max_waiting" : 10, "search_path" : "public" }
Response
- Normal response
Table 3 Parameters Parameter
Type
Description
resp
String
Returns successful if the invoking is successful.
- Example normal response
{ "resp" : "successful" }
- Abnormal response
For details, see Abnormal Request Results.
Status Code
- Normal
- Abnormal
For details, see Status Codes.
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