Performance Schema hosts Table
Description
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
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
Example
SELECT * FROM hosts;
+-----------+---------------------+-------------------+
| HOST | CURRENT_CONNECTIONS | TOTAL_CONNECTIONS |
+-----------+---------------------+-------------------+
| localhost | 1 | 45 |
| NULL | 20 | 23 |
+-----------+---------------------+-------------------+
This page is licensed: CC BY-SA / Gnu FDL
PreviousPerformance Schema host_cache TableNextPerformance Schema memory_summary_by_account_by_event_name Table
Last updated
Was this helpful?