Data Types

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.

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.

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.

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

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

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

Was this page helpful?

Was this page helpful?

  • Not at all
  • Not very helpful
  • Somewhat helpful
  • Very helpful
  • Extremely helpful
Send Feedback
Help