Class MySqlSqlStats

MySql Sql Stats type object.

Inheritance

object

MySqlSqlStats

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.OpsiService.Models

Assembly: OCI.DotNetSDK.Opsi.dll

Syntax

public class MySqlSqlStats

Properties

CommandType

Declaration

[JsonProperty(PropertyName = "commandType")]
public string CommandType { get; set; }

Property Value

Type	Description
string	Type of statement such as select, update or delete.

CpuLatencyInPs

Declaration

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

Property Value

Type	Description
long?	The total time spent on CPU (in picoseconds) for the current thread.

Digest

Declaration

[Required(ErrorMessage = "Digest is required.")]
[JsonProperty(PropertyName = "digest")]
public string Digest { get; set; }

Property Value

Type	Description
string	Unique SQL ID Digest for a MySql Statement. Example: "c20fcea11911be36651b7ca7bd3712d4ed9ac1134cee9c6620039e1fb13b5eff"

Remarks

Required

ErrCount

Declaration

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

Property Value

Type	Description
long?	The total number of errors produced by occurrences of the statement.

ExecCount

Declaration

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

Property Value

Type	Description
long?	The total number of times the statement has executed.

ExecCountSecondary

Declaration

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

Property Value

Type	Description
long?	The total number of times a query was processed on the secondary engine (HEATWAVE) for occurrences of this statement Count.

LockLatencyInPs

Declaration

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

Property Value

Type	Description
long?	The total time waiting (in picoseconds) for locks by timed occurrences of the statement.

MaxControlledMemoryInBytes

Declaration

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

Property Value

Type	Description
long?	The maximum amount of controlled memory (in bytes) used by the statement.

MaxTotalMemoryInBytes

Declaration

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

Property Value

Type	Description
long?	The maximum amount of memory (in bytes) used by the statement.

NoGoodIndexUsedCount

Declaration

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

Property Value

Type	Description
long?	The number of occurences of the statement where the server found no good index to use Count

NoIndexUsedCount

Declaration

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

Property Value

Type	Description
long?	The number of occurences of the statement which performed a table scan without using an index Count

PerfSchemaUsedPercent

Declaration

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

Property Value

Type	Description
long?	Percent of SQL statements in the perf schema table relative to max or overflow count set in @@GLOBAL.performance_schema_digests_size.

RowsAffected

Declaration

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

Property Value

Type	Description
long?	The total number of rows affected by occurrences of the statement.

RowsExamined

Declaration

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

Property Value

Type	Description
long?	The total number of rows read from storage engines by occurrences of the statement.

RowsSent

Declaration

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

Property Value

Type	Description
long?	The total number of rows returned by occurrences of the statement.

RowsSorted

Declaration

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

Property Value

Type	Description
long?	The total number of rows sorted by occurrences of the statement.

SchemaName

Declaration

[JsonProperty(PropertyName = "schemaName")]
public string SchemaName { get; set; }

Property Value

Type	Description
string	Name of Database Schema. Example: "performance_schema"

SelectFullJoin

Declaration

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

Property Value

Type	Description
long?	The total number of joins that perform table scans because they do not use indexes by occurrences of the statement. If this value is not 0

SelectFullRangeJoin

Declaration

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

Property Value

Type	Description
long?	The total number of joins that used a range search on a reference table by occurrences of the statement

SelectRange

Declaration

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

Property Value

Type	Description
long?	The total number of joins that used ranges on the first table by occurrences of the statement. This is normally not a critical issue even if the value is quite large. Count

SelectRangeCheck

Declaration

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

Property Value

Type	Description
long?	The total number of joins without keys that check for key usage after each row by occurrences of the statement. If this is not 0

SelectScan

Declaration

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

Property Value

Type	Description
long?	The total number of joins that did a full scan of the first table by occurrences of the statement Count

SortMergePasses

Declaration

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

Property Value

Type	Description
long?	The total number of sort merge passes by occurrences of the statement.

SortRange

Declaration

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

Property Value

Type	Description
long?	The total number of sorts that were done using ranges by occurrences of the statement.

SortScan

Declaration

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

Property Value

Type	Description
long?	The total number of sorts that were done by scanning the table by occurrences of the statement.

TimeCollected

Declaration

[Required(ErrorMessage = "TimeCollected is required.")]
[JsonProperty(PropertyName = "timeCollected")]
public DateTime? TimeCollected { get; set; }

Property Value

Type	Description
DateTime?	Collection timestamp. Example: "2020-03-31T00:00:00.000Z"

Remarks

Required

TimeFirstSeen

Declaration

[JsonProperty(PropertyName = "timeFirstSeen")]
public DateTime? TimeFirstSeen { get; set; }

Property Value

Type	Description
DateTime?	The time at which statement was first seen. Example: "2023-01-16 08:04:31.533577"

TimeLastSeen

Declaration

[JsonProperty(PropertyName = "timeLastSeen")]
public DateTime? TimeLastSeen { get; set; }

Property Value

Type	Description
DateTime?	The time at which statement was most recently seen for all occurrences of the statement. Example: "2023-01-30 02:17:08.067961"

TmpDiskTables

Declaration

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

Property Value

Type	Description
long?	The total number of internal on-disk temporary tables created by occurrences of the statement.

TmpTables

Declaration

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

Property Value

Type	Description
long?	The total number of internal in-memory temporary tables created by occurrences of the statement Count

TotalLatencyInPs

Declaration

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

Property Value

Type	Description
long?	The total wait time (in picoseconds) of timed occurrences of the statement.

TotalRows

Declaration

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

Property Value

Type	Description
long?	Total number of SQL statements used in collection ranking calculation.

WarnCount

Declaration

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

Property Value

Type	Description
long?	The total number of warnings produced by occurrences of the statement.