These views summarize statement activity, file I/O, and connections, grouped by host.
The host_summary and x$host_summary views have these columns:
-
hostThe host from which the client connected. Rows for which the
HOSTcolumn in the underlying Performance Schema table isNULLare assumed to be for background threads and are reported with a host name ofbackground. -
statementsThe total number of statements for the host.
-
statement_latencyThe total wait time of timed statements for the host.
-
statement_avg_latencyThe average wait time per timed statement for the host.
-
table_scansThe total number of table scans for the host.
-
file_iosThe total number of file I/O events for the host.
-
file_io_latencyThe total wait time of timed file I/O events for the host.
-
current_connectionsThe current number of connections for the host.
-
total_connectionsThe total number of connections for the host.
-
unique_usersThe number of distinct users for the host.
-
current_memoryThe current amount of allocated memory for the host.
-
total_memory_allocatedThe total amount of allocated memory for the host.