host_summary
You are viewing an old version of this article. View
the current version here.
MariaDB starting with 10.6
The Sys Schema view was introduced in MariaDB 10.6
Description
The host_summary view contains host activity information, grouped by host.
It contains the following columns:
| Column | Description |
|---|---|
| host | |
| statements | |
| statement_latency | |
| statement_avg_latency | |
| table_scans | |
| file_ios | |
| file_io_latency | |
| current_connections | |
| total_connections | |
| unique_users | |
| current_memory | |
| total_memory_allocated |
Example
SELECT * FROM sys.host_summary\G
*************************** 1. row ***************************
host: localhost
statements: 51
statement_latency: 700.00 ms
statement_avg_latency: 13.73 ms
table_scans: 15
file_ios: 6383
file_io_latency: 487.52 ms
current_connections: 1
total_connections: 2
unique_users: 1
current_memory: -31016 bytes
total_memory_allocated: 0 bytes
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.
