Package com.oracle.bmc.opsi.model

Class MySqlSqlStats.Builder

    • 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