Class MySqlDataSummary
The SQL performance data record for a specific SQL query.
Inherited Members
Namespace: Oci.DatabasemanagementService.Models
Assembly: OCI.DotNetSDK.Databasemanagement.dll
Syntax
public class MySqlDataSummary
Properties
AvgTimerWait
Declaration
[Required(ErrorMessage = "AvgTimerWait is required.")]
[JsonProperty(PropertyName = "avgTimerWait")]
public decimal? AvgTimerWait { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The average execution time. |
Remarks
Required
CountStar
Declaration
[Required(ErrorMessage = "CountStar is required.")]
[JsonProperty(PropertyName = "countStar")]
public decimal? CountStar { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The number Of times the query has been executed. |
Remarks
Required
Digest
Declaration
[Required(ErrorMessage = "Digest is required.")]
[JsonProperty(PropertyName = "digest")]
public string Digest { get; set; }
Property Value
Type | Description |
---|---|
string | The digest information of the normalized query. |
Remarks
Required
DigestText
Declaration
[Required(ErrorMessage = "DigestText is required.")]
[JsonProperty(PropertyName = "digestText")]
public string DigestText { get; set; }
Property Value
Type | Description |
---|---|
string | The normalized query. |
Remarks
Required
FirstSeen
Declaration
[Required(ErrorMessage = "FirstSeen is required.")]
[JsonProperty(PropertyName = "firstSeen")]
public DateTime? FirstSeen { get; set; }
Property Value
Type | Description |
---|---|
DateTime? | The date and time the query was first seen. If the table is truncated, the first seen value is reset. |
Remarks
Required
HeatWaveOffloaded
Declaration
[JsonProperty(PropertyName = "heatWaveOffloaded")]
public decimal? HeatWaveOffloaded { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The number of query executions offloaded to HeatWave. |
HeatWaveOutOfMemory
Declaration
[JsonProperty(PropertyName = "heatWaveOutOfMemory")]
public decimal? HeatWaveOutOfMemory { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The number of query executions with HeatWave out-of-memory errors. |
LastSeen
Declaration
[Required(ErrorMessage = "LastSeen is required.")]
[JsonProperty(PropertyName = "lastSeen")]
public DateTime? LastSeen { get; set; }
Property Value
Type | Description |
---|---|
DateTime? | The date and time the query was last seen. |
Remarks
Required
MaxTimerWait
Declaration
[Required(ErrorMessage = "MaxTimerWait is required.")]
[JsonProperty(PropertyName = "maxTimerWait")]
public decimal? MaxTimerWait { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The slowest the query has been executed. |
Remarks
Required
MinTimerWait
Declaration
[Required(ErrorMessage = "MinTimerWait is required.")]
[JsonProperty(PropertyName = "minTimerWait")]
public decimal? MinTimerWait { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The fastest the query has been executed. |
Remarks
Required
Quantile95
Declaration
[Required(ErrorMessage = "Quantile95 is required.")]
[JsonProperty(PropertyName = "quantile95")]
public decimal? Quantile95 { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time. |
Remarks
Required
Quantile99
Declaration
[Required(ErrorMessage = "Quantile99 is required.")]
[JsonProperty(PropertyName = "quantile99")]
public decimal? Quantile99 { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The 99th percentile of the query latency. |
Remarks
Required
Quantile999
Declaration
[Required(ErrorMessage = "Quantile999 is required.")]
[JsonProperty(PropertyName = "quantile999")]
public decimal? Quantile999 { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The 99.9th percentile of the query latency. |
Remarks
Required
SchemaName
Declaration
[Required(ErrorMessage = "SchemaName is required.")]
[JsonProperty(PropertyName = "schemaName")]
public string SchemaName { get; set; }
Property Value
Type | Description |
---|---|
string | The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL. |
Remarks
Required
SumCreatedTempDiskTables
Declaration
[Required(ErrorMessage = "SumCreatedTempDiskTables is required.")]
[JsonProperty(PropertyName = "sumCreatedTempDiskTables")]
public decimal? SumCreatedTempDiskTables { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of On-Disk internal temporary tables that have been created by the query. |
Remarks
Required
SumCreatedTempTables
Declaration
[Required(ErrorMessage = "SumCreatedTempTables is required.")]
[JsonProperty(PropertyName = "sumCreatedTempTables")]
public decimal? SumCreatedTempTables { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of internal temporary tables (in memory or on disk), which have been created by the query. |
Remarks
Required
SumErrors
Declaration
[Required(ErrorMessage = "SumErrors is required.")]
[JsonProperty(PropertyName = "sumErrors")]
public decimal? SumErrors { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of errors that have been encountered executing the query. |
Remarks
Required
SumLockTime
Declaration
[Required(ErrorMessage = "SumLockTime is required.")]
[JsonProperty(PropertyName = "sumLockTime")]
public decimal? SumLockTime { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total amount of time that has been spent waiting for table locks. |
Remarks
Required
SumNoGoodIndexUsed
Declaration
[Required(ErrorMessage = "SumNoGoodIndexUsed is required.")]
[JsonProperty(PropertyName = "sumNoGoodIndexUsed")]
public decimal? SumNoGoodIndexUsed { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes \u201CRange Checked For Each Record.\u201D |
Remarks
Required
SumNoIndexUsed
Declaration
[Required(ErrorMessage = "SumNoIndexUsed is required.")]
[JsonProperty(PropertyName = "sumNoIndexUsed")]
public decimal? SumNoIndexUsed { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of times no index was used to execute the query. |
Remarks
Required
SumRowsAffected
Declaration
[Required(ErrorMessage = "SumRowsAffected is required.")]
[JsonProperty(PropertyName = "sumRowsAffected")]
public decimal? SumRowsAffected { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of rows that have been modified by the query. |
Remarks
Required
SumRowsExamined
Declaration
[Required(ErrorMessage = "SumRowsExamined is required.")]
[JsonProperty(PropertyName = "sumRowsExamined")]
public decimal? SumRowsExamined { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of rows that have been examined by the query. |
Remarks
Required
SumRowsSent
Declaration
[Required(ErrorMessage = "SumRowsSent is required.")]
[JsonProperty(PropertyName = "sumRowsSent")]
public decimal? SumRowsSent { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of rows that have been returned (sent) to the client. |
Remarks
Required
SumSelectFullJoin
Declaration
[Required(ErrorMessage = "SumSelectFullJoin is required.")]
[JsonProperty(PropertyName = "sumSelectFullJoin")]
public decimal? SumSelectFullJoin { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of joins that have performed full table scans as there was no join condition or no index for the join condition. This is the same as the select_full_join status variable. |
Remarks
Required
SumSelectFullRangeJoin
Declaration
[Required(ErrorMessage = "SumSelectFullRangeJoin is required.")]
[JsonProperty(PropertyName = "sumSelectFullRangeJoin")]
public decimal? SumSelectFullRangeJoin { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of joins that use a full range search. This is the same as the select_full_range_join status variable. |
Remarks
Required
SumSelectRange
Declaration
[Required(ErrorMessage = "SumSelectRange is required.")]
[JsonProperty(PropertyName = "sumSelectRange")]
public decimal? SumSelectRange { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of times the query has used a range search. This is the same as the select_range status variable. |
Remarks
Required
SumSelectRangeCheck
Declaration
[Required(ErrorMessage = "SumSelectRangeCheck is required.")]
[JsonProperty(PropertyName = "sumSelectRangeCheck")]
public decimal? SumSelectRangeCheck { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of joins by the query where the join does not have an index that checks for the index usage after each row. This is the same as the select_range_check status variable. |
Remarks
Required
SumSelectScan
Declaration
[Required(ErrorMessage = "SumSelectScan is required.")]
[JsonProperty(PropertyName = "sumSelectScan")]
public decimal? SumSelectScan { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of times the query has performed a full table scan on the first table in the join. This is the same as the select_scan status variable. |
Remarks
Required
SumSortMergePasses
Declaration
[Required(ErrorMessage = "SumSortMergePasses is required.")]
[JsonProperty(PropertyName = "sumSortMergePasses")]
public decimal? SumSortMergePasses { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of sort merge passes that have been done to sort the result of the query. This is the same as the sort_merge_passes status variable. |
Remarks
Required
SumSortRange
Declaration
[Required(ErrorMessage = "SumSortRange is required.")]
[JsonProperty(PropertyName = "sumSortRange")]
public decimal? SumSortRange { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of times a sort was done using ranges. This is the same as the sort_range status variable. |
Remarks
Required
SumSortRows
Declaration
[Required(ErrorMessage = "SumSortRows is required.")]
[JsonProperty(PropertyName = "sumSortRows")]
public decimal? SumSortRows { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of rows sorted. This is the same as the sort_rowsStatus variable. |
Remarks
Required
SumSortScan
Declaration
[Required(ErrorMessage = "SumSortScan is required.")]
[JsonProperty(PropertyName = "sumSortScan")]
public decimal? SumSortScan { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable. |
Remarks
Required
SumTimerWait
Declaration
[Required(ErrorMessage = "SumTimerWait is required.")]
[JsonProperty(PropertyName = "sumTimerWait")]
public decimal? SumTimerWait { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total amount of time that has been spent executing the query. |
Remarks
Required
SumWarnings
Declaration
[Required(ErrorMessage = "SumWarnings is required.")]
[JsonProperty(PropertyName = "sumWarnings")]
public decimal? SumWarnings { get; set; }
Property Value
Type | Description |
---|---|
decimal? | The total number of warnings that have been encountered executing the query. |
Remarks
Required