host_summary and x$host_summary 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 and x$host_summary views contain host activity information, grouped by host. The host_summary view is intended to be easier for human reading, while the x$host_summary 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).
statementsTotal number of statements for the host.
statement_latencyTotal wait time of timed statements for the host.
statement_avg_latencyAverage wait time per timed statement for the host.
table_scansTotal table scans for the host.
file_iosTotal file I/O events for the host.
file_io_latencyTotal wait time of timed file I/O events for the host.
current_connectionsCurrent connections for the host.
total_connectionsTotal connections for the host.
unique_usersNumber of distinct users for the host.
current_memoryCurrent allocated memory for the host.
total_memory_allocatedTotal allocated memory for the host.

Example

SELECT * FROM sys.host_summary\G
*************************** 1. row ***************************
                  host: localhost
            statements: 59
     statement_latency: 148.11 ms
 statement_avg_latency: 2.51 ms
           table_scans: 11
              file_ios: 2065
       file_io_latency: 79.57 ms
   current_connections: 1
     total_connections: 3
          unique_users: 1
        current_memory: -2672 bytes
total_memory_allocated: 0 bytes

SELECT * FROM sys.x$host_summary\G
*************************** 1. row ***************************
                  host: localhost
            statements: 98
     statement_latency: 160926285000
 statement_avg_latency: 1642104948.9796
           table_scans: 12
              file_ios: 2071
       file_io_latency: 79742533755
   current_connections: 1
     total_connections: 3
          unique_users: 1
        current_memory: -2672
total_memory_allocated: 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.