Performance Schema status_by_host Table

The status_by_host table aggregates session status variables by client host, useful for tracking activity levels from specific application servers.

The status_by_host table is available from MariaDB 10.5.2.

The status_by_host table contains status variable information by host. The table does not collect statistics for Com_xxx variables.

The table contains the following columns:

Column	Description
HOST	Host for which the status variable is reported.
VARIABLE_NAME	Status variable name.
VARIABLE_VALUE	Aggregated status variable value

If TRUNCATE TABLE is run, will reset the aggregated host status from terminated sessions.

If FLUSH STATUS is run, session status from all active sessions are added to the global status variables, the status of all active sessions are reset, and values aggregated from disconnected sessions are reset.

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