Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace MySqlSqlStats

MySql Sql Stats type object.

Properties

Optional commandType

commandType: undefined | string

Type of statement such as select, update or delete.

Optional cpuLatencyInPs

cpuLatencyInPs: undefined | number

The total time spent on CPU (in picoseconds) for the current thread. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

digest

digest: string

Unique SQL ID Digest for a MySql Statement. Example: {@code "c20fcea11911be36651b7ca7bd3712d4ed9ac1134cee9c6620039e1fb13b5eff"}

Optional errCount

errCount: undefined | number

The total number of errors produced by occurrences of the statement. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional execCount

execCount: undefined | number

The total number of times the statement has executed. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional execCountSecondary

execCountSecondary: undefined | number

The total number of times a query was processed on the secondary engine (HEATWAVE) for occurrences of this statement Count. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional lockLatencyInPs

lockLatencyInPs: undefined | number

The total time waiting (in picoseconds) for locks by timed occurrences of the statement. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional maxControlledMemoryInBytes

maxControlledMemoryInBytes: undefined | number

The maximum amount of controlled memory (in bytes) used by the statement. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional maxTotalMemoryInBytes

maxTotalMemoryInBytes: undefined | number

The maximum amount of memory (in bytes) used by the statement. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional noGoodIndexUsedCount

noGoodIndexUsedCount: undefined | number

The number of occurences of the statement where the server found no good index to use Count Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional noIndexUsedCount

noIndexUsedCount: undefined | number

The number of occurences of the statement which performed a table scan without using an index Count Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional perfSchemaUsedPercent

perfSchemaUsedPercent: undefined | number

Percent of SQL statements in the perf schema table relative to max or overflow count set in @@GLOBAL.performance_schema_digests_size. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional rowsAffected

rowsAffected: undefined | number

The total number of rows affected by occurrences of the statement. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional rowsExamined

rowsExamined: undefined | number

The total number of rows read from storage engines by occurrences of the statement. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional rowsSent

rowsSent: undefined | number

The total number of rows returned by occurrences of the statement. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional rowsSorted

rowsSorted: undefined | number

The total number of rows sorted by occurrences of the statement. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional schemaName

schemaName: undefined | string

Name of Database Schema. Example: {@code "performance_schema"}

Optional selectFullJoin

selectFullJoin: undefined | number

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 Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional selectFullRangeJoin

selectFullRangeJoin: undefined | number

The total number of joins that used a range search on a reference table by occurrences of the statement Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional selectRange

selectRange: undefined | number

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 Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional selectRangeCheck

selectRangeCheck: undefined | number

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 Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional selectScan

selectScan: undefined | number

The total number of joins that did a full scan of the first table by occurrences of the statement Count Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional sortMergePasses

sortMergePasses: undefined | number

The total number of sort merge passes by occurrences of the statement. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional sortRange

sortRange: undefined | number

The total number of sorts that were done using ranges by occurrences of the statement. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional sortScan

sortScan: undefined | number

The total number of sorts that were done by scanning the table by occurrences of the statement. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

timeCollected

timeCollected: Date

Collection timestamp. Example: {@code "2020-03-31T00:00:00.000Z"}

Optional timeFirstSeen

timeFirstSeen: Date

The time at which statement was first seen. Example: {@code "2023-01-16 08:04:31.533577"}

Optional timeLastSeen

timeLastSeen: Date

The time at which statement was most recently seen for all occurrences of the statement. Example: {@code "2023-01-30 02:17:08.067961"}

Optional tmpDiskTables

tmpDiskTables: undefined | number

The total number of internal on-disk temporary tables created by occurrences of the statement. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional tmpTables

tmpTables: undefined | number

The total number of internal in-memory temporary tables created by occurrences of the statement Count Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional totalLatencyInPs

totalLatencyInPs: undefined | number

The total wait time (in picoseconds) of timed occurrences of the statement. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional totalRows

totalRows: undefined | number

Total number of SQL statements used in collection ranking calculation. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional warnCount

warnCount: undefined | number

The total number of warnings produced by occurrences of the statement. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Functions

getDeserializedJsonObj

getJsonObj