@Generated(value="OracleSDKGenerator",
comments="API Version: 20200630")
public final class MySqlSqlStats
extends com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
MySql Sql Stats type object.
Note: Objects should always be created or deserialized using the MySqlSqlStats.Builder. This model
distinguishes fields that are null because they are unset from fields that are explicitly
set to null. This is done in the setter methods of the MySqlSqlStats.Builder, which maintain a
set of all explicitly set fields called MySqlSqlStats.Builder.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take the explicitly set
fields into account. The constructor, on the other hand, does not take the explicitly set fields
into account (since the constructor cannot distinguish explicit null from unset null).
| Modifier and Type | Class and Description |
|---|---|
static class |
MySqlSqlStats.Builder |
EXPLICITLY_SET_FILTER_NAME, EXPLICITLY_SET_PROPERTY_NAME| Constructor and Description |
|---|
MySqlSqlStats(String digest,
Date timeCollected,
String commandType,
Long totalRows,
Long perfSchemaUsedPercent,
String schemaName,
Long execCount,
Long totalLatencyInPs,
Long lockLatencyInPs,
Long errCount,
Long warnCount,
Long rowsAffected,
Long rowsSent,
Long rowsExamined,
Long tmpDiskTables,
Long tmpTables,
Long selectFullJoin,
Long selectFullRangeJoin,
Long selectRange,
Long selectRangeCheck,
Long selectScan,
Long sortMergePasses,
Long sortRange,
Long rowsSorted,
Long sortScan,
Long noIndexUsedCount,
Long noGoodIndexUsedCount,
Long cpuLatencyInPs,
Long maxControlledMemoryInBytes,
Long maxTotalMemoryInBytes,
Long execCountSecondary,
Date timeFirstSeen,
Date timeLastSeen)
Deprecated.
|
| Modifier and Type | Method and Description |
|---|---|
static MySqlSqlStats.Builder |
builder()
Create a new builder.
|
boolean |
equals(Object o) |
String |
getCommandType()
Type of statement such as select, update or delete.
|
Long |
getCpuLatencyInPs()
The total time spent on CPU (in picoseconds) for the current thread.
|
String |
getDigest()
Unique SQL ID Digest for a MySql Statement.
|
Long |
getErrCount()
The total number of errors produced by occurrences of the statement.
|
Long |
getExecCount()
The total number of times the statement has executed.
|
Long |
getExecCountSecondary()
The total number of times a query was processed on the secondary engine (HEATWAVE) for
occurrences of this statement Count.
|
Long |
getLockLatencyInPs()
The total time waiting (in picoseconds) for locks by timed occurrences of the statement.
|
Long |
getMaxControlledMemoryInBytes()
The maximum amount of controlled memory (in bytes) used by the statement.
|
Long |
getMaxTotalMemoryInBytes()
The maximum amount of memory (in bytes) used by the statement.
|
Long |
getNoGoodIndexUsedCount()
The number of occurences of the statement where the server found no good index to use Count
|
Long |
getNoIndexUsedCount()
The number of occurences of the statement which performed a table scan without using an index
Count
|
Long |
getPerfSchemaUsedPercent()
Percent of SQL statements in the perf schema table relative to max or overflow count set
in @@GLOBAL.performance_schema_digests_size.
|
Long |
getRowsAffected()
The total number of rows affected by occurrences of the statement.
|
Long |
getRowsExamined()
The total number of rows read from storage engines by occurrences of the statement.
|
Long |
getRowsSent()
The total number of rows returned by occurrences of the statement.
|
Long |
getRowsSorted()
The total number of rows sorted by occurrences of the statement.
|
String |
getSchemaName()
Name of Database Schema.
|
Long |
getSelectFullJoin()
The total number of joins that perform table scans because they do not use indexes by
occurrences of the statement.
|
Long |
getSelectFullRangeJoin()
The total number of joins that used a range search on a reference table by occurrences of the
statement
|
Long |
getSelectRange()
The total number of joins that used ranges on the first table by occurrences of the
statement.
|
Long |
getSelectRangeCheck()
The total number of joins without keys that check for key usage after each row by occurrences
of the statement.
|
Long |
getSelectScan()
The total number of joins that did a full scan of the first table by occurrences of the
statement Count
|
Long |
getSortMergePasses()
The total number of sort merge passes by occurrences of the statement.
|
Long |
getSortRange()
The total number of sorts that were done using ranges by occurrences of the statement.
|
Long |
getSortScan()
The total number of sorts that were done by scanning the table by occurrences of the
statement.
|
Date |
getTimeCollected()
Collection timestamp.
|
Date |
getTimeFirstSeen()
The time at which statement was first seen.
|
Date |
getTimeLastSeen()
The time at which statement was most recently seen for all occurrences of the statement.
|
Long |
getTmpDiskTables()
The total number of internal on-disk temporary tables created by occurrences of the
statement.
|
Long |
getTmpTables()
The total number of internal in-memory temporary tables created by occurrences of the
statement Count
|
Long |
getTotalLatencyInPs()
The total wait time (in picoseconds) of timed occurrences of the statement.
|
Long |
getTotalRows()
Total number of SQL statements used in collection ranking calculation.
|
Long |
getWarnCount()
The total number of warnings produced by occurrences of the statement.
|
int |
hashCode() |
MySqlSqlStats.Builder |
toBuilder() |
String |
toString() |
String |
toString(boolean includeByteArrayContents)
Return a string representation of the object.
|
markPropertyAsExplicitlySet, wasPropertyExplicitlySet@Deprecated @ConstructorProperties(value={"digest","timeCollected","commandType","totalRows","perfSchemaUsedPercent","schemaName","execCount","totalLatencyInPs","lockLatencyInPs","errCount","warnCount","rowsAffected","rowsSent","rowsExamined","tmpDiskTables","tmpTables","selectFullJoin","selectFullRangeJoin","selectRange","selectRangeCheck","selectScan","sortMergePasses","sortRange","rowsSorted","sortScan","noIndexUsedCount","noGoodIndexUsedCount","cpuLatencyInPs","maxControlledMemoryInBytes","maxTotalMemoryInBytes","execCountSecondary","timeFirstSeen","timeLastSeen"}) public MySqlSqlStats(String digest, Date timeCollected, String commandType, Long totalRows, Long perfSchemaUsedPercent, String schemaName, Long execCount, Long totalLatencyInPs, Long lockLatencyInPs, Long errCount, Long warnCount, Long rowsAffected, Long rowsSent, Long rowsExamined, Long tmpDiskTables, Long tmpTables, Long selectFullJoin, Long selectFullRangeJoin, Long selectRange, Long selectRangeCheck, Long selectScan, Long sortMergePasses, Long sortRange, Long rowsSorted, Long sortScan, Long noIndexUsedCount, Long noGoodIndexUsedCount, Long cpuLatencyInPs, Long maxControlledMemoryInBytes, Long maxTotalMemoryInBytes, Long execCountSecondary, Date timeFirstSeen, Date timeLastSeen)
public static MySqlSqlStats.Builder builder()
Create a new builder.
public MySqlSqlStats.Builder toBuilder()
public String getDigest()
Unique SQL ID Digest for a MySql Statement. Example: "c20fcea11911be36651b7ca7bd3712d4ed9ac1134cee9c6620039e1fb13b5eff"
public Date getTimeCollected()
Collection timestamp. Example: "2020-03-31T00:00:00.000Z"
public String getCommandType()
Type of statement such as select, update or delete.
public Long getTotalRows()
Total number of SQL statements used in collection ranking calculation.
public Long getPerfSchemaUsedPercent()
Percent of SQL statements in the perf schema table relative to max or overflow count set in @@GLOBAL.performance_schema_digests_size.
public String getSchemaName()
Name of Database Schema. Example: "performance_schema"
public Long getExecCount()
The total number of times the statement has executed.
public Long getTotalLatencyInPs()
The total wait time (in picoseconds) of timed occurrences of the statement.
public Long getLockLatencyInPs()
The total time waiting (in picoseconds) for locks by timed occurrences of the statement.
public Long getErrCount()
The total number of errors produced by occurrences of the statement.
public Long getWarnCount()
The total number of warnings produced by occurrences of the statement.
public Long getRowsAffected()
The total number of rows affected by occurrences of the statement.
public Long getRowsSent()
The total number of rows returned by occurrences of the statement.
public Long getRowsExamined()
The total number of rows read from storage engines by occurrences of the statement.
public Long getTmpDiskTables()
The total number of internal on-disk temporary tables created by occurrences of the statement.
public Long getTmpTables()
The total number of internal in-memory temporary tables created by occurrences of the statement Count
public Long getSelectFullJoin()
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
public Long getSelectFullRangeJoin()
The total number of joins that used a range search on a reference table by occurrences of the statement
public Long getSelectRange()
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
public Long getSelectRangeCheck()
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
public Long getSelectScan()
The total number of joins that did a full scan of the first table by occurrences of the statement Count
public Long getSortMergePasses()
The total number of sort merge passes by occurrences of the statement.
public Long getSortRange()
The total number of sorts that were done using ranges by occurrences of the statement.
public Long getRowsSorted()
The total number of rows sorted by occurrences of the statement.
public Long getSortScan()
The total number of sorts that were done by scanning the table by occurrences of the statement.
public Long getNoIndexUsedCount()
The number of occurences of the statement which performed a table scan without using an index Count
public Long getNoGoodIndexUsedCount()
The number of occurences of the statement where the server found no good index to use Count
public Long getCpuLatencyInPs()
The total time spent on CPU (in picoseconds) for the current thread.
public Long getMaxControlledMemoryInBytes()
The maximum amount of controlled memory (in bytes) used by the statement.
public Long getMaxTotalMemoryInBytes()
The maximum amount of memory (in bytes) used by the statement.
public Long getExecCountSecondary()
The total number of times a query was processed on the secondary engine (HEATWAVE) for occurrences of this statement Count.
public Date getTimeFirstSeen()
The time at which statement was first seen. Example: "2023-01-16 08:04:31.533577"
public Date getTimeLastSeen()
The time at which statement was most recently seen for all occurrences of the statement.
Example: "2023-01-30 02:17:08.067961"
public String toString()
toString in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModelpublic String toString(boolean includeByteArrayContents)
Return a string representation of the object.
includeByteArrayContents - true to include the full contents of byte arrayspublic boolean equals(Object o)
equals in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModelpublic int hashCode()
hashCode in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModelCopyright © 2016–2024. All rights reserved.