Package com.oracle.bmc.opsi.model

Class MySqlSqlStats

  • @Generated(value="OracleSDKGenerator",
           comments="API Version: 20200630")
public final class MySqlSqlStats
extends com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
    MySql Sql Stats type object.
    Note: Objects should always be created or deserialized using the MySqlSqlStats.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 MySqlSqlStats.Builder, which maintain a set of all explicitly set fields called MySqlSqlStats.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).

    • Constructor Detail

      • MySqlSqlStats

        @Deprecated
@ConstructorProperties({"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"})
public MySqlSqlStats​(String digest,
                     Date timeCollected,
                     String commandType,
                     Long totalRows,
                     Long perfSchemaUsedPercent,
                     String schemaName,
                     Long execCount,
                     Long totalLatencyInPs,
                     Long lockLatencyInPs,
                     Long errCount,
                     Long warnCount,
                     Long rowsAffected,
                     Long rowsSent,
                     Long rowsExamined,
                     Long tmpDiskTables,
                     Long tmpTables,
                     Long selectFullJoin,
                     Long selectFullRangeJoin,
                     Long selectRange,
                     Long selectRangeCheck,
                     Long selectScan,
                     Long sortMergePasses,
                     Long sortRange,
                     Long rowsSorted,
                     Long sortScan,
                     Long noIndexUsedCount,
                     Long noGoodIndexUsedCount,
                     Long cpuLatencyInPs,
                     Long maxControlledMemoryInBytes,
                     Long maxTotalMemoryInBytes,
                     Long execCountSecondary,
                     Date timeFirstSeen,
                     Date timeLastSeen)
        Deprecated.

    • Method Detail

      • getDigest

        public String getDigest()
        Unique SQL ID Digest for a MySql Statement.

        Example: “c20fcea11911be36651b7ca7bd3712d4ed9ac1134cee9c6620039e1fb13b5eff”

        Returns:
        the value

      • getTimeCollected

        public Date getTimeCollected()
        Collection timestamp.

        Example: “2020-03-31T00:00:00.000Z”

        Returns:
        the value

      • getCommandType

        public String getCommandType()
        Type of statement such as select, update or delete.
        Returns:
        the value

      • getTotalRows

        public Long getTotalRows()
        Total number of SQL statements used in collection ranking calculation.
        Returns:
        the value

      • getPerfSchemaUsedPercent

        public Long getPerfSchemaUsedPercent()
        Percent of SQL statements in the perf schema table relative to max or overflow count set in @@GLOBAL.performance_schema_digests_size.
        Returns:
        the value

      • getSchemaName

        public String getSchemaName()
        Name of Database Schema.

        Example: “performance_schema”

        Returns:
        the value

      • getExecCount

        public Long getExecCount()
        The total number of times the statement has executed.
        Returns:
        the value

      • getTotalLatencyInPs

        public Long getTotalLatencyInPs()
        The total wait time (in picoseconds) of timed occurrences of the statement.
        Returns:
        the value

      • getLockLatencyInPs

        public Long getLockLatencyInPs()
        The total time waiting (in picoseconds) for locks by timed occurrences of the statement.
        Returns:
        the value

      • getErrCount

        public Long getErrCount()
        The total number of errors produced by occurrences of the statement.
        Returns:
        the value

      • getWarnCount

        public Long getWarnCount()
        The total number of warnings produced by occurrences of the statement.
        Returns:
        the value

      • getRowsAffected

        public Long getRowsAffected()
        The total number of rows affected by occurrences of the statement.
        Returns:
        the value

      • getRowsSent

        public Long getRowsSent()
        The total number of rows returned by occurrences of the statement.
        Returns:
        the value

      • getRowsExamined

        public Long getRowsExamined()
        The total number of rows read from storage engines by occurrences of the statement.
        Returns:
        the value

      • getTmpDiskTables

        public Long getTmpDiskTables()
        The total number of internal on-disk temporary tables created by occurrences of the statement.
        Returns:
        the value

      • getTmpTables

        public Long getTmpTables()
        The total number of internal in-memory temporary tables created by occurrences of the statement Count
        Returns:
        the value

      • getSelectFullJoin

        public Long getSelectFullJoin()
        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

        Returns:
        the value

      • getSelectFullRangeJoin

        public Long getSelectFullRangeJoin()
        The total number of joins that used a range search on a reference table by occurrences of the statement
        Returns:
        the value

      • getSelectRange

        public Long getSelectRange()
        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

        Returns:
        the value

      • getSelectRangeCheck

        public Long getSelectRangeCheck()
        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

        Returns:
        the value

      • getSelectScan

        public Long getSelectScan()
        The total number of joins that did a full scan of the first table by occurrences of the statement Count
        Returns:
        the value

      • getSortMergePasses

        public Long getSortMergePasses()
        The total number of sort merge passes by occurrences of the statement.
        Returns:
        the value

      • getSortRange

        public Long getSortRange()
        The total number of sorts that were done using ranges by occurrences of the statement.
        Returns:
        the value

      • getRowsSorted

        public Long getRowsSorted()
        The total number of rows sorted by occurrences of the statement.
        Returns:
        the value

      • getSortScan

        public Long getSortScan()
        The total number of sorts that were done by scanning the table by occurrences of the statement.
        Returns:
        the value

      • getNoIndexUsedCount

        public Long getNoIndexUsedCount()
        The number of occurences of the statement which performed a table scan without using an index Count
        Returns:
        the value

      • getNoGoodIndexUsedCount

        public Long getNoGoodIndexUsedCount()
        The number of occurences of the statement where the server found no good index to use Count
        Returns:
        the value

      • getCpuLatencyInPs

        public Long getCpuLatencyInPs()
        The total time spent on CPU (in picoseconds) for the current thread.
        Returns:
        the value

      • getMaxControlledMemoryInBytes

        public Long getMaxControlledMemoryInBytes()
        The maximum amount of controlled memory (in bytes) used by the statement.
        Returns:
        the value

      • getMaxTotalMemoryInBytes

        public Long getMaxTotalMemoryInBytes()
        The maximum amount of memory (in bytes) used by the statement.
        Returns:
        the value

      • getExecCountSecondary

        public Long getExecCountSecondary()
        The total number of times a query was processed on the secondary engine (HEATWAVE) for occurrences of this statement Count.
        Returns:
        the value

      • getTimeFirstSeen

        public Date getTimeFirstSeen()
        The time at which statement was first seen.

        Example: “2023-01-16 08:04:31.533577”

        Returns:
        the value

      • getTimeLastSeen

        public Date getTimeLastSeen()
        The time at which statement was most recently seen for all occurrences of the statement.

        Example: “2023-01-30 02:17:08.067961”

        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