Oracle Enterprise Manager for MySQL Database

6.31 Sys Schema IO By Thread By Latency Metrics

Lists the Sys Schema IO By Thread By Latency metrics and provides a brief description of each.

Table 6.31 Sys Schema IO By Thread By Latency Metrics

NameDescription
Average LatencyThe average wait time per timed IO event for the thread.
Max LatencyThe maximum single wait time of timed IO events for the thread.
Min LatencyThe minimum single wait time of timed IO events for the thread.
Process List IdFor foreground threads, the processlist id of the thread. For background threads, NULL.
Thread IdThe thread id
TotalThe total number of IO events for the thread.
Total LatencyThe total wait time of timed IO events for the thread.
UserFor foreground threads, the account associated with the thread. For background threads, the thread name.