java.lang.Object
- com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
- - com.oracle.bmc.databasemanagement.model.MySqlDataSummary

```
@Generated(value="OracleSDKGenerator",
           comments="API Version: 20201101")
public final class MySqlDataSummary
extends com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
```
The SQL performance data record for a specific SQL query.
Note: Objects should always be created or deserialized using the MySqlDataSummary.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 MySqlDataSummary.Builder, which maintain a set of all explicitly set fields called MySqlDataSummary.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).

Nested Class Summary

Nested Classes
Modifier and Type Class Description

static class MySqlDataSummary.Builder

Field Summary
- Fields inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
  EXPLICITLY_SET_FILTER_NAME, EXPLICITLY_SET_PROPERTY_NAME

Constructor Summary

Constructors
Constructor	Description
MySqlDataSummary(String schemaName, String digest, String digestText, BigDecimal countStar, BigDecimal sumTimerWait, BigDecimal minTimerWait, BigDecimal avgTimerWait, BigDecimal maxTimerWait, Long maxControlledMemory, Long maxTotalMemory, Long sumCpuTime, BigDecimal sumLockTime, BigDecimal sumErrors, BigDecimal sumWarnings, BigDecimal sumRowsAffected, BigDecimal sumRowsSent, BigDecimal sumRowsExamined, BigDecimal sumCreatedTempDiskTables, BigDecimal sumCreatedTempTables, BigDecimal sumSelectFullJoin, BigDecimal sumSelectFullRangeJoin, BigDecimal sumSelectRange, BigDecimal sumSelectRangeCheck, BigDecimal sumSelectScan, BigDecimal sumSortMergePasses, BigDecimal sumSortRange, BigDecimal sumSortRows, BigDecimal sumSortScan, BigDecimal sumNoIndexUsed, BigDecimal sumNoGoodIndexUsed, Date firstSeen, Date lastSeen, BigDecimal quantile95, BigDecimal quantile99, BigDecimal quantile999, BigDecimal heatWaveOffloaded, BigDecimal heatWaveOutOfMemory)	Deprecated.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`static MySqlDataSummary.Builder`	`builder()`	Create a new builder.
`boolean`	`equals(Object o)`
`BigDecimal`	`getAvgTimerWait()`	The average execution time.
`BigDecimal`	`getCountStar()`	The number Of times the query has been executed.
`String`	`getDigest()`	The digest information of the normalized query.
`String`	`getDigestText()`	The normalized query.
`Date`	`getFirstSeen()`	The date and time the query was first seen.
`BigDecimal`	`getHeatWaveOffloaded()`	The number of query executions offloaded to HeatWave.
`BigDecimal`	`getHeatWaveOutOfMemory()`	The number of query executions with HeatWave out-of-memory errors.
`Date`	`getLastSeen()`	The date and time the query was last seen.
`Long`	`getMaxControlledMemory()`	The maximum amount of controlled memory used by a statement during execution.
`BigDecimal`	`getMaxTimerWait()`	The slowest the query has been executed.
`Long`	`getMaxTotalMemory()`	The maximum amount of memory used by a statement during execution.
`BigDecimal`	`getMinTimerWait()`	The fastest the query has been executed.
`BigDecimal`	`getQuantile95()`	The 95th percentile of the query latency.
`BigDecimal`	`getQuantile99()`	The 99th percentile of the query latency.
`BigDecimal`	`getQuantile999()`	The 99.9th percentile of the query latency.
`String`	`getSchemaName()`	The name of the default schema when executing the query.
`Long`	`getSumCpuTime()`	The total amount of time spent on CPU for this statement.
`BigDecimal`	`getSumCreatedTempDiskTables()`	The total number of On-Disk internal temporary tables that have been created by the query.
`BigDecimal`	`getSumCreatedTempTables()`	The total number of internal temporary tables (in memory or on disk), which have been created by the query.
`BigDecimal`	`getSumErrors()`	The total number of errors that have been encountered executing the query.
`BigDecimal`	`getSumLockTime()`	The total amount of time that has been spent waiting for table locks.
`BigDecimal`	`getSumNoGoodIndexUsed()`	The total number of times no good index was used.
`BigDecimal`	`getSumNoIndexUsed()`	The total number of times no index was used to execute the query.
`BigDecimal`	`getSumRowsAffected()`	The total number of rows that have been modified by the query.
`BigDecimal`	`getSumRowsExamined()`	The total number of rows that have been examined by the query.
`BigDecimal`	`getSumRowsSent()`	The total number of rows that have been returned (sent) to the client.
`BigDecimal`	`getSumSelectFullJoin()`	The total number of joins that have performed full table scans as there was no join condition or no index for the join condition.
`BigDecimal`	`getSumSelectFullRangeJoin()`	The total number of joins that use a full range search.
`BigDecimal`	`getSumSelectRange()`	The total number of times the query has used a range search.
`BigDecimal`	`getSumSelectRangeCheck()`	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.
`BigDecimal`	`getSumSelectScan()`	The total number of times the query has performed a full table scan on the first table in the join.
`BigDecimal`	`getSumSortMergePasses()`	The total number of sort merge passes that have been done to sort the result of the query.
`BigDecimal`	`getSumSortRange()`	The total number of times a sort was done using ranges.
`BigDecimal`	`getSumSortRows()`	The total number of rows sorted.
`BigDecimal`	`getSumSortScan()`	The total number of times a sort was done by scanning the table.
`BigDecimal`	`getSumTimerWait()`	The total amount of time that has been spent executing the query.
`BigDecimal`	`getSumWarnings()`	The total number of warnings that have been encountered executing the query.
`int`	`hashCode()`
`MySqlDataSummary.Builder`	`toBuilder()`
`String`	`toString()`
`String`	`toString(boolean includeByteArrayContents)`	Return a string representation of the object.

Methods inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
markPropertyAsExplicitlySet, wasPropertyExplicitlySet

Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

MySqlDataSummary

@Deprecated
@ConstructorProperties({"schemaName","digest","digestText","countStar","sumTimerWait","minTimerWait","avgTimerWait","maxTimerWait","maxControlledMemory","maxTotalMemory","sumCpuTime","sumLockTime","sumErrors","sumWarnings","sumRowsAffected","sumRowsSent","sumRowsExamined","sumCreatedTempDiskTables","sumCreatedTempTables","sumSelectFullJoin","sumSelectFullRangeJoin","sumSelectRange","sumSelectRangeCheck","sumSelectScan","sumSortMergePasses","sumSortRange","sumSortRows","sumSortScan","sumNoIndexUsed","sumNoGoodIndexUsed","firstSeen","lastSeen","quantile95","quantile99","quantile999","heatWaveOffloaded","heatWaveOutOfMemory"})
public MySqlDataSummary(String schemaName,
                        String digest,
                        String digestText,
                        BigDecimal countStar,
                        BigDecimal sumTimerWait,
                        BigDecimal minTimerWait,
                        BigDecimal avgTimerWait,
                        BigDecimal maxTimerWait,
                        Long maxControlledMemory,
                        Long maxTotalMemory,
                        Long sumCpuTime,
                        BigDecimal sumLockTime,
                        BigDecimal sumErrors,
                        BigDecimal sumWarnings,
                        BigDecimal sumRowsAffected,
                        BigDecimal sumRowsSent,
                        BigDecimal sumRowsExamined,
                        BigDecimal sumCreatedTempDiskTables,
                        BigDecimal sumCreatedTempTables,
                        BigDecimal sumSelectFullJoin,
                        BigDecimal sumSelectFullRangeJoin,
                        BigDecimal sumSelectRange,
                        BigDecimal sumSelectRangeCheck,
                        BigDecimal sumSelectScan,
                        BigDecimal sumSortMergePasses,
                        BigDecimal sumSortRange,
                        BigDecimal sumSortRows,
                        BigDecimal sumSortScan,
                        BigDecimal sumNoIndexUsed,
                        BigDecimal sumNoGoodIndexUsed,
                        Date firstSeen,
                        Date lastSeen,
                        BigDecimal quantile95,
                        BigDecimal quantile99,
                        BigDecimal quantile999,
                        BigDecimal heatWaveOffloaded,
                        BigDecimal heatWaveOutOfMemory)

Deprecated.

Method Detail
- builder
```
public static MySqlDataSummary.Builder builder()
```
  Create a new builder.
- toBuilder
```
public MySqlDataSummary.Builder toBuilder()
```
- getSchemaName
```
public String getSchemaName()
```
  The name of the default schema when executing the query.
  If a schema is not set as the default, then the value is NULL.
  
  Returns:
  
  the value
- getDigest
```
public String getDigest()
```
  The digest information of the normalized query.
  
  Returns:
  
  the value
- getDigestText
```
public String getDigestText()
```
  The normalized query.
  
  Returns:
  
  the value
- getCountStar
```
public BigDecimal getCountStar()
```
  The number Of times the query has been executed.
  
  Returns:
  
  the value
- getSumTimerWait
```
public BigDecimal getSumTimerWait()
```
  The total amount of time that has been spent executing the query.
  
  Returns:
  
  the value
- getMinTimerWait
```
public BigDecimal getMinTimerWait()
```
  The fastest the query has been executed.
  
  Returns:
  
  the value
- getAvgTimerWait
```
public BigDecimal getAvgTimerWait()
```
  The average execution time.
  
  Returns:
  
  the value
- getMaxTimerWait
```
public BigDecimal getMaxTimerWait()
```
  The slowest the query has been executed.
  
  Returns:
  
  the value
- getMaxControlledMemory
```
public Long getMaxControlledMemory()
```
  The maximum amount of controlled memory used by a statement during execution.
  
  Returns:
  
  the value
- getMaxTotalMemory
```
public Long getMaxTotalMemory()
```
  The maximum amount of memory used by a statement during execution.
  
  Returns:
  
  the value
- getSumCpuTime
```
public Long getSumCpuTime()
```
  The total amount of time spent on CPU for this statement.
  
  Returns:
  
  the value
- getSumLockTime
```
public BigDecimal getSumLockTime()
```
  The total amount of time that has been spent waiting for table locks.
  
  Returns:
  
  the value
- getSumErrors
```
public BigDecimal getSumErrors()
```
  The total number of errors that have been encountered executing the query.
  
  Returns:
  
  the value
- getSumWarnings
```
public BigDecimal getSumWarnings()
```
  The total number of warnings that have been encountered executing the query.
  
  Returns:
  
  the value
- getSumRowsAffected
```
public BigDecimal getSumRowsAffected()
```
  The total number of rows that have been modified by the query.
  
  Returns:
  
  the value
- getSumRowsSent
```
public BigDecimal getSumRowsSent()
```
  The total number of rows that have been returned (sent) to the client.
  
  Returns:
  
  the value
- getSumRowsExamined
```
public BigDecimal getSumRowsExamined()
```
  The total number of rows that have been examined by the query.
  
  Returns:
  
  the value
- getSumCreatedTempDiskTables
```
public BigDecimal getSumCreatedTempDiskTables()
```
  The total number of On-Disk internal temporary tables that have been created by the query.
  
  Returns:
  
  the value
- getSumCreatedTempTables
```
public BigDecimal getSumCreatedTempTables()
```
  The total number of internal temporary tables (in memory or on disk), which have been created by the query.
  
  Returns:
  
  the value
- getSumSelectFullJoin
```
public BigDecimal getSumSelectFullJoin()
```
  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.
  
  Returns:
  
  the value
- getSumSelectFullRangeJoin
```
public BigDecimal getSumSelectFullRangeJoin()
```
  The total number of joins that use a full range search.
  This is the same as the select_full_range_join status variable.
  
  Returns:
  
  the value
- getSumSelectRange
```
public BigDecimal getSumSelectRange()
```
  The total number of times the query has used a range search.
  This is the same as the select_range status variable.
  
  Returns:
  
  the value
- getSumSelectRangeCheck
```
public BigDecimal getSumSelectRangeCheck()
```
  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.
  
  Returns:
  
  the value
- getSumSelectScan
```
public BigDecimal getSumSelectScan()
```
  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.
  
  Returns:
  
  the value
- getSumSortMergePasses
```
public BigDecimal getSumSortMergePasses()
```
  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.
  
  Returns:
  
  the value
- getSumSortRange
```
public BigDecimal getSumSortRange()
```
  The total number of times a sort was done using ranges.
  This is the same as the sort_range status variable.
  
  Returns:
  
  the value
- getSumSortRows
```
public BigDecimal getSumSortRows()
```
  The total number of rows sorted.
  This is the same as the sort_rowsStatus variable.
  
  Returns:
  
  the value
- getSumSortScan
```
public BigDecimal getSumSortScan()
```
  The total number of times a sort was done by scanning the table.
  This is the same as the sort_scan status variable.
  
  Returns:
  
  the value
- getSumNoIndexUsed
```
public BigDecimal getSumNoIndexUsed()
```
  The total number of times no index was used to execute the query.
  
  Returns:
  
  the value
- getSumNoGoodIndexUsed
```
public BigDecimal getSumNoGoodIndexUsed()
```
  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
  
  Returns:
  
  the value
- getFirstSeen
```
public Date getFirstSeen()
```
  The date and time the query was first seen.
  If the table is truncated, the first seen value is reset.
  
  Returns:
  
  the value
- getLastSeen
```
public Date getLastSeen()
```
  The date and time the query was last seen.
  
  Returns:
  
  the value
- getQuantile95
```
public BigDecimal getQuantile95()
```
  The 95th percentile of the query latency.
  That is, 95% of the queries complete in the time given or in less time.
  
  Returns:
  
  the value
- getQuantile99
```
public BigDecimal getQuantile99()
```
  The 99th percentile of the query latency.
  
  Returns:
  
  the value
- getQuantile999
```
public BigDecimal getQuantile999()
```
  The 99.9th percentile of the query latency.
  
  Returns:
  
  the value
- getHeatWaveOffloaded
```
public BigDecimal getHeatWaveOffloaded()
```
  The number of query executions offloaded to HeatWave.
  
  Returns:
  
  the value
- getHeatWaveOutOfMemory
```
public BigDecimal getHeatWaveOutOfMemory()
```
  The number of query executions with HeatWave out-of-memory errors.
  
  Returns:
  
  the value
- toString
```
public String toString()
```
  Overrides:
  
  toString in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
- toString
```
public String toString(boolean includeByteArrayContents)
```
  Return a string representation of the object.
  
  Parameters:
  
  includeByteArrayContents - true to include the full contents of byte arrays
  
  Returns:
  
  string representation
- equals
```
public boolean equals(Object o)
```
  Overrides:
  
  equals in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
- hashCode
```
public int hashCode()
```
  Overrides:
  
  hashCode in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

Class MySqlDataSummary

Nested Class Summary

Field Summary

Fields inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

Constructor Summary

Method Summary

Methods inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

Methods inherited from class java.lang.Object

Constructor Detail

MySqlDataSummary

Method Detail

builder

toBuilder

getSchemaName

getDigest

getDigestText

getCountStar

getSumTimerWait

getMinTimerWait

getAvgTimerWait

getMaxTimerWait

getMaxControlledMemory

getMaxTotalMemory

getSumCpuTime

getSumLockTime

getSumErrors

getSumWarnings

getSumRowsAffected

getSumRowsSent

getSumRowsExamined

getSumCreatedTempDiskTables

getSumCreatedTempTables

getSumSelectFullJoin

getSumSelectFullRangeJoin

getSumSelectRange

getSumSelectRangeCheck

getSumSelectScan

getSumSortMergePasses

getSumSortRange

getSumSortRows

getSumSortScan

getSumNoIndexUsed

getSumNoGoodIndexUsed

getFirstSeen

getLastSeen

getQuantile95

getQuantile99

getQuantile999

getHeatWaveOffloaded

getHeatWaveOutOfMemory

toString

toString

equals

hashCode