Killing Sessions

Function

Kill sessions. Sessions are killed by user, database, or session ID. Currently, this function is supported only for MySQL DB instances.

URI

DELETE /v3/{project_id}/instances/{instance_id}/process

**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.

Request Parameters

**Table 2** 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

**Table 3** Request body parameters
Parameter	Mandatory	Type	Description
db_user_id	Yes	String	Database user ID.
process_ids	No	Array of strings	Session IDs. Specify at least one parameter among process_ids, user, and database.
user	No	String	User.
database	No	String	Database name.

Response Parameters

Status code: 400

**Table 4** 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 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

Example Requests

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" ]
}