Help Center/ Data Admin Service/ API Reference/ APIs (in OBT)/ Intelligent O&M/ Querying Whether Collect All Query Logs and Collect Slow Query Logs Are Enabled
Updated on 2026-01-20 GMT+08:00
View PDF
Share

Querying Whether Collect All Query Logs and Collect Slow Query Logs Are Enabled

Function

This API is used to query whether Collect All Query Logs and Collect Slow Query Logs are enabled. This function is available only for paid instances.

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:showSqlSwitchStatus

    read

    Instance

    -

    -

    -

URI

GET /v3/{project_id}/instances/{instance_id}/sql/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. Only letters and digits are allowed.

Default Value

N/A

instance_id

Yes

String

Definition

Unique ID of an instance

Constraints

N/A

Range

The value can contain 32 characters. Only letters and digits are allowed.

Default Value

N/A
Table 2 Query parameters

Parameter

Mandatory

Type

Description

type

Yes

String

Definition

Switch type

Constraints

N/A

Range

  • DAS SQL Explorer: Collect All Query Logs
  • DAS Slow Query Log: Collect Slow Query Logs

Default Value

N/A

datastore_type

Yes

String

Definition

Database type

Constraints

Collect All Query Logs is available to MySQL and TaurusDB. Collect Slow Query Logs is available to MySQL, TaurusDB, and PostgreSQL.

Range

  • MySQL
  • TaurusDB
  • PostgreSQL

Default Value

N/A

Request Parameters

None

Response Parameters

Status code: 200

Table 3 Response body parameters

Parameter

Type

Description

status

String

Definition

Switch status

Range

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

retention_days

Long

Definition

Days for storing SQL data

Range

[1,30]

Example Requests

Querying whether Slow Query Log is enabled

GET https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/instances/da304cd5bbb944de828759bc7be3d3fein01/sql/switch?type=DAS Slow Query Log&datastore_type=MySQL

Example Responses

Status code: 200

DAS status response body

{
  "status" : "Enabled",
  "retention_days" : 7
}

Status Codes

Status Code

Description

200

DAS status response body.

400

Client error.

500

Server error.

Error Codes

See Error Codes.

Parent topic: Intelligent O&M