MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
These views summarize overall statement statistics, grouped by host. By default, rows are sorted by descending total latency.
The
host_summary_by_statement_latency
and
x$host_summary_by_statement_latency
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.totalThe total number of statements for the host.
total_latencyThe total wait time of timed statements for the host.
max_latencyThe maximum single wait time of timed statements for the host.
lock_latencyThe total time waiting for locks by timed statements for the host.
cpu_latencyThe time spent on CPU for the current thread.
rows_sentThe total number of rows returned by statements for the host.
rows_examinedThe total number of rows read from storage engines by statements for the host.
rows_affectedThe total number of rows affected by statements for the host.
full_scansThe total number of full table scans by statements for the host.