5.7 Per User Statistics

Table 5.11 Per User Statistics Dashboard

NameDescription

User

The 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.

Current Connections

The current number of connections for the user.

Current Memory

The current amount of allocated memory for the user.

File IO Latency

The total wait time of timed file I/O events for the user.

File IOs

The total number of file I/O events for the user.

Statement Avg Latency

The average wait time per timed statement for the user.

Statement Latency

The total wait time of timed statements for the user.

Statements

The total number of statements for the user.

Table Scans

The total number of table scans for the user.

Total Connections

The total number of connections for the user.

Total Memory Allocated

The total amount of allocated memory for the user.

Unique Hosts

The number of distinct hosts from which connections for the user have originated.