Package com.oracle.bmc.databasemanagement.model

Class MySqlDataSummary.Builder

    • 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

      • maxControlledMemory

        public MySqlDataSummary.Builder maxControlledMemory​(Long maxControlledMemory)
        The maximum amount of controlled memory used by a statement during execution.
        Parameters:
        maxControlledMemory - the value to set
        Returns:
        this builder

      • maxTotalMemory

        public MySqlDataSummary.Builder maxTotalMemory​(Long maxTotalMemory)
        The maximum amount of memory used by a statement during execution.
        Parameters:
        maxTotalMemory - the value to set
        Returns:
        this builder

      • sumCpuTime

        public MySqlDataSummary.Builder sumCpuTime​(Long sumCpuTime)
        The total amount of time spent on CPU for this statement.
        Parameters:
        sumCpuTime - 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 \u201cRange Checked For Each Record.\u201d

        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