Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb


Oracle Enterprise Manager for MySQL Database User's Guide  /  Metrics  /  Sys Schema Statement Analysis Metrics

6.35 Sys Schema Statement Analysis Metrics

Lists the Sys Schema Statement Analysis metrics and provides a brief description of each.

Table 6.35 Sys Schema Statement Analysis Metrics

NameDescription
Avg LatencyThe average wait time per timed occurrence of the statement.
DatabaseThe default database for the statement, or NULL if there is none.
DigestThe statement digest.
Error CountThe total number of errors produced by occurrences of the statement.
Exec CountThe total number of times the statement has executed.
First SeenThe time at which the statement was first seen.
Full ScanIndication with a * character if there has been full table scans performed by occurrences of the statement, or empty if none.
Last SeenThe time at which the statement was most recently seen.
Lock LatencyThe total time waiting for locks by timed occurrences of the statement.
Max LatencyThe maximum single wait time of timed occurrences of the statement.
QueryThe normalized statement string.
Rows AffectedThe total number of rows affected by occurrences of the statement.
Rows Affected AvgThe average number of rows affected per occurrence of the statement.
Rows ExaminedThe total number of rows read from storage engines by occurrences of the statement.
Rows Examined AvgThe average number of rows read from storage engines per occurrence of the statement.
Rows SentThe total number of rows returned by occurrences of the statement.
Rows Sent AvgThe average number of rows returned per occurrence of the statement.
Rows SortedThe total number of rows sorted by occurrences of the statement.
Sort Merge PassesThe total number of sort merge passes by occurrences of the statement.
Tmp Disk TablesThe total number of internal on-disk temporary tables created by occurrences of the statement.
Tmp TablesThe total number of internal in-memory temporary tables created by occurrences of the statement.
Total LatencyThe total wait time of timed occurrences of the statement.
Warning CountThe total number of warnings produced by occurrences of the statement.