Class MySqlDataSummary

The SQL performance data record for a specific SQL query.

Inheritance

object

MySqlDataSummary

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

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

MaxControlledMemory

Declaration

[JsonProperty(PropertyName = "maxControlledMemory")]
public long? MaxControlledMemory { get; set; }

Property Value

Type	Description
long?	The maximum amount of controlled memory used by a statement during execution.

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

MaxTotalMemory

Declaration

[JsonProperty(PropertyName = "maxTotalMemory")]
public long? MaxTotalMemory { get; set; }

Property Value

Type	Description
long?	The maximum amount of memory used by a statement during execution.

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

SumCpuTime

Declaration

[JsonProperty(PropertyName = "sumCpuTime")]
public long? SumCpuTime { get; set; }

Property Value

Type	Description
long?	The total amount of time spent on CPU for this statement.

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