1 of 1

Performance Schema hosts Table

The hosts table contains aggregated connection statistics for each client host, including counts for current and total historical connections.

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

Example

_{This page is licensed: CC BY-SA / Gnu FDL}

Performance Schema hosts Table

The hosts table contains aggregated connection statistics for each client host, including counts for current and total historical connections.

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

Example

_{This page is licensed: CC BY-SA / Gnu FDL}

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

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

Performance Schema hosts Table

hashtagDescription

hashtagExample

Performance Schema hosts Table

hashtagDescription

hashtagExample

Description

Example

Description

Example