Help Center/ Data Admin Service/ API Reference/ APIs (in OBT)/ Intelligent O&M/ Enabling or Disabling Historical Transactions
Updated on 2026-01-20 GMT+08:00

Enabling or Disabling Historical Transactions

Function

This API is used to enable or disable Historical Transactions, which is only available to RDS for MySQL and depends on Collect Slow Query Logs and Collect All Query Logs.

Authorization Information

Each account has permissions to call all APIs, but IAM users must have the required permissions specifically assigned.

  • If you are using role/policy-based authorization, see the required permissions in Permissions Policies and Supported Actions.
  • If you are using identity policy-based authorization, the following identity policy-based permissions are required.

    Action

    Access Level

    Resource Type (*: required)

    Condition Key

    Alias

    Dependencies

    das:clouddba:changeTransactionSwitch

    Write

    Instance

    -

    -

    -

URI

POST /v3/{project_id}/instances/{instance_id}/transaction/switch

Table 1 URI parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Definition

Project ID of a tenant in a region.

To obtain this value, see Obtaining a Project ID.

Constraints

N/A

Range

The value can contain 32 characters, including only letters and digits.

Default Value

N/A

instance_id

Yes

String

Definition

Unique ID of an instance

Constraints

N/A

Range

The value can contain 32 characters, including only letters and digits.

Default Value

N/A

Request Parameters

Table 2 Request body parameters

Parameter

Mandatory

Type

Description

switch_status

Yes

String

Definition

Switch status

Constraints

N/A

Range

  • 0: disabled
  • 1: enabled

Default Value

N/A

datastore_type

Yes

String

Definition

Database type

Constraints

Only RDS for MySQL is supported.

Range

  • MySQL

Default Value

N/A

Response Parameters

Status code: 200

Table 3 Response body parameters

Parameter

Type

Description

switch_status

String

Definition

Switch status

Range

  • Enabled: The function is enabled.
  • Disabled: The function is disabled.
  • Switching: The status is being switched.

Example Requests

Enabling Collect All Query Logs

POST https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/instances/da304cd5bbb944de828759bc7be3d3fein01/sql/switch"
POST https://das.cn-north-1.myhuaweicloud.com/v3/054c630ff780d4cc2f40c00d7f6fb21d/instances/d871e13ee1044e21a473330cd67047cbin01/transaction/switch"

{
   "switch_status":"Enabled",
 "datastore_type":"MySQL"
}

Example Responses

Status code: 200

Response body

{
  "switch_status" : "Enabled"
}

Status Codes

Status Code

Description

200

Response body

400

Client error

500

Server error

Error Codes

See Error Codes.