MySqlDataSummary.Builder (Oracle Cloud Infrastructure Java SDK

java.lang.Object
- com.oracle.bmc.databasemanagement.model.MySqlDataSummary.Builder

Enclosing class:: MySqlDataSummary

public static class MySqlDataSummary.Builder
extends Object

Constructor Summary

Constructors
Constructor and Description

Builder()

Constructors
Constructor and Description
`Builder()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`MySqlDataSummary.Builder`	`avgTimerWait(BigDecimal avgTimerWait)` The average execution time.
`MySqlDataSummary`	`build()`
`MySqlDataSummary.Builder`	`copy(MySqlDataSummary model)`
`MySqlDataSummary.Builder`	`countStar(BigDecimal countStar)` The number Of times the query has been executed.
`MySqlDataSummary.Builder`	`digest(String digest)` The digest information of the normalized query.
`MySqlDataSummary.Builder`	`digestText(String digestText)` The normalized query.
`MySqlDataSummary.Builder`	`firstSeen(Date firstSeen)` The date and time the query was first seen.
`MySqlDataSummary.Builder`	`heatWaveOffloaded(BigDecimal heatWaveOffloaded)` The number of query executions offloaded to HeatWave.
`MySqlDataSummary.Builder`	`heatWaveOutOfMemory(BigDecimal heatWaveOutOfMemory)` The number of query executions with HeatWave out-of-memory errors.
`MySqlDataSummary.Builder`	`lastSeen(Date lastSeen)` The date and time the query was last seen.
`MySqlDataSummary.Builder`	`maxTimerWait(BigDecimal maxTimerWait)` The slowest the query has been executed.
`MySqlDataSummary.Builder`	`minTimerWait(BigDecimal minTimerWait)` The fastest the query has been executed.
`MySqlDataSummary.Builder`	`quantile95(BigDecimal quantile95)` The 95th percentile of the query latency.
`MySqlDataSummary.Builder`	`quantile99(BigDecimal quantile99)` The 99th percentile of the query latency.
`MySqlDataSummary.Builder`	`quantile999(BigDecimal quantile999)` The 99.9th percentile of the query latency.
`MySqlDataSummary.Builder`	`schemaName(String schemaName)` The name of the default schema when executing the query.
`MySqlDataSummary.Builder`	`sumCreatedTempDiskTables(BigDecimal sumCreatedTempDiskTables)` The total number of On-Disk internal temporary tables that have been created by the query.
`MySqlDataSummary.Builder`	`sumCreatedTempTables(BigDecimal sumCreatedTempTables)` The total number of internal temporary tables (in memory or on disk), which have been created by the query.
`MySqlDataSummary.Builder`	`sumErrors(BigDecimal sumErrors)` The total number of errors that have been encountered executing the query.
`MySqlDataSummary.Builder`	`sumLockTime(BigDecimal sumLockTime)` The total amount of time that has been spent waiting for table locks.
`MySqlDataSummary.Builder`	`sumNoGoodIndexUsed(BigDecimal sumNoGoodIndexUsed)` The total number of times no good index was used.
`MySqlDataSummary.Builder`	`sumNoIndexUsed(BigDecimal sumNoIndexUsed)` The total number of times no index was used to execute the query.
`MySqlDataSummary.Builder`	`sumRowsAffected(BigDecimal sumRowsAffected)` The total number of rows that have been modified by the query.
`MySqlDataSummary.Builder`	`sumRowsExamined(BigDecimal sumRowsExamined)` The total number of rows that have been examined by the query.
`MySqlDataSummary.Builder`	`sumRowsSent(BigDecimal sumRowsSent)` The total number of rows that have been returned (sent) to the client.
`MySqlDataSummary.Builder`	`sumSelectFullJoin(BigDecimal sumSelectFullJoin)` The total number of joins that have performed full table scans as there was no join condition or no index for the join condition.
`MySqlDataSummary.Builder`	`sumSelectFullRangeJoin(BigDecimal sumSelectFullRangeJoin)` The total number of joins that use a full range search.
`MySqlDataSummary.Builder`	`sumSelectRange(BigDecimal sumSelectRange)` The total number of times the query has used a range search.
`MySqlDataSummary.Builder`	`sumSelectRangeCheck(BigDecimal sumSelectRangeCheck)` 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.
`MySqlDataSummary.Builder`	`sumSelectScan(BigDecimal sumSelectScan)` The total number of times the query has performed a full table scan on the first table in the join.
`MySqlDataSummary.Builder`	`sumSortMergePasses(BigDecimal sumSortMergePasses)` The total number of sort merge passes that have been done to sort the result of the query.
`MySqlDataSummary.Builder`	`sumSortRange(BigDecimal sumSortRange)` The total number of times a sort was done using ranges.
`MySqlDataSummary.Builder`	`sumSortRows(BigDecimal sumSortRows)` The total number of rows sorted.
`MySqlDataSummary.Builder`	`sumSortScan(BigDecimal sumSortScan)` The total number of times a sort was done by scanning the table.
`MySqlDataSummary.Builder`	`sumTimerWait(BigDecimal sumTimerWait)` The total amount of time that has been spent executing the query.
`MySqlDataSummary.Builder`	`sumWarnings(BigDecimal sumWarnings)` The total number of warnings that have been encountered executing the query.

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

- Constructor Detail
  - Builder
```
public Builder()
```
- Method Detail
  - schemaName
```
public MySqlDataSummary.Builder schemaName(String schemaName)
```
    The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL.
    
    Parameters:
    
    schemaName - the value to set
    
    Returns:
    
    this builder
  - digest
```
public MySqlDataSummary.Builder digest(String digest)
```
    The digest information of the normalized query.
    
    Parameters:
    
    digest - the value to set
    
    Returns:
    
    this builder
  - digestText
```
public MySqlDataSummary.Builder digestText(String digestText)
```
    The normalized query.
    
    Parameters:
    
    digestText - the value to set
    
    Returns:
    
    this builder
  - countStar
```
public MySqlDataSummary.Builder countStar(BigDecimal countStar)
```
    The number Of times the query has been executed.
    
    Parameters:
    
    countStar - the value to set
    
    Returns:
    
    this builder
  - sumTimerWait
```
public MySqlDataSummary.Builder sumTimerWait(BigDecimal sumTimerWait)
```
    The total amount of time that has been spent executing the query.
    
    Parameters:
    
    sumTimerWait - the value to set
    
    Returns:
    
    this builder
  - minTimerWait
```
public MySqlDataSummary.Builder minTimerWait(BigDecimal minTimerWait)
```
    The fastest the query has been executed.
    
    Parameters:
    
    minTimerWait - the value to set
    
    Returns:
    
    this builder
  - avgTimerWait
```
public MySqlDataSummary.Builder avgTimerWait(BigDecimal avgTimerWait)
```
    The average execution time.
    
    Parameters:
    
    avgTimerWait - the value to set
    
    Returns:
    
    this builder
  - maxTimerWait
```
public MySqlDataSummary.Builder maxTimerWait(BigDecimal maxTimerWait)
```
    The slowest the query has been executed.
    
    Parameters:
    
    maxTimerWait - the value to set
    
    Returns:
    
    this builder
  - sumLockTime
```
public MySqlDataSummary.Builder sumLockTime(BigDecimal sumLockTime)
```
    The total amount of time that has been spent waiting for table locks.
    
    Parameters:
    
    sumLockTime - the value to set
    
    Returns:
    
    this builder
  - sumErrors
```
public MySqlDataSummary.Builder sumErrors(BigDecimal sumErrors)
```
    The total number of errors that have been encountered executing the query.
    
    Parameters:
    
    sumErrors - the value to set
    
    Returns:
    
    this builder
  - sumWarnings
```
public MySqlDataSummary.Builder sumWarnings(BigDecimal sumWarnings)
```
    The total number of warnings that have been encountered executing the query.
    
    Parameters:
    
    sumWarnings - the value to set
    
    Returns:
    
    this builder
  - sumRowsAffected
```
public MySqlDataSummary.Builder sumRowsAffected(BigDecimal sumRowsAffected)
```
    The total number of rows that have been modified by the query.
    
    Parameters:
    
    sumRowsAffected - the value to set
    
    Returns:
    
    this builder
  - sumRowsSent
```
public MySqlDataSummary.Builder sumRowsSent(BigDecimal sumRowsSent)
```
    The total number of rows that have been returned (sent) to the client.
    
    Parameters:
    
    sumRowsSent - the value to set
    
    Returns:
    
    this builder
  - sumRowsExamined
```
public MySqlDataSummary.Builder sumRowsExamined(BigDecimal sumRowsExamined)
```
    The total number of rows that have been examined by the query.
    
    Parameters:
    
    sumRowsExamined - the value to set
    
    Returns:
    
    this builder
  - sumCreatedTempDiskTables
```
public MySqlDataSummary.Builder sumCreatedTempDiskTables(BigDecimal sumCreatedTempDiskTables)
```
    The total number of On-Disk internal temporary tables that have been created by the query.
    
    Parameters:
    
    sumCreatedTempDiskTables - the value to set
    
    Returns:
    
    this builder
  - sumCreatedTempTables
```
public MySqlDataSummary.Builder sumCreatedTempTables(BigDecimal sumCreatedTempTables)
```
    The total number of internal temporary tables (in memory or on disk), which have been created by the query.
    
    Parameters:
    
    sumCreatedTempTables - the value to set
    
    Returns:
    
    this builder
  - sumSelectFullJoin
```
public MySqlDataSummary.Builder sumSelectFullJoin(BigDecimal sumSelectFullJoin)
```
    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.
    
    Parameters:
    
    sumSelectFullJoin - the value to set
    
    Returns:
    
    this builder
  - sumSelectFullRangeJoin
```
public MySqlDataSummary.Builder sumSelectFullRangeJoin(BigDecimal sumSelectFullRangeJoin)
```
    The total number of joins that use a full range search. This is the same as the select_full_range_join status variable.
    
    Parameters:
    
    sumSelectFullRangeJoin - the value to set
    
    Returns:
    
    this builder
  - sumSelectRange
```
public MySqlDataSummary.Builder sumSelectRange(BigDecimal sumSelectRange)
```
    The total number of times the query has used a range search. This is the same as the select_range status variable.
    
    Parameters:
    
    sumSelectRange - the value to set
    
    Returns:
    
    this builder
  - sumSelectRangeCheck
```
public MySqlDataSummary.Builder sumSelectRangeCheck(BigDecimal sumSelectRangeCheck)
```
    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.
    
    Parameters:
    
    sumSelectRangeCheck - the value to set
    
    Returns:
    
    this builder
  - sumSelectScan
```
public MySqlDataSummary.Builder sumSelectScan(BigDecimal sumSelectScan)
```
    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.
    
    Parameters:
    
    sumSelectScan - the value to set
    
    Returns:
    
    this builder
  - sumSortMergePasses
```
public MySqlDataSummary.Builder sumSortMergePasses(BigDecimal sumSortMergePasses)
```
    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.
    
    Parameters:
    
    sumSortMergePasses - the value to set
    
    Returns:
    
    this builder
  - sumSortRange
```
public MySqlDataSummary.Builder sumSortRange(BigDecimal sumSortRange)
```
    The total number of times a sort was done using ranges. This is the same as the sort_range status variable.
    
    Parameters:
    
    sumSortRange - the value to set
    
    Returns:
    
    this builder
  - sumSortRows
```
public MySqlDataSummary.Builder sumSortRows(BigDecimal sumSortRows)
```
    The total number of rows sorted. This is the same as the sort_rowsStatus variable.
    
    Parameters:
    
    sumSortRows - the value to set
    
    Returns:
    
    this builder
  - sumSortScan
```
public MySqlDataSummary.Builder sumSortScan(BigDecimal sumSortScan)
```
    The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable.
    
    Parameters:
    
    sumSortScan - the value to set
    
    Returns:
    
    this builder
  - sumNoIndexUsed
```
public MySqlDataSummary.Builder sumNoIndexUsed(BigDecimal sumNoIndexUsed)
```
    The total number of times no index was used to execute the query.
    
    Parameters:
    
    sumNoIndexUsed - the value to set
    
    Returns:
    
    this builder
  - sumNoGoodIndexUsed
```
public MySqlDataSummary.Builder sumNoGoodIndexUsed(BigDecimal sumNoGoodIndexUsed)
```
    The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes “Range Checked For Each Record.”
    
    Parameters:
    
    sumNoGoodIndexUsed - the value to set
    
    Returns:
    
    this builder
  - firstSeen
```
public MySqlDataSummary.Builder firstSeen(Date firstSeen)
```
    The date and time the query was first seen. If the table is truncated, the first seen value is reset.
    
    Parameters:
    
    firstSeen - the value to set
    
    Returns:
    
    this builder
  - lastSeen
```
public MySqlDataSummary.Builder lastSeen(Date lastSeen)
```
    The date and time the query was last seen.
    
    Parameters:
    
    lastSeen - the value to set
    
    Returns:
    
    this builder
  - quantile95
```
public MySqlDataSummary.Builder quantile95(BigDecimal quantile95)
```
    The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time.
    
    Parameters:
    
    quantile95 - the value to set
    
    Returns:
    
    this builder
  - quantile99
```
public MySqlDataSummary.Builder quantile99(BigDecimal quantile99)
```
    The 99th percentile of the query latency.
    
    Parameters:
    
    quantile99 - the value to set
    
    Returns:
    
    this builder
  - quantile999
```
public MySqlDataSummary.Builder quantile999(BigDecimal quantile999)
```
    The 99.9th percentile of the query latency.
    
    Parameters:
    
    quantile999 - the value to set
    
    Returns:
    
    this builder
  - heatWaveOffloaded
```
public MySqlDataSummary.Builder heatWaveOffloaded(BigDecimal heatWaveOffloaded)
```
    The number of query executions offloaded to HeatWave.
    
    Parameters:
    
    heatWaveOffloaded - the value to set
    
    Returns:
    
    this builder
  - heatWaveOutOfMemory
```
public MySqlDataSummary.Builder heatWaveOutOfMemory(BigDecimal heatWaveOutOfMemory)
```
    The number of query executions with HeatWave out-of-memory errors.
    
    Parameters:
    
    heatWaveOutOfMemory - the value to set
    
    Returns:
    
    this builder
  - build
```
public MySqlDataSummary build()
```
  - copy
```
public MySqlDataSummary.Builder copy(MySqlDataSummary model)
```

Class MySqlDataSummary.Builder

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

Builder

Method Detail

schemaName

digest

digestText

countStar

sumTimerWait

minTimerWait

avgTimerWait

maxTimerWait

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

build

copy