host_summary_by_statement_latency and x$host_summary_by_statement_latency Sys Schema Views

You are viewing an old version of this article. View the current version here.
MariaDB starting with 10.6

These Sys Schema views were introduced in MariaDB 10.6

Description

The host_summary_by_statement_latency and x$host_summary_by_statement_latency views summarize statement statistics, grouped by host. Rows are sorted by descending total latency by default. The host_summary_by_statement_latency view is intended to be easier for human reading, while the x$host_summary_by_statement_latency view provides the data in raw form, intended for tools that process the data.

They contain the following columns:

ColumnDescription
hostHost that the client connected from, or background for background threads (where the HOST column in the underlying Performance Schema table is NULL).
totalTotal number of statement for the host.
max_latencyMaximum single wait time of timed statements for the host.
lock_latencyTotal time spent by timed statements for the host waiting for locks.
total_latencyTotal wait time of timed statements for the host.
cpu_latencyCPU time spent for the current thread.
rows_sentTotal number of rows returned by statements for the host.
rows_examinedTotal number of rows read from storage engines by statements for the host.
rows_affectedTotal number of rows affected by statements for the host.
full_scansTotal number of full table scans by statements for the host.

Example

SELECT * FROM sys.host_summary_by_statement_latency\G
*************************** 1. row ***************************
         host: localhost
        total: 1042
total_latency: 816.89 ms
  max_latency: 64.51 ms
 lock_latency: 215.64 ms
    rows_sent: 750599937895985
rows_examined: 13548
rows_affected: 6
   full_scans: 33
*************************** 2. row ***************************
         host: background
        total: 0
total_latency: 0 ps
  max_latency: 0 ps
 lock_latency: 0 ps
    rows_sent: 0
rows_examined: 0
rows_affected: 0
   full_scans: 0

SELECT * FROM sys.x$host_summary_by_statement_latency\G
*************************** 1. row ***************************
         host: localhost
        total: 1041
total_latency: 812132706000
  max_latency: 64507216000
 lock_latency: 215301000000
    rows_sent: 750599937895983
rows_examined: 13110
rows_affected: 6
   full_scans: 32
*************************** 2. row ***************************
         host: background
        total: 0
total_latency: 0
  max_latency: 0
 lock_latency: 0
    rows_sent: 0
rows_examined: 0
rows_affected: 0
   full_scans: 0

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.