Updated on 2025-05-19 GMT+08:00

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

Table 1 URI parameters

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

Table 2 Request body 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.