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:
Column | Description |
---|---|
host | Host that the client connected from, or background for background threads (where the HOST column in the underlying Performance Schema table is NULL). |
statements | Total number of statements for the host. |
statement_latency | Total wait time of timed statements for the host. |
statement_avg_latency | Average wait time per timed statement for the host. |
table_scans | Total table scans for the host. |
file_ios | Total file I/O events for the host. |
file_io_latency | Total wait time of timed file I/O events for the host. |
current_connections | Current connections for the host. |
total_connections | Total connections for the host. |
unique_users | Number of distinct users for the host. |
current_memory | Current allocated memory for the host. |
total_memory_allocated | Total 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.