数据库智能管家 DBbrain 查询健康诊断报告内容

1. 接口描述

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

健康报告内容。

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

推荐使用 API Explorer

点击调试

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

2. 输入参数

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

参数名称	必选	类型	描述
Action	是	String	公共参数，本接口取值：DescribeDBDiagReportContent。
Version	是	String	公共参数，本接口取值：2021-05-27。
Region	是	String	公共参数，详见产品支持的地域列表。
InstanceId	是	String	实例名示例值：cdb-c1nl9rpv
AsyncRequestId	是	Integer	异步任务ID 示例值：59
Product	否	String	服务产品类型，支持值："mysql" - 云数据库 MySQL，"redis" - 云数据库 Redis，"mongodb" - 云数据库 MongoDB，默认为"mysql"。示例值：mysql

3. 输出参数

参数名称	类型	描述
Report	String	报告内容。示例值：{"ReportBasicInfo":{"UserName":"数据库智能管家DBbrain","EndTime":"2025-04-24 23:59:00","StartTime":"2025-04-23 23:59:00"},"TopSpaceTables":{"Names":["TableSchema"],"Data":[{"TableName":"stk_order_36"}]}}
RequestId	String	唯一请求 ID，由服务端生成，每次请求都会返回（若请求因其他原因未能抵达服务端，则该次请求不会获得 RequestId）。定位问题时需要提供该次请求的 RequestId。

4. 示例

示例1 查询健康报告内容

输入示例

https://dbbrain.tencentcloudapi.com/?Action=DescribeDBDiagReportTasks
&Product=mysql
&AsyncRequestId=1
&InstanceId=cdb-xxxxx
&<公共请求参数>

输出示例

{
    "Response": {
        "Report": "{\"DiagEvents\":[],\"RiskAccounts\":null,\"PerfDataBrief\":[{\"Status\":\"IDLE\",\"Min\":1,\"Avg\":5.32,\"Max\":43,\"RecMin\":800,\"FlavorMax\":1200,\"Metric\":\"queries\",\"Unit\":\"次/秒\",\"RecMax\":1000},{\"Status\":\"IDLE\",\"Min\":0.1,\"Avg\":0.25,\"Max\":0.75,\"RecMin\":20,\"FlavorMax\":100,\"Metric\":\"cpu_use_rate\",\"Unit\":\"%\",\"RecMax\":60},{\"Status\":\"IDLE\",\"Min\":4,\"Avg\":5.76,\"Max\":7,\"RecMin\":400,\"FlavorMax\":1200,\"Metric\":\"threads_connected\",\"Unit\":\"个\",\"RecMax\":1000},{\"Status\":\"IDLE\",\"Min\":28.87,\"Avg\":29.01,\"Max\":29.26,\"RecMin\":60,\"FlavorMax\":100,\"Metric\":\"memory_use_rate\",\"Unit\":\"%\",\"RecMax\":80},{\"Status\":\"IDLE\",\"Min\":2.34,\"Avg\":2.34,\"Max\":2.34,\"RecMin\":20,\"FlavorMax\":100,\"Metric\":\"volume_rate\",\"Unit\":\"%\",\"RecMax\":80}],\"NoPrimaryKeyTables\":{},\"SourceType\":\"\",\"HealthStatus\":{},\"SlowLogTopSqls\":[],\"InstBasicInfo\":{\"CdbVersion\":\"8.0\",\"InternalVip\":\"\",\"DeviceTypeName\":\"通用型\",\"InstanceId\":\"cdb-xxxxx\",\"InternalVport\":0,\"Memory\":8000,\"Zone\":110001,\"Vport\":3306,\"Product\":\"MySQL\",\"Cpu\":4,\"InstanceName\":\"长稳CFT_2\",\"ZoneName\":\"深圳金融一区\",\"DeployMode\":\"CUSTOM\",\"Volume\":200,\"InstanceTypeName\":\"主实例\",\"Region\":\"深圳金融\",\"Vip\":\"172.23.32.5\"},\"PerfDataSeries\":[],\"ReportBasicInfo\":{\"UserName\":\"数据库智能管家DBbrain\",\"EndTime\":\"2025-04-10 00:00:00\",\"Language\":\"cn\",\"StartTime\":\"2025-04-09 00:00:00\"},\"TopSpaceTables\":{\"Names\":[\"TableSchema\",\"TableName\",\"Engine\",\"DataFree\",\"DataLength\",\"IndexLength\",\"TotalLength\",\"FragRatio\",\"TableRows\",\"PhysicalFileSize\"],\"Data\":[{\"DataFree\":0,\"TableName\":\"stk_order_36\",\"TotalLength\":0,\"TableSchema\":\"newdts\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":0,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.2},{\"DataFree\":0,\"TableName\":\"cuacct_1\",\"TotalLength\":0,\"TableSchema\":\"newdts\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":0,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.2},{\"DataFree\":0,\"TableName\":\"cubsb_log\",\"TotalLength\":0,\"TableSchema\":\"newdts\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":0,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.2},{\"DataFree\":0,\"TableName\":\"fund_dispatch_log\",\"TotalLength\":0,\"TableSchema\":\"newdts\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":0,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.2},{\"DataFree\":0,\"TableName\":\"eg_sync-3dlgfz9a\",\"TotalLength\":0,\"TableSchema\":\"__tencentdb__\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":0,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"aa\\\\na\",\"TotalLength\":0,\"TableSchema\":\"newdts\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":0,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"special_column_test14\",\"TotalLength\":0,\"TableSchema\":\"newdts\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":0,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"t125_btree_desc\",\"TotalLength\":0,\"TableSchema\":\"full_syntax\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":1,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"gtid_executed\",\"TotalLength\":0,\"TableSchema\":\"__tencentdb__\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":2,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"all_kinds_of_fields\",\"TotalLength\":0,\"TableSchema\":\"newdts\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":2,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"special_column_test15\",\"TotalLength\":0,\"TableSchema\":\"newdts\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":0,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"t125_hash\",\"TotalLength\":0,\"TableSchema\":\"full_syntax\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":1,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"heartbeat_sync-3dlgfz9a\",\"TotalLength\":0,\"TableSchema\":\"__tencentdb__\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":1,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"all_kinds_of_fields_0\",\"TotalLength\":0,\"TableSchema\":\"newdts\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":2,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"special_column_test16\",\"TotalLength\":0,\"TableSchema\":\"newdts\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":0,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"t125_hash_desc\",\"TotalLength\":0,\"TableSchema\":\"full_syntax\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":0,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"identify\",\"TotalLength\":0,\"TableSchema\":\"__tencentdb__\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":0,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"all_kinds_of_fields_1\",\"TotalLength\":0,\"TableSchema\":\"newdts\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":5,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"special_column_test17\",\"TotalLength\":0,\"TableSchema\":\"newdts\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":0,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1},{\"DataFree\":0,\"TableName\":\"t126\",\"TotalLength\":0,\"TableSchema\":\"full_syntax\",\"FragRatio\":0,\"DataLength\":0,\"TableRows\":1,\"Engine\":\"InnoDB\",\"IndexLength\":0,\"PhysicalFileSize\":0.1}]}}",
        "RequestId": "46b24e25-ad04-4cb1-8739-fdcd37aaf238"
    }
}

5. 开发者资源

腾讯云 API 平台

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

API Inspector

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

SDK

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

Tencent Cloud SDK 3.0 for Python: GitHub, Gitee
Tencent Cloud SDK 3.0 for Java: GitHub, Gitee
Tencent Cloud SDK 3.0 for PHP: GitHub, Gitee
Tencent Cloud SDK 3.0 for Go: GitHub, Gitee
Tencent Cloud SDK 3.0 for Node.js: GitHub, Gitee
Tencent Cloud SDK 3.0 for .NET: GitHub, Gitee
Tencent Cloud SDK 3.0 for C++: GitHub, Gitee
Tencent Cloud SDK 3.0 for Ruby: GitHub, Gitee

命令行工具

Tencent Cloud CLI 3.0

6. 错误码

以下仅列出了接口业务逻辑相关的错误码，其他错误码详见公共错误码。

错误码	描述
AuthFailure	CAM签名/鉴权错误。
FailedOperation	操作失败。
InternalError	内部错误。
InvalidParameter	参数错误。
InvalidParameterValue	参数取值错误。
MissingParameter	缺少参数错误。
OperationDenied	操作被拒绝。
OperationDenied.UserHasNoStrategy	CAM鉴权错误。
RequestLimitExceeded	请求的次数超过了频率限制。
ResourceNotFound	资源不存在。
UnauthorizedOperation	未授权操作。
UnknownParameter	未知参数错误。

查询健康诊断报告内容

本页目录：