管理与支持产品文档捉虫活动邀您参加！> HOT
文档中心>API 中心>腾讯云数据仓库 TCHouse-P>集群管理>查询DB参数操作历史操作

查询DB参数操作历史操作

最近更新时间：2025-04-25 01:15:19

我的收藏

本页目录：

1. 接口描述

接口请求域名： cdwpg.tencentcloudapi.com 。

DescribeDBConfigHistory1

默认接口请求频率限制：20次/秒。

推荐使用 API Explorer
点击调试
API Explorer 提供了在线调用、签名验证、SDK 代码生成和快速检索接口等能力。您可查看每次调用的请求内容和返回结果以及自动生成 SDK 调用示例。

2. 输入参数

以下请求参数列表仅列出了接口请求参数和部分公共参数，完整公共参数列表见 公共请求参数。

参数名称 必选 类型 描述
Action 是 String 公共参数，本接口取值：DescribeDBConfigHistory。
Version 是 String 公共参数，本接口取值：2020-12-30。
Region 是 String 公共参数，详见产品支持的 地域列表。
InstanceId 是 String 实例Id
示例值：cdwpg-as
Limit 否 Integer 数据库分页
示例值：10
Offset 否 Integer 数据库分页
示例值：1

3. 输出参数

参数名称 类型 描述
TotalCount Integer 总数
示例值：1
ConfigHistory Array of ConfigHistory 历史参数
示例值：[{"CreatedAt":"2025-03-17T18:07:25+08:00","Id":4615,"InstanceId":"cdwpg-9jcyk7yp",...},...]
RequestId String 唯一请求 ID，由服务端生成，每次请求都会返回（若请求因其他原因未能抵达服务端，则该次请求不会获得 RequestId）。定位问题时需要提供该次请求的 RequestId。

4. 示例

示例1 配置更改历史查询

输入示例

POST / HTTP/1.1
Host: cdwpg.tencentcloudapi.com
Content-Type: application/json
X-TC-Action: DescribeDBConfigHistory
<公共请求参数>

{
    "InstanceId": "cdwpg-xx",
    "Limit": 10,
    "Offset": 0
}

输出示例

{
    "Response": {
        "ConfigHistory": [
            {
                "CreatedAt": "2025-03-17T18:07:25+08:00",
                "Id": 4615,
                "InstanceId": "cdwpg-9jcyk7yp",
                "NodeType": "cn",
                "ParamName": "lock_timeout",
                "ParamNewValue": "29999",
                "ParamOldValue": "30000",
                "Status": "success",
                "UpdatedAt": "2025-03-17T18:07:51+08:00"
            },
            {
                "CreatedAt": "2025-02-27T16:44:39+08:00",
                "Id": 4570,
                "InstanceId": "cdwpg-9jcyk7yp",
                "NodeType": "cn",
                "ParamName": "modify_hba_params",
                "ParamNewValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"9.0.0.0\",\"mask\":\"24\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"trust\"}]",
                "ParamOldValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"9.0.0.0\",\"mask\":\"24\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"9.0.0.0\",\"mask\":\"24\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"trust\"}]",
                "Status": "success",
                "UpdatedAt": "2025-02-27T16:45:06+08:00"
            },
            {
                "CreatedAt": "2025-02-27T16:43:27+08:00",
                "Id": 4569,
                "InstanceId": "cdwpg-9jcyk7yp",
                "NodeType": "cn",
                "ParamName": "modify_hba_params",
                "ParamNewValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"9.0.0.0\",\"mask\":\"24\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"9.0.0.0\",\"mask\":\"24\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"trust\"}]",
                "ParamOldValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"9.0.0.0\",\"mask\":\"24\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"trust\"}]",
                "Status": "success",
                "UpdatedAt": "2025-02-27T16:43:54+08:00"
            },
            {
                "CreatedAt": "2025-02-27T16:40:42+08:00",
                "Id": 4568,
                "InstanceId": "cdwpg-9jcyk7yp",
                "NodeType": "cn",
                "ParamName": "modify_hba_params",
                "ParamNewValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"9.0.0.0\",\"mask\":\"24\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"trust\"}]",
                "ParamOldValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"trust\"}]",
                "Status": "success",
                "UpdatedAt": "2025-02-27T16:41:09+08:00"
            },
            {
                "CreatedAt": "2025-02-27T16:39:21+08:00",
                "Id": 4567,
                "InstanceId": "cdwpg-9jcyk7yp",
                "NodeType": "cn",
                "ParamName": "modify_hba_params",
                "ParamNewValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"trust\"}]",
                "ParamOldValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"9.0.0.0\",\"mask\":\"24\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"::\",\"mask\":\"0\",\"method\":\"md5\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"md5\"}]",
                "Status": "success",
                "UpdatedAt": "2025-02-27T16:39:47+08:00"
            },
            {
                "CreatedAt": "2025-02-27T16:37:32+08:00",
                "Id": 4566,
                "InstanceId": "cdwpg-9jcyk7yp",
                "NodeType": "cn",
                "ParamName": "max_connections",
                "ParamNewValue": "626",
                "ParamOldValue": "625",
                "Status": "success",
                "UpdatedAt": "2025-02-27T16:37:59+08:00"
            },
            {
                "CreatedAt": "2025-02-26T18:03:03+08:00",
                "Id": 4565,
                "InstanceId": "cdwpg-9jcyk7yp",
                "NodeType": "cn",
                "ParamName": "modify_hba_params",
                "ParamNewValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"9.0.0.0\",\"mask\":\"24\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"::\",\"mask\":\"0\",\"method\":\"md5\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"md5\"}]",
                "ParamOldValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"9.0.0.0\",\"mask\":\"24\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"::\",\"mask\":\"0\",\"method\":\"md5\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"md5\"}]",
                "Status": "success",
                "UpdatedAt": "2025-02-26T18:03:31+08:00"
            },
            {
                "CreatedAt": "2025-02-26T18:01:33+08:00",
                "Id": 4564,
                "InstanceId": "cdwpg-9jcyk7yp",
                "NodeType": "cn",
                "ParamName": "modify_hba_params",
                "ParamNewValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"9.0.0.0\",\"mask\":\"24\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"::\",\"mask\":\"0\",\"method\":\"md5\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"md5\"}]",
                "ParamOldValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"::\",\"mask\":\"0\",\"method\":\"md5\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"md5\"}]",
                "Status": "success",
                "UpdatedAt": "2025-02-26T18:02:01+08:00"
            },
            {
                "CreatedAt": "2025-02-26T17:59:57+08:00",
                "Id": 4563,
                "InstanceId": "cdwpg-9jcyk7yp",
                "NodeType": "cn",
                "ParamName": "modify_hba_params",
                "ParamNewValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"md5\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"::\",\"mask\":\"0\",\"method\":\"md5\"}]",
                "ParamOldValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"::\",\"mask\":\"0\",\"method\":\"md5\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"md5\"}]",
                "Status": "success",
                "UpdatedAt": "2025-02-26T18:00:25+08:00"
            },
            {
                "CreatedAt": "2025-02-26T17:55:50+08:00",
                "Id": 4562,
                "InstanceId": "cdwpg-9jcyk7yp",
                "NodeType": "cn",
                "ParamName": "modify_hba_params",
                "ParamNewValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"trust\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"md5\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"::\",\"mask\":\"0\",\"method\":\"md5\"}]",
                "ParamOldValue": "[{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"0.0.0.0\",\"mask\":\"0\",\"method\":\"md5\"},{\"type\":\"host\",\"database\":\"all\",\"user\":\"all\",\"address\":\"::0\",\"mask\":\"0\",\"method\":\"md5\"}]",
                "Status": "success",
                "UpdatedAt": "2025-02-26T17:56:16+08:00"
            }
        ],
        "RequestId": "3c291e0a-f7b3-4965-86d3-c606bb0c703d",
        "TotalCount": 10
    }
}

5. 开发者资源

腾讯云 API 平台

腾讯云 API 平台 是综合 API 文档、错误码、API Explorer 及 SDK 等资源的统一查询平台，方便您从同一入口查询及使用腾讯云提供的所有 API 服务。

API Inspector

用户可通过 API Inspector 查看控制台每一步操作关联的 API 调用情况，并自动生成各语言版本的 API 代码，也可前往 API Explorer 进行在线调试。

SDK

云 API 3.0 提供了配套的开发工具集（SDK），支持多种编程语言，能更方便的调用 API。

命令行工具

6. 错误码

该接口暂无业务逻辑相关的错误码，其他错误码详见 公共错误码。

中国站
目录