The hosts
table was added in MariaDB 10.0 (along with many other new Performance Schema tables).
The hosts
table contains a row for each host used by clients to connect to the server, containing current and total connections.
The size is determined by the performance_schema_hosts_size system variable, which, if set to zero, will disable connection statistics in the hosts table.
It contains the following columns:
Column | Description |
---|---|
HOST |
Host name used by the client to connect, NULL for internal threads or user sessions that failed to authenticate. |
CURRENT_CONNECTIONS |
Current number of the host's connections. |
TOTAL_CONNECTIONS |
Total number of the host's connections |
SELECT * FROM hosts; +-----------+---------------------+-------------------+ | HOST | CURRENT_CONNECTIONS | TOTAL_CONNECTIONS | +-----------+---------------------+-------------------+ | localhost | 1 | 45 | | NULL | 20 | 23 | +-----------+---------------------+-------------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/performance-schema-hosts-table/