Performance Schema hosts Table

MariaDB starting with 10.0

The hosts table was added in MariaDB 10.0 (along with many other new Performance Schema tables).

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:

ColumnDescription
HOSTHost name used by the client to connect, NULL for internal threads or user sessions that failed to authenticate.
CURRENT_CONNECTIONSCurrent number of the host's connections.
TOTAL_CONNECTIONSTotal number of the host's connections

Example

SELECT * FROM hosts;
+-----------+---------------------+-------------------+
| HOST      | CURRENT_CONNECTIONS | TOTAL_CONNECTIONS |
+-----------+---------------------+-------------------+
| localhost |                   1 |                45 |
| NULL      |                  20 |                23 |
+-----------+---------------------+-------------------+

Comments

Comments loading...