Performance Schema status_by_account Table

MariaDB starting with 10.5.2

The status_by_account table was added in MariaDB 10.5.2.

The status_by_account table contains status variable information by user/host account. The table does not collect statistics for Com_xxx variables.

The table contains the following columns:

USERUser for which the status variable is reported.
HOSTHost for which the status variable is reported.
VARIABLE_NAMEStatus variable name.
VARIABLE_VALUEAggregated status variable value

If TRUNCATE TABLE is run, will aggregate the status from terminated sessions to user and host status, then reset the account status.

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.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.