tencent cloud

TencentDB for DBbrain

Release Notes and Announcements
Release Notes
Announcements
Product Introduction
Overview
Features
Strengths
Use Cases
Feature List
Region List
Purchase Guide
Operation Guide
Cloud Access Management
Self-Built Database Access
Instance Overview
Instance Management
Monitoring and Alarms
Health Report and Kill Session Report Management
MySQL/TDSQL-C for MySQL Performance Optimization
TDSQL for MySQL/MariaDB Performance Optimization
Distributed cache database (Distributed Cache) diagnostic optimization
MongoDB Performance Optimization
Full-Link Analysis
Practical Tutorial
Fixing High CPU Utilization on MySQL Instance
Fixing Lock Conflict on MySQL Instance
How to Address High CPU Utilization Issues in Distributed Cache Instances
Fixing High CPU Utilization in MongoDB Instance
Fixing Short Node Oplog Retention Period in MongoDB Instance
API Documentation
History
Introduction
Introduction
API Category
Making API Requests
Session Killing APIs
Exception Detection APIs
Other APIs
Redis related APIs
Health Report Email Sending APIs
Space Analysis APIs
Slow Log Analysis APIs
Security Audit APIs
Database Audit APIs
Data Types
Error Codes
DBbrain APIs 2019-10-16
FAQs
Self-Built Database Issues
MySQL Performance
Product
Service Level Agreement
Glossary
Contact Us
DokumentasiTencentDB for DBbrainAPI DocumentationDBbrain APIs 2019-10-16Data Types

Data Types

PDF
Mode fokus
Ukuran font
Terakhir diperbarui: 2025-10-24 14:50:29

ContactItem

Contact description.

Used by actions: DescribeAllUserContact.

Name Type Description
Id Integer Contact ID.
Name String Contact name.
Mail String The email address of the contact.

DiagHistoryEventItem

Instance diagnosis event

Used by actions: DescribeDBDiagHistory.

Name Type Description
DiagType String Diagnosis type.
EndTime Timestamp End time.
StartTime Timestamp Start time.
EventId Integer Event ID.
Severity Integer Severity, which can be divided into 5 levels: 1: fatal, 2: severe, 3: warning, 4: notice, 5: healthy.
Outline String Summary.
DiagItem String Diagnosis item.
InstanceId String Instance ID.
Note: this field may return null, indicating that no valid values can be obtained.
Metric String Reserved field
Note: this field may return null, indicating that no valid values can be obtained.
Region String Region
Note: this field may return null, indicating that no valid values can be obtained.

EventInfo

Exception information

Used by actions: DescribeHealthScore.

Name Type Description
EventId Integer Event ID
DiagType String Diagnosis type
StartTime Timestamp ISO8601 Start time
EndTime Timestamp ISO8601 End time
Outline String Summary
Severity Integer Severity, which can be divided into 5 levels: 1: fatal, 2: severe, 3: warning, 4: notice, 5: healthy.
ScoreLost Integer Deduction
Metric String Reserved field
Count Integer The number of alarms

GroupItem

Describe the group information.

Used by actions: DescribeAllUserGroup.

Name Type Description
Id Integer Group ID.
Name String Group name.
MemberCount Integer Number of group members.

HealthReportTask

Details of health report tasks.

Used by actions: DescribeDBDiagReportTasks.

Name Type Description
AsyncRequestId Integer Async task request ID.
Source String Source that triggers the task. Valid values: DAILY_INSPECTION (instance inspection), SCHEDULED (timed generation), and MANUAL (manual trigger).
Progress Integer Task progress in %.
CreateTime Timestamp Task creation time.
StartTime Timestamp Task start time.
EndTime Timestamp Task end time.
InstanceInfo InstanceBasicInfo Basic information about the instance to which the task belongs.
HealthStatus HealthStatus Health information in a health report.

HealthScoreInfo

Obtain the details of the health score and deduction.

Used by actions: DescribeHealthScore.

Name Type Description
IssueTypes Array of IssueTypeInfo Exception details
EventsTotalCount Integer Total number of the exceptions
HealthScore Integer Health score
HealthLevel String Health level, such as "HEALTH", "SUB_HEALTH", "RISK", "HIGH_RISK".

HealthStatus

Instance health status.

Used by actions: DescribeDBDiagReportTasks.

Name Type Description
HealthScore Integer Health score out of 100 points.
HealthLevel String Health level. Valid values: HEALTH (healthy), SUB_HEALTH (suboptimal), RISK (risky), and HIGH_RISK (critical).
ScoreLost Integer Total scores deducted.
ScoreDetails Array of ScoreDetail Deduction details.
Note: null may be returned for this field, indicating that no valid values can be obtained.

InstanceBasicInfo

Basic information of instance.

Used by actions: DescribeDBDiagReportTasks.

Name Type Description
InstanceId String Instance ID.
InstanceName String Instance name.
Vip String Private IP of the instance.
Vport Integer Private network port of the instance.
Product String Instance product.
EngineVersion String Instance engine version.

InstanceConfs

Instance configuration.

Used by actions: DescribeDiagDBInstances, ModifyDiagDBInstanceConf.

Name Type Required Description
DailyInspection String No Whether to enable database inspection. Valid values: Yes/No.
OverviewDisplay String No Whether to enable instance overview. Valid values: Yes/No.

InstanceInfo

Query the list of instances and return information about the instances.

Used by actions: DescribeDiagDBInstances.

Name Type Description
InstanceId String Instance ID
InstanceName String Instance name
Region String The region where the instance belongs
HealthScore Integer Health score
Product String Service
EventCount Integer Number of exceptions
InstanceType Integer Instance type. Valid values: 1: MASTER, 2: DR, 3: RO, 4: SDR
Cpu Integer Number of cores
Memory Integer Memory in MB
Volume Integer Disk storage in GB
EngineVersion String Database version
Vip String Private network address
Vport Integer Private network port
Source String Access source
GroupId String Group ID
GroupName String Group name
Status Integer Instance status. Valid values: 0: Delivering, 1: Running, 4: Terminating, 5: Isolated
UniqSubnetId String Subnet unified ID
DeployMode String cdb (TencentDB instance) type
InitFlag Integer cdb (TencentDB instance) initialization flag. Valid values: 0: not initialized, 1: initialized
TaskStatus Integer Task status
UniqVpcId String Unified VPC ID
InstanceConf InstanceConfs Instance inspection/overview status
DeadlineTime Timestamp Resource expiration time
IsSupported Boolean Whether it is an instance supported by DBbrain.
SecAuditStatus String The status of instance security audit log. ON: enabled, OFF: disabled.
AuditPolicyStatus String The status of instance audit log. ALL_AUDIT: full audit is enabled, RULE_AUDIT: rule audit is enabled, UNBOUND: audit is disabled.
AuditRunningStatus String The running status of instance audit log. normal: running, paused: suspension due to arrears

IssueTypeInfo

Metric information

Used by actions: DescribeHealthScore.

Name Type Description
IssueType String Metric categories: AVAILABILITY, MAINTAINABILITY, PERFORMANCE, and RELIABILITY
Events Array of EventInfo Exception
TotalCount Integer Total number of the exceptions

MailConfiguration

Email sending configuration.

Used by actions: CreateMailProfile, CreateSchedulerMailProfile.

Name Type Required Description
SendMail Integer Yes Whether to enable email sending. Valid values: 0 (No), 1 (Yes).
Region Array of String Yes Region configuration, such as "ap-guangzhou", "ap-shanghai". For the inspection email sending template, configure the region where you need to send the inspection email. For the subscription email sending template, configure the region to which the current subscribed instance belongs.
HealthStatus Array of String Yes Sending a report with the specified health level, such as "HEALTH", "SUB_HEALTH", "RISK", "HIGH_RISK".
ContactPerson Array of Integer No Contact ID. Either ContactGroup or ContactID should be passed in.
ContactGroup Array of Integer No Contact group ID. Either ContactGroup or ContactID should be passed in.

MonitorFloatMetric

Monitoring data in float type

Used by actions: DescribeTopSpaceTableTimeSeries.

Name Type Description
Metric String Metric name.
Unit String Metric unit.
Values Array of Float Metric value.
Note: this field may return null, indicating that no valid values can be obtained.

MonitorFloatMetricSeriesData

Monitoring metric value in float type in a unit of time interval

Used by actions: DescribeTopSpaceTableTimeSeries.

Name Type Description
Series Array of MonitorFloatMetric Monitoring metric.
Timestamp Array of Integer Timestamp corresponding to monitoring metric.

MonitorMetric

Monitoring data

Used by actions: DescribeSlowLogTimeSeriesStats, DescribeTopSpaceSchemaTimeSeries.

Name Type Description
Metric String Metric name.
Unit String Metric unit.
Values Array of Integer Metric value.
Note: this field may return null, indicating that no valid values can be obtained.

MonitorMetricSeriesData

Monitoring metric data in specified time range

Used by actions: DescribeSlowLogTimeSeriesStats, DescribeTopSpaceSchemaTimeSeries.

Name Type Description
Series Array of MonitorMetric Monitoring metric.
Timestamp Array of Integer Timestamp corresponding to monitoring metric.

ProfileInfo

Information configured by user.

Used by actions: CreateMailProfile, CreateSchedulerMailProfile, DescribeMailProfile.

Name Type Required Description
Language String Yes Language of the email, such as en.
MailConfiguration MailConfiguration Yes The content of email template.

SchemaItem

SchemaItem array

Used by actions: DescribeSlowLogTopSqls.

Name Type Required Description
Schema String Yes Database name

SchemaSpaceData

Database space statistics.

Used by actions: DescribeTopSpaceSchemas.

Name Type Description
TableSchema String Database name.
DataLength Float Data space in MB.
IndexLength Float Index space in MB.
DataFree Float Fragmented space in MB.
TotalLength Float Total space usage in MB.
FragRatio Float Fragmented rate (%).
TableRows Integer Number of rows.
PhysicalFileSize Float The total size of the independent physical files corresponding to all the database tables (MB).
Note: null may be returned for this field, indicating that no valid values can be obtained.

SchemaSpaceTimeSeries

Time series of database space data

Used by actions: DescribeTopSpaceSchemaTimeSeries.

Name Type Description
TableSchema String Database name
SeriesData MonitorMetricSeriesData Monitoring metric data in a unit of time interval.

ScoreDetail

Deduction details.

Used by actions: DescribeDBDiagReportTasks.

Name Type Description
IssueType String Deduction item types. Valid values: availability, maintainability, performance, and reliability.
ScoreLost Integer Total scores deducted.
ScoreLostMax Integer Upper limit of the deducted scores.
Items Array of ScoreItem Deduction item list.
Note: null may be returned for this field, indicating that no valid values can be obtained.

ScoreItem

Diagnosis deduction item.

Used by actions: DescribeDBDiagReportTasks.

Name Type Description
DiagItem String Exception diagnosis item name.
IssueType String Diagnosis item types. Valid values: availability, maintainability, performance, and reliability.
TopSeverity String Health level. Valid values: information, reminder, alarm, serious, fatal.
Count Integer Number of occurrences of this exception diagnosis item.
ScoreLost Integer Scores deducted.

SlowLogHost

Details of slow log source addresses.

Used by actions: DescribeSlowLogUserHostStats.

Name Type Description
UserHost String Source addresses.
Ratio Float The proportion (in %) of slow logs from this source address to the total number of slow logs
Count Integer Number of slow logs from this source address.

SlowLogTopSqlItem

Top slow SQL statements

Used by actions: DescribeSlowLogTopSqls.

Name Type Description
LockTime Float Total SQL lock wait time
LockTimeMax Float Maximum lock wait time
LockTimeMin Float Minimum lock wait time
RowsExamined Integer Total number of scanned rows
RowsExaminedMax Integer Maximum number of scanned rows
RowsExaminedMin Integer Minimum number of scanned rows
QueryTime Float Total duration
QueryTimeMax Float Maximum execution time
QueryTimeMin Float Minimum execution time
RowsSent Integer Total number of returned rows
RowsSentMax Integer Maximum number of returned rows
RowsSentMin Integer Minimum number of returned rows
ExecTimes Integer Number of executions
SqlTemplate String SQL template
SqlText String SQL with parameter (random)
Schema String Database name
QueryTimeRatio Float Ratio of total duration
LockTimeRatio Float Ratio of total SQL lock wait time
RowsExaminedRatio Float Ratio of total number of scanned rows
RowsSentRatio Float Ratio of total number of returned rows
QueryTimeAvg Float Average execution time
RowsSentAvg Float Average number of rows returned
LockTimeAvg Float Average lock wait time
RowsExaminedAvg Float Average number of rows scanned

TableSpaceData

Database table space statistics.

Used by actions: DescribeTopSpaceTables.

Name Type Description
TableName String Table name.
TableSchema String Database name.
Engine String Database table storage engine.
DataLength Float Data space in MB.
IndexLength Float Index space in MB.
DataFree Float Fragmented space in MB.
TotalLength Float Total space usage in MB.
FragRatio Float Fragmented rate (%).
TableRows Integer Number of rows.
PhysicalFileSize Float Size in MB of the physical file exclusive to a table.

TableSpaceTimeSeries

Time series of database table space data

Used by actions: DescribeTopSpaceTableTimeSeries.

Name Type Description
TableName String Table name.
TableSchema String Database name.
Engine String Database table storage engine.
SeriesData MonitorFloatMetricSeriesData Monitoring metric data in a unit of time interval.

TimeSlice

Slow log statistics in specified time range

Used by actions: DescribeSlowLogTimeSeriesStats.

Name Type Description
Count Integer Total number
Timestamp Integer Statistics start time

UserProfile

Information configured by user, including email configuration.

Used by actions: DescribeMailProfile.

Name Type Description
ProfileId String Configured ID
Note: this field may return null, indicating that no valid values can be obtained.
ProfileType String Configuration type
Note: this field may return null, indicating that no valid values can be obtained.
ProfileLevel String Configuration level. Valid values: “User” or “Instance”
Note: this field may return null, indicating that no valid values can be obtained.
ProfileName String Configuration name
Note: this field may return null, indicating that no valid values can be obtained.
ProfileInfo ProfileInfo Configuration details
Topik sebelumnya: CreateDBDiagReportUrlTopik selanjutnya: Error Codes

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan