MySqlSqlStats.Builder (Oracle Cloud Infrastructure Java SDK

java.lang.Object
- com.oracle.bmc.opsi.model.MySqlSqlStats.Builder

Enclosing class:: MySqlSqlStats

public static class MySqlSqlStats.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
`MySqlSqlStats`	`build()`
`MySqlSqlStats.Builder`	`commandType(String commandType)` Type of statement such as select, update or delete.
`MySqlSqlStats.Builder`	`copy(MySqlSqlStats model)`
`MySqlSqlStats.Builder`	`cpuLatencyInPs(Long cpuLatencyInPs)` The total time spent on CPU (in picoseconds) for the current thread.
`MySqlSqlStats.Builder`	`digest(String digest)` Unique SQL ID Digest for a MySql Statement.
`MySqlSqlStats.Builder`	`errCount(Long errCount)` The total number of errors produced by occurrences of the statement.
`MySqlSqlStats.Builder`	`execCount(Long execCount)` The total number of times the statement has executed.
`MySqlSqlStats.Builder`	`execCountSecondary(Long execCountSecondary)` The total number of times a query was processed on the secondary engine (HEATWAVE) for occurrences of this statement Count.
`MySqlSqlStats.Builder`	`lockLatencyInPs(Long lockLatencyInPs)` The total time waiting (in picoseconds) for locks by timed occurrences of the statement.
`MySqlSqlStats.Builder`	`maxControlledMemoryInBytes(Long maxControlledMemoryInBytes)` The maximum amount of controlled memory (in bytes) used by the statement.
`MySqlSqlStats.Builder`	`maxTotalMemoryInBytes(Long maxTotalMemoryInBytes)` The maximum amount of memory (in bytes) used by the statement.
`MySqlSqlStats.Builder`	`noGoodIndexUsedCount(Long noGoodIndexUsedCount)` The number of occurences of the statement where the server found no good index to use Count
`MySqlSqlStats.Builder`	`noIndexUsedCount(Long noIndexUsedCount)` The number of occurences of the statement which performed a table scan without using an index Count
`MySqlSqlStats.Builder`	`perfSchemaUsedPercent(Long perfSchemaUsedPercent)` Percent of SQL statements in the perf schema table relative to max or overflow count set in @@GLOBAL.performance_schema_digests_size.
`MySqlSqlStats.Builder`	`rowsAffected(Long rowsAffected)` The total number of rows affected by occurrences of the statement.
`MySqlSqlStats.Builder`	`rowsExamined(Long rowsExamined)` The total number of rows read from storage engines by occurrences of the statement.
`MySqlSqlStats.Builder`	`rowsSent(Long rowsSent)` The total number of rows returned by occurrences of the statement.
`MySqlSqlStats.Builder`	`rowsSorted(Long rowsSorted)` The total number of rows sorted by occurrences of the statement.
`MySqlSqlStats.Builder`	`schemaName(String schemaName)` Name of Database Schema.
`MySqlSqlStats.Builder`	`selectFullJoin(Long selectFullJoin)` The total number of joins that perform table scans because they do not use indexes by occurrences of the statement.
`MySqlSqlStats.Builder`	`selectFullRangeJoin(Long selectFullRangeJoin)` The total number of joins that used a range search on a reference table by occurrences of the statement
`MySqlSqlStats.Builder`	`selectRange(Long selectRange)` The total number of joins that used ranges on the first table by occurrences of the statement.
`MySqlSqlStats.Builder`	`selectRangeCheck(Long selectRangeCheck)` The total number of joins without keys that check for key usage after each row by occurrences of the statement.
`MySqlSqlStats.Builder`	`selectScan(Long selectScan)` The total number of joins that did a full scan of the first table by occurrences of the statement Count
`MySqlSqlStats.Builder`	`sortMergePasses(Long sortMergePasses)` The total number of sort merge passes by occurrences of the statement.
`MySqlSqlStats.Builder`	`sortRange(Long sortRange)` The total number of sorts that were done using ranges by occurrences of the statement.
`MySqlSqlStats.Builder`	`sortScan(Long sortScan)` The total number of sorts that were done by scanning the table by occurrences of the statement.
`MySqlSqlStats.Builder`	`timeCollected(Date timeCollected)` Collection timestamp.
`MySqlSqlStats.Builder`	`timeFirstSeen(Date timeFirstSeen)` The time at which statement was first seen.
`MySqlSqlStats.Builder`	`timeLastSeen(Date timeLastSeen)` The time at which statement was most recently seen for all occurrences of the statement.
`MySqlSqlStats.Builder`	`tmpDiskTables(Long tmpDiskTables)` The total number of internal on-disk temporary tables created by occurrences of the statement.
`MySqlSqlStats.Builder`	`tmpTables(Long tmpTables)` The total number of internal in-memory temporary tables created by occurrences of the statement Count
`MySqlSqlStats.Builder`	`totalLatencyInPs(Long totalLatencyInPs)` The total wait time (in picoseconds) of timed occurrences of the statement.
`MySqlSqlStats.Builder`	`totalRows(Long totalRows)` Total number of SQL statements used in collection ranking calculation.
`MySqlSqlStats.Builder`	`warnCount(Long warnCount)` The total number of warnings produced by occurrences of the statement.

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
  - digest
```
public MySqlSqlStats.Builder digest(String digest)
```
    Unique SQL ID Digest for a MySql Statement. Example: "c20fcea11911be36651b7ca7bd3712d4ed9ac1134cee9c6620039e1fb13b5eff"
    
    Parameters:
    
    digest - the value to set
    
    Returns:
    
    this builder
  - timeCollected
```
public MySqlSqlStats.Builder timeCollected(Date timeCollected)
```
    Collection timestamp. Example: "2020-03-31T00:00:00.000Z"
    
    Parameters:
    
    timeCollected - the value to set
    
    Returns:
    
    this builder
  - commandType
```
public MySqlSqlStats.Builder commandType(String commandType)
```
    Type of statement such as select, update or delete.
    
    Parameters:
    
    commandType - the value to set
    
    Returns:
    
    this builder
  - totalRows
```
public MySqlSqlStats.Builder totalRows(Long totalRows)
```
    Total number of SQL statements used in collection ranking calculation.
    
    Parameters:
    
    totalRows - the value to set
    
    Returns:
    
    this builder
  - perfSchemaUsedPercent
```
public MySqlSqlStats.Builder perfSchemaUsedPercent(Long perfSchemaUsedPercent)
```
    Percent of SQL statements in the perf schema table relative to max or overflow count set in @@GLOBAL.performance_schema_digests_size.
    
    Parameters:
    
    perfSchemaUsedPercent - the value to set
    
    Returns:
    
    this builder
  - schemaName
```
public MySqlSqlStats.Builder schemaName(String schemaName)
```
    Name of Database Schema. Example: "performance_schema"
    
    Parameters:
    
    schemaName - the value to set
    
    Returns:
    
    this builder
  - execCount
```
public MySqlSqlStats.Builder execCount(Long execCount)
```
    The total number of times the statement has executed.
    
    Parameters:
    
    execCount - the value to set
    
    Returns:
    
    this builder
  - totalLatencyInPs
```
public MySqlSqlStats.Builder totalLatencyInPs(Long totalLatencyInPs)
```
    The total wait time (in picoseconds) of timed occurrences of the statement.
    
    Parameters:
    
    totalLatencyInPs - the value to set
    
    Returns:
    
    this builder
  - lockLatencyInPs
```
public MySqlSqlStats.Builder lockLatencyInPs(Long lockLatencyInPs)
```
    The total time waiting (in picoseconds) for locks by timed occurrences of the statement.
    
    Parameters:
    
    lockLatencyInPs - the value to set
    
    Returns:
    
    this builder
  - errCount
```
public MySqlSqlStats.Builder errCount(Long errCount)
```
    The total number of errors produced by occurrences of the statement.
    
    Parameters:
    
    errCount - the value to set
    
    Returns:
    
    this builder
  - warnCount
```
public MySqlSqlStats.Builder warnCount(Long warnCount)
```
    The total number of warnings produced by occurrences of the statement.
    
    Parameters:
    
    warnCount - the value to set
    
    Returns:
    
    this builder
  - rowsAffected
```
public MySqlSqlStats.Builder rowsAffected(Long rowsAffected)
```
    The total number of rows affected by occurrences of the statement.
    
    Parameters:
    
    rowsAffected - the value to set
    
    Returns:
    
    this builder
  - rowsSent
```
public MySqlSqlStats.Builder rowsSent(Long rowsSent)
```
    The total number of rows returned by occurrences of the statement.
    
    Parameters:
    
    rowsSent - the value to set
    
    Returns:
    
    this builder
  - rowsExamined
```
public MySqlSqlStats.Builder rowsExamined(Long rowsExamined)
```
    The total number of rows read from storage engines by occurrences of the statement.
    
    Parameters:
    
    rowsExamined - the value to set
    
    Returns:
    
    this builder
  - tmpDiskTables
```
public MySqlSqlStats.Builder tmpDiskTables(Long tmpDiskTables)
```
    The total number of internal on-disk temporary tables created by occurrences of the statement.
    
    Parameters:
    
    tmpDiskTables - the value to set
    
    Returns:
    
    this builder
  - tmpTables
```
public MySqlSqlStats.Builder tmpTables(Long tmpTables)
```
    The total number of internal in-memory temporary tables created by occurrences of the statement Count
    
    Parameters:
    
    tmpTables - the value to set
    
    Returns:
    
    this builder
  - selectFullJoin
```
public MySqlSqlStats.Builder selectFullJoin(Long selectFullJoin)
```
    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
    
    Parameters:
    
    selectFullJoin - the value to set
    
    Returns:
    
    this builder
  - selectFullRangeJoin
```
public MySqlSqlStats.Builder selectFullRangeJoin(Long selectFullRangeJoin)
```
    The total number of joins that used a range search on a reference table by occurrences of the statement
    
    Parameters:
    
    selectFullRangeJoin - the value to set
    
    Returns:
    
    this builder
  - selectRange
```
public MySqlSqlStats.Builder selectRange(Long selectRange)
```
    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
    
    Parameters:
    
    selectRange - the value to set
    
    Returns:
    
    this builder
  - selectRangeCheck
```
public MySqlSqlStats.Builder selectRangeCheck(Long selectRangeCheck)
```
    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
    
    Parameters:
    
    selectRangeCheck - the value to set
    
    Returns:
    
    this builder
  - selectScan
```
public MySqlSqlStats.Builder selectScan(Long selectScan)
```
    The total number of joins that did a full scan of the first table by occurrences of the statement Count
    
    Parameters:
    
    selectScan - the value to set
    
    Returns:
    
    this builder
  - sortMergePasses
```
public MySqlSqlStats.Builder sortMergePasses(Long sortMergePasses)
```
    The total number of sort merge passes by occurrences of the statement.
    
    Parameters:
    
    sortMergePasses - the value to set
    
    Returns:
    
    this builder
  - sortRange
```
public MySqlSqlStats.Builder sortRange(Long sortRange)
```
    The total number of sorts that were done using ranges by occurrences of the statement.
    
    Parameters:
    
    sortRange - the value to set
    
    Returns:
    
    this builder
  - rowsSorted
```
public MySqlSqlStats.Builder rowsSorted(Long rowsSorted)
```
    The total number of rows sorted by occurrences of the statement.
    
    Parameters:
    
    rowsSorted - the value to set
    
    Returns:
    
    this builder
  - sortScan
```
public MySqlSqlStats.Builder sortScan(Long sortScan)
```
    The total number of sorts that were done by scanning the table by occurrences of the statement.
    
    Parameters:
    
    sortScan - the value to set
    
    Returns:
    
    this builder
  - noIndexUsedCount
```
public MySqlSqlStats.Builder noIndexUsedCount(Long noIndexUsedCount)
```
    The number of occurences of the statement which performed a table scan without using an index Count
    
    Parameters:
    
    noIndexUsedCount - the value to set
    
    Returns:
    
    this builder
  - noGoodIndexUsedCount
```
public MySqlSqlStats.Builder noGoodIndexUsedCount(Long noGoodIndexUsedCount)
```
    The number of occurences of the statement where the server found no good index to use Count
    
    Parameters:
    
    noGoodIndexUsedCount - the value to set
    
    Returns:
    
    this builder
  - cpuLatencyInPs
```
public MySqlSqlStats.Builder cpuLatencyInPs(Long cpuLatencyInPs)
```
    The total time spent on CPU (in picoseconds) for the current thread.
    
    Parameters:
    
    cpuLatencyInPs - the value to set
    
    Returns:
    
    this builder
  - maxControlledMemoryInBytes
```
public MySqlSqlStats.Builder maxControlledMemoryInBytes(Long maxControlledMemoryInBytes)
```
    The maximum amount of controlled memory (in bytes) used by the statement.
    
    Parameters:
    
    maxControlledMemoryInBytes - the value to set
    
    Returns:
    
    this builder
  - maxTotalMemoryInBytes
```
public MySqlSqlStats.Builder maxTotalMemoryInBytes(Long maxTotalMemoryInBytes)
```
    The maximum amount of memory (in bytes) used by the statement.
    
    Parameters:
    
    maxTotalMemoryInBytes - the value to set
    
    Returns:
    
    this builder
  - execCountSecondary
```
public MySqlSqlStats.Builder execCountSecondary(Long execCountSecondary)
```
    The total number of times a query was processed on the secondary engine (HEATWAVE) for occurrences of this statement Count.
    
    Parameters:
    
    execCountSecondary - the value to set
    
    Returns:
    
    this builder
  - timeFirstSeen
```
public MySqlSqlStats.Builder timeFirstSeen(Date timeFirstSeen)
```
    The time at which statement was first seen. Example: "2023-01-16 08:04:31.533577"
    
    Parameters:
    
    timeFirstSeen - the value to set
    
    Returns:
    
    this builder
  - timeLastSeen
```
public MySqlSqlStats.Builder timeLastSeen(Date timeLastSeen)
```
    The time at which statement was most recently seen for all occurrences of the statement. Example: "2023-01-30 02:17:08.067961"
    
    Parameters:
    
    timeLastSeen - the value to set
    
    Returns:
    
    this builder
  - build
```
public MySqlSqlStats build()
```
  - copy
```
public MySqlSqlStats.Builder copy(MySqlSqlStats model)
```

Class MySqlSqlStats.Builder

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

Builder

Method Detail

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

build

copy