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


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

6.38 Sys Schema User Statistics Metrics

Lists the Sys Schema User Statistics metrics and provides a brief description of each.

Table 6.38 Sys Schema User Statistics Metrics

NameDescription
Current ConnectionsThe current number of connections for the user.
Current MemoryThe current amount of allocated memory for the user.
File IO LatencyThe total wait time of timed file IO events for the user.
File IosThe total number of file IO events for the user.
Statement Avg LatencyThe average wait time per timed statement for the user.
Statement LatencyThe total wait time of timed statements for the user.
StatementsThe total number of statements for the user.
Table ScansThe total number of table scans for the user.
Total ConnectionsThe total number of connections for the user.
Total Memory AllocatedThe total amount of allocated memory for the user.
Unique HostsThe number of distinct hosts from which connections for the user have originated.
UserThe client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background.