Killing Sessions
Function
Kill sessions. Sessions are killed by user, database, or session ID. Currently, only MySQL instances are supported.
URI
DELETE /v3/{project_id}/instances/{instance_id}/process
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
Parameter |
Mandatory |
Type |
Description |
---|---|---|---|
db_user_id |
Yes |
String |
Explanation: Database user ID, that is, ID of a connection established between the database account and the database. A database user ID is created by calling the API in Registering a Database User. Constraints: N/A Values: The value is a UUID containing 36 characters. Only letters, digits, and hyphens (-) are allowed. Default value: N/A |
process_ids |
No |
Array of strings |
Explanation: Session ID list Constraints: At least one of the process_ids, user, and database parameters must be specified. Values: [0, 2^31-1]. The actual value depends on the query result. Default value: N/A |
user |
No |
String |
Explanation: Database user Constraints: At least one of the process_ids, user, and database parameters must be specified. Values: N/A Default value: N/A |
database |
No |
String |
Explanation: Database name Constraints: At least one of the process_ids, user, and database parameters must be specified. Values: N/A Default value: N/A |
Response Parameters
Status code: 200
None
Example Request
Killing sessions by user, database, or session
DELETE https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/instances/da304cd5bbb944de828759bc7be3d3fein01/process { "db_user_id" : "2c250598-1e3c-4d31-bc19-be1d866247e6", "database" : "example", "user" : "aaa", "process_ids" : [ "11212", "3423222" ] }
Example Response
None
Status Codes
Status Code |
Description |
---|---|
200 |
Successful request |
400 |
Bad request |
500 |
Internal server error |
Error Codes
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