Documentation|Tencent Cloud

Last updated: 2020-07-31 10:12:56

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.

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.

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.

Monitoring data

Used by actions: DescribeSlowLogTimeSeriesStats.

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.

Monitoring metric data in specified time range

Used by actions: DescribeSlowLogTimeSeriesStats.

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

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	Schema
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

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.

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.