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 2025-05-19 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.

URI

GET /v3/{project_id}/instances/{instance_id}/sql/switch

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
Table 2 Query parameters

Parameter

Mandatory

Type

Description

type

Yes

String

Explanation:

Switch type

Constraints:

N/A

Values:

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

Default value:

N/A

datastore_type

Yes

String

Explanation:

Database type

Constraints:

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

Values:

  • 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

Explanation:

Switch status

Values:

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

retention_days

Long

Explanation:

Days for storing SQL data

Values:

[1,30]

Example Request

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 Response

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